Convert Excel to PostgreSQL

Drop your Excel file to get a PostgreSQL script with CREATE TABLE and INSERT statements. Each column gets a type, and every fix is listed with its row and column.

OutputSheetHeader rowDates

4 rows converted, 10 fixes, none rejected

Your fileSQL10 fixes

The first rows of clientes_2024.xlsx, with each fix marked
Row
5	00127	Peña Muñoz	01234	03/02/2024	sí	1.234,50
6	00128	José Ángel	09870	15/02/2024	no	N/A
7	00129	Zoë Ortíz	44100	29/02/2024	sí	-12,00
8	00130	Ñuño Castañeda	06700	11/03/2024	no	980,75
9
10
11
12
13
14

-- Written by IntoSQL for PostgreSQL.

SET client_encoding = 'UTF8';
BEGIN;

CREATE TABLE clientes_2024 (
    no_cliente text NOT NULL,
    nombre text NOT NULL,
    c_p text NOT NULL,
    alta date NOT NULL,
    activo boolean NOT NULL,
    saldo numeric(6,2)
);
COMMENT ON COLUMN clientes_2024.no_cliente IS 'Nº Cliente';
COMMENT ON COLUMN clientes_2024.c_p IS 'C.P.';

INSERT INTO clientes_2024 (no_cliente, nombre, c_p, alta, activo, saldo) VALUES
('00127', 'Peña Muñoz', '01234', '2024-02-03', TRUE, 1234.50),
('00128', 'José Ángel', '09870', '2024-02-15', FALSE, NULL),
('00129', 'Zoë Ortíz', '44100', '2024-02-29', TRUE, -12.00),
('00130', 'Ñuño Castañeda', '06700', '2024-03-11', FALSE, 980.75);

COMMIT;

Fixes

The header is on row 4; the rows above it were left out.
Row 9 ("TOTAL") is a total, so it was left out.
Column "Nº Cliente" is named no_cliente so PostgreSQL reads it without quotes.
Column "C.P." is named c_p so PostgreSQL reads it without quotes.
Leading zeros kept in "Nº Cliente": 00127 stays 00127, stored as text.
Leading zeros kept in "C.P.": 01234 stays 01234, stored as text.
15/02/2024 proves the dates in "Alta" are day-first, so 03/02/2024 is read as 2024‑02‑03.
"Activo" holds yes and no words (sí, no), stored as boolean.
Numbers in "Saldo" use a decimal comma: 1.234,50 is read as 1234.50.
N/A in "Saldo" read as empty (1 of 4 values).

Your file is converted on this computer and never uploaded.

Other samples:

From Excel to PostgreSQL, column by column

The sample above, clientes_2024.xlsx, as IntoSQL writes it for PostgreSQL: what each column holds in the file, the type it gets and how its first value lands in the script.

In the file	First value	Column	PostgreSQL type	In the script
Nº Cliente	00127	no_cliente	text	'00127'
Nombre	Peña Muñoz	nombre	text	'Peña Muñoz'
C.P.	01234	c_p	text	'01234'
Alta	03/02/2024	alta	date	'2024-02-03'
Activo	sí	activo	boolean	TRUE
Saldo	1.234,50	saldo	numeric(6,2)	1234.50

Load the script into PostgreSQL

The download is a plain .sql file. Run it with PostgreSQL's own tools.

From a terminal

$psql -v ON_ERROR_STOP=1 -d mydb -f clientes_2024.postgresql.sql

ON_ERROR_STOP makes psql stop at the first error. The script runs in one transaction, so a failed load leaves the database as it was.

From a database tool

In pgAdmin or DBeaver, open the script in a query window and run it.

Without a scriptPro

IntoSQL Pro loads the file straight into PostgreSQL from the desktop app or the command line, without writing a script.

$intosql load clientes_2024.xlsx --into postgres://user@localhost/mydb

What to know about Excel files and PostgreSQL

What IntoSQL reads in Excel files

The header row is found even when titles or notes sit above it, and a totals row at the end is left out.
Dates stored as Excel serial numbers become real dates, in both the 1900 and the 1904 date systems.
Codes with leading zeros, like 00127, stay text. When a workbook has several sheets, you pick the sheet.

What to know about PostgreSQL

Decimals keep their exact digits as numeric(p,s), and dates with an offset become timestamptz.
PostgreSQL text can't hold the NUL character, so it is removed from the values that have one.
The script runs in one transaction, so a load that fails leaves nothing half done.

How each kind of value is stored in PostgreSQL

Value	PostgreSQL
Yes and no	boolean
Whole numbers	integer
Large whole numbers	bigint
Decimals	numeric(p,s)
Floating-point numbers	double precision
Dates	date
Times of day	time
Dates with a time	timestamp
Dates with a time and offset	timestamptz
Text	text

Questions about Excel to PostgreSQL

Not answered here? Write to us from the contact page and a person replies. Contact page

How do I convert Excel to PostgreSQL?

Drop your file on the converter at the top of this page. It finds the header, reads every value and writes the PostgreSQL script, listing each fix it made. Download the script and run it with psql.

Which sheet of the workbook is converted?

The first visible sheet. When a workbook has more than one, a Sheet option appears, so you can pick another.

Which PostgreSQL types does it use?

Yes and no values become boolean, whole numbers integer, decimals numeric(p,s), dates date, dates with a time timestamp and text text. Sizes come from the longest value in each column.

Does it keep leading zeros in PostgreSQL?

Yes. A code such as 00127 stays text, so PostgreSQL stores it as text and the script writes it as '00127'.

Can it load the data into PostgreSQL without a script?

Yes, with IntoSQL Pro. The desktop app and the command line connect to PostgreSQL and load the rows straight in, creating the table first.

How big can the Excel file be?

In the browser, a workbook is read whole, so the limit is the memory the browser gives this page. The desktop app and the command line take workbooks of any size; on an Apple M4 laptop the command line converts a 117 MB workbook of a million rows in about a second.