MySQL to Excel Converter

MySQL tables in a new .xlsx workbook, one sheet per table, with numbers and dates Excel can work with.

Version: 5.7.0
Release Date: Nov. 4, 2026
Size: 51.3 MB
Platform: Windows 10 or later

Rather not run it yourself?

Let us do the migration →

Export MySQL tables into a new Excel workbook, one sheet per table. Numbers arrive as numbers, and dates as real Excel dates.

Reads the tables of a MySQL database.
Writes an .xlsx workbook. No Microsoft Office or Excel driver is needed.
Runs on Windows as a desktop application.
The same download loads Excel into MySQL. One licence key covers the SQL Server and PostgreSQL pairs too.

What the workbook looks like

One sheet per table

Each sheet is named after its table. A name Excel cannot take, such as one over 31 characters, one with [ ] : * ? / \, or a duplicate, is changed to a valid one.

Column names in the first row

The rows follow underneath. A workbook holds tables, columns, and rows only.

A new file on every run

A workbook already at that path is replaced, and the application warns you before the run. Sheets are not added to an existing workbook.

A job keeps both connections, the table selection, and the options. Run it again from the application, or by name from Task Scheduler with --run-job.

How MySQL values arrive in Excel

In MySQL	In the workbook	What needs attention
Numbers	Numbers.	Excel keeps 15 significant digits. A longer number is written as text, every digit kept.
Dates and date-times	Excel dates, with a date format applied.	Zero dates such as `0000-00-00`, and `TIME` values over 24 hours, arrive as their text.
Text	Text.	Excel holds 32,767 characters per cell. A longer value is refused by name, not cut.
NULL	An empty cell.

Excel's row limit, and what stays in MySQL

A sheet holds 1,048,575 data rows. A larger table is refused by name, never cut short. Keys, indexes, and constraints stay in MySQL: a workbook has no place for them.

Supported versions and services

MySQL

MySQL 5.x, 8.x; MariaDB; Percona Server
Amazon RDS / Aurora MySQL, Azure Database for MySQL, Google Cloud SQL

Excel

Microsoft Excel workbooks (.xlsx)
No Microsoft Office or Excel driver needed

DBConvert Studio

30+ databases · cloud · file import/export

Need more database directions or repeatable file import/export jobs? One tool covers them all.

How to migrate MySQL to Excel

Setup: connect MySQL and Excel

Choose the source and destination connections side by side on one screen. A connection is saved once and reused by every job.

The Setup step in DBConvert for Excel: the source and destination connections side by side, and the job name

MySQL source

Use the MySQL connection guide.

Excel target

Name the .xlsx file to write. A workbook already at that path is replaced; the application warns before the run.

Tables & mapping: see every Excel type before a row moves

Pick the tables, then open one: each MySQL column shows the Excel type it becomes. Change a type or a name in place; the line at the bottom names anything that would fail.

Tables and mapping for MySQL to Excel: the table list and one table's columns with their Excel types

Execution: start it, and the job is saved

Review what the run will do, start it, and read the log as it goes. The job stays in the list to run again or put on a schedule.

A finished MySQL to Excel conversion: the summary and the operation log

Every option, in the guide

Naming rules, table options, row filters, scheduling and the command line work the same for every database pair, so they live in one place.

Open the full guide

See all features

More guides for MySQL ↔ Excel

Move MySQL data into Excel

Download the current build and run the first job against your own database.

Download DBConvert 5.7.0 Order from US$ 199

Windows 10 or later · 51.3 MB