MySQL for Excel

Abstract

This is the MySQL™ for Excel Reference Manual. It documents MySQL for Excel 1.3 through 1.3.8. Much of the documentation also applies to the previous 1.2 series.

For notes detailing the changes in each release, see the MySQL for Excel Release Notes.

For legal information, see the Legal Notices.

For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.

Document generated on: 2020-08-02 (revision: 66876)

---

Table of Contents

Preface and Legal Notices

1 Introduction

2 Installation

3 Configuration

3.1 MySQL Connections in Excel

3.2 New Schema Creation in Excel

3.3 Global Options

4 Edit MySQL Data in Excel

4.1 Edit Session Overview

4.2 Multiple Edit Sessions

5 Import MySQL Data into Excel

5.1 Importing a Procedure

5.2 Import — Advanced Options

5.3 Adding Summary Fields

5.4 Creating PivotTables

6 Append Excel Data into MySQL

6.1 Column Mappings

6.2 Append — Advanced Options

7 Export Excel Data into MySQL

7.1 Column Options

7.2 Export — Advanced Options

7.3 Additional Notes

8 What is New in MySQL for Excel

8.1 What is New in MySQL for Excel 1.3

8.2 What is New in MySQL for Excel 1.2

9 MySQL for Excel Frequently Asked Questions