Excel
PostgreSQL

Excel to PostgreSQL Converter

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

Version
5.4.0
Release Date
Oct. 25, 2026
Size
52.1 MB
Platform
Windows 10 or later

Rather not run it yourself?

Let us do the migration →

Load the sheets of an Excel workbook into PostgreSQL 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 PostgreSQL database.
  • Runs on Windows as a desktop application.
  • The same download exports PostgreSQL back into Excel. One licence key covers the MySQL and SQL Server 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 PostgreSQL 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 PostgreSQL

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 PostgreSQL
Whole numbers integer, 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 double precision
Dates date without a time, timestamp with one.
Text, or a mix of kinds text

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

PostgreSQL

  • PostgreSQL 8.x through 17.x
  • Amazon RDS / Aurora for PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL, Supabase
  • PostgreSQL schemas (public, custom schemas)

How to migrate Excel to PostgreSQL

1

Setup: connect Excel and PostgreSQL

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.

PostgreSQL target

Use the PostgreSQL connection guide.

Move Excel data into PostgreSQL

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

Windows Windows 10 or later · 52.1 MB