Convert Excel to SQL
Drop your Excel file and pick your database to get a SQL script with CREATE TABLE and INSERT statements. Each column gets a type, and every fix is listed with its row and column.
4 rows converted, 10 fixes, none rejected
| 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 |
-- 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:
One Excel file, six databases
The sample above, clientes_2024.xlsx, and the type each of its columns gets in each database.
| In the file | First value | PostgreSQL | MySQL | MariaDB | SQLite | SQL Server | Oracle |
|---|---|---|---|---|---|---|---|
| Nº Cliente | 00127 | text | varchar(8) | varchar(8) | TEXT | nvarchar(8) | VARCHAR2(8 CHAR) |
| Nombre | Peña Muñoz | text | varchar(16) | varchar(16) | TEXT | nvarchar(16) | VARCHAR2(16 CHAR) |
| C.P. | 01234 | text | varchar(8) | varchar(8) | TEXT | nvarchar(8) | VARCHAR2(8 CHAR) |
| Alta | 03/02/2024 | date | date | date | DATE | date | DATE |
| Activo | sí | boolean | tinyint(1) | tinyint(1) | BOOLEAN | bit | NUMBER(1) |
| Saldo | 1.234,50 | numeric(6,2) | decimal(6,2) | decimal(6,2) | NUMERIC(6,2) | decimal(6,2) | NUMBER(6,2) |
Load the script into your database
The download is a plain .sql file. Each database runs it with its own tools.
PostgreSQL
psql -v ON_ERROR_STOP=1 -d mydb -f clientes_2024.postgresql.sqlON_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.
MySQL
mysql --default-character-set=utf8mb4 mydb < clientes_2024.mysql.sqlThe script sets utf8mb4 itself; the flag makes the client send it the same way, so accents arrive intact.
MariaDB
mariadb --default-character-set=utf8mb4 mydb < clientes_2024.mariadb.sqlThe script sets utf8mb4 itself; the flag makes the client send it the same way, so accents arrive intact.
SQLite
sqlite3 clientes_2024.db < clientes_2024.sqlite.sqlThe database file is created if it doesn't exist. The converter also downloads a ready .sqlite database, with no command at all.
SQL Server
sqlcmd -S localhost -d mydb -f 65001 -i clientes_2024.sql_server.sql-f 65001 reads the file as UTF-8, so accents and ñ arrive as written.
Oracle
sqlplus user@//localhost/mydb @clientes_2024.oracle.sqlThe script turns off substitution variables (SET DEFINE OFF), so an ampersand in your data stays an ampersand.
The command line loads files straight into a SQLite database for free. With IntoSQL Pro, it and the desktop app also load into PostgreSQL, MySQL and MariaDB. For SQL Server and Oracle, run the script.
What to know about Excel files and each database
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 each database
- Pick the database once the file is open: each one gets the types it supports.
How each kind of value is stored in each database
| Value | PostgreSQL | MySQL | MariaDB | SQLite | SQL Server | Oracle |
|---|---|---|---|---|---|---|
| Yes and no | boolean | tinyint(1) | tinyint(1) | BOOLEAN | bit | NUMBER(1) |
| Whole numbers | integer | int | int | INTEGER | int | NUMBER(10) |
| Large whole numbers | bigint | bigint | bigint | INTEGER | bigint | NUMBER(19) |
| Decimals | numeric(p,s) | decimal(p,s)double | decimal(p,s)double | NUMERIC(p,s)TEXT | decimal(p,s) | NUMBER(p,s) |
| Floating-point numbers | double precision | double | double | REAL | float | BINARY_DOUBLE |
| Dates | date | date | date | DATE | date | DATE |
| Times of day | time | time(6)time | time(6)time | TIME | time | INTERVAL DAY(0) TO SECOND |
| Dates with a time | timestamp | datetime(6)datetime | datetime(6)datetime | DATETIME | datetime2 | TIMESTAMP |
| Dates with a time and offset | timestamptz | datetime(6)datetime | datetime(6)datetime | DATETIME | datetimeoffset | TIMESTAMP WITH TIME ZONE |
| Text | text | varchar(n)textmediumtextlongtext | varchar(n)textmediumtextlongtext | TEXT | nvarchar(n)nvarchar(max) | VARCHAR2(n CHAR)CLOB |
Questions about Excel to SQL
Not answered here? Write to us from the contact page and a person replies. Contact page
How do I convert Excel to SQL?
Drop your file on the converter at the top of this page and choose your database: PostgreSQL, MySQL, MariaDB, SQLite, SQL Server or Oracle. Each one gets the types it supports. Download the script and run it in your database.
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 types does it use in each database?
Each database gets its own: yes and no values are boolean in PostgreSQL, tinyint(1) in MySQL and MariaDB, bit in SQL Server and NUMBER(1) in Oracle. The table on this page lists every kind of value.
Does it keep leading zeros?
Yes. A code such as 00127 stays text in every database, written as '00127', so no zero is lost.
Can it load the data without a script?
Yes. The command line loads into SQLite for free, and with IntoSQL Pro the desktop app and the command line load into PostgreSQL, MySQL and MariaDB. For SQL Server and Oracle, run the script.
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.