Excel
MySQL

Excel to MySQL Converter

Each sheet of an .xlsx workbook becomes a MySQL table, with column types chosen from the values in it.

Version
5.7.0
Release Date
Nov. 4, 2026
Size
51.3 MB
Platform
Windows 10 or later
Download DBConvert Order from US$ 199

Rather not run it yourself?

Let us do the migration →

Load the sheets of an Excel workbook into MySQL as tables. DBConvert reads the .xlsx file itself, picks each column's type from its values, and writes the rows to the server.

  • Reads .xlsx workbooks. No Microsoft Office or Excel driver is needed.
  • Writes to a MySQL server, or to a MySQL dump .sql file.
  • Runs on Windows as a desktop application.
  • The same download exports MySQL back into Excel. One licence key covers the SQL Server and PostgreSQL pairs too.

What the workbook needs

The .xlsx format

An older .xls file does not open. Save it as .xlsx in Excel first, then convert the copy.

Column names in the first row

Each sheet becomes a table, and its first row holds the column names. A sheet with nothing in it is not listed.

Any number of rows

Sheets are read a row at a time, so a full sheet of 1,048,576 rows loads too.

What happens to the cells

  • Empty rows are skipped. An empty cell becomes NULL.
  • Dates are recognised by the cell's number format, including workbooks that use the 1904 date system.
  • TRUE and FALSE cells arrive as the text TRUE and FALSE.
  • Error cells such as #N/A or #DIV/0! arrive as NULL and are named in the run log.
  • A column without a name gets one, such as Field2. Two names that differ only in case get a suffix, such as Name_2, so MySQL accepts both.

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 Excel columns map to MySQL

The type is chosen from every value in the column. Review or change it per column before the run.

Values in the column DBConvert default in MySQL
Whole numbers INT, or BIGINT once a value passes 32 bits.
Fractions DECIMAL(p,s), wide enough for every value in the column.
Numbers Excel shows with an exponent DOUBLE
Dates DATE without a time, DATETIME with one.
Text, or a mix of kinds LONGTEXT

Formulas, formatting, and macros stay in Excel

DBConvert moves the data in the cells. Formulas, formatting, charts, pivot tables, data validation, macros, and VBA are the workbook's logic, not its data, and are not converted.

Supported versions and services

Excel

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

MySQL

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

All Excel Tools

Other directions and pairs
MySQL

All MySQL Tools

Import and export options

Reverse Conversion

MySQL to Excel

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 Excel to MySQL

1

Setup: connect Excel and MySQL

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

Excel source

Select the .xlsx workbook. Each sheet with data is listed as a table, its first row read as the column names.

MySQL target

Use the MySQL connection guide, or choose a MySQL dump .sql file instead of a server.

2

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

Pick the tables, then open one: each Excel column shows the MySQL 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 Excel to MySQL: the table list and one table's columns with their MySQL types
3

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 Excel to MySQL 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.

See all features

More guides for Excel ↔ MySQL

Move Excel data into MySQL

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

Download DBConvert 5.7.0 Order from US$ 199

Windows Windows 10 or later · 51.3 MB