Excel
SQL Server

Excel to SQL Server Converter

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

Version
5.8.0
Release Date
Nov. 8, 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 SQL Server 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 SQL Server database.
  • Runs on Windows as a desktop application.
  • The same download exports SQL Server back into Excel. One licence key covers the MySQL 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 SQL Server 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 SQL Server

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

Scroll sideways to see all columns.

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

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

SQL Server

  • SQL Server 2008-2022, including Express editions
  • Azure SQL Database and Amazon RDS for SQL Server
  • SQL Server schemas (dbo, custom schemas)
  • Windows authentication or SQL authentication
Excel

All Excel Tools

Other directions and pairs
SQL Server

All SQL Server Tools

Import and export options

Reverse Conversion

SQL Server 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 SQL Server

1

Setup: connect Excel and SQL Server

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

Excel source

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

SQL Server target

Use the SQL Server connection guide.

2

Tables & mapping: see every SQL Server type before a row moves

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

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.

Verify the copy

With Verify after the run on, the destination is checked when the copy ends: schema, totals and rows. The window shows which tables, rows and columns differ.

How Verify works

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 ↔ SQL Server

Move Excel data into SQL Server

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

Download DBConvert 5.8.0 Order from US$ 199

Windows Windows 10 or later · 51.3 MB