Reads the first row as headers by default and rewrites
empty, duplicate, or symbol-laden header text into clean
MySQL column names - reserved words are backtick-quoted
(`order`), merged-cell layouts are unflattened,
and you can override the header row in the wizard.
Samples real values per column and proposes one strict MySQL
target type in the type-mapping review - columns with
numbers, dates, text, and error values mixed together are
flagged so you pick VARCHAR or widen the type
rather than losing rows to silent coercion.
Reads the underlying stored value rather than the displayed
format - ZIP codes, SKUs, long IDs, and date serials
travel intact when you mark those columns as
VARCHAR instead of accepting Excel's auto-typing.
Lets you map every sheet to a separate MySQL table, or
select one range as the table, or feed several Excel files
into the same target table - pick the layout in the
wizard.
Saves the migration as a session so a recurring spreadsheet
rerun (weekly refresh, monthly load) replays the same
mapping; pick append-or-replace policy and (if you set a
primary key) deduplication semantics in the wizard.
DBConvert treats the workbook as a data source: sheets, ranges, columns, and
values become tables, columns, and rows. Formulas, workbook formatting, charts,
pivot tables, validation rules, and Excel VBA are not converted into MySQL
application logic - those rules are reimplemented in the database or in the
application as a separate workstream.
Windows 10 or later