Convert EXCEL to SQL from cloud storage or website

Value kind	in EXCEL	in SQL
Int	`1234 (a real numeric cell)`	`INT`
Bigint	`9007199254740993 (exact only while the cell stays text)`	`BIGINT`
Decimal	`1234.56 (numeric cell, format controls the displayed decimals)`	`DECIMAL(p,s)`
Float	`1.234E+10 (numeric cell)`	`DOUBLE PRECISION`
Text	`text cell; leading zeros survive only if the column is text`	`VARCHAR(n)`
Long text	`text cell; wraps inside the cell rather than the row`	`TEXT / CLOB`
Date	`a serial number plus a date cell format`	`DATE`
Datetime	`a serial number plus a date-time cell format`	`TIMESTAMP`
Binary	`not representable as data`	`BLOB / BYTEA`
Boolean	`TRUE / FALSE (a real boolean cell)`	`BOOLEAN / SMALLINT`
JSON	`a text cell; the quotes are part of the value`	`JSON / TEXT`

Both EXCEL and SQL are file formats, so what differs below is how each one chooses to represent a value.

Property	in EXCEL	in SQL
identifiers	`Not applicable; a cell holds exactly one value`	`Two competing conventions: single-quoted literals and diale...`
dates	`Stored as a serial number; only the cell format makes it lo...`	`Depends on the dialect: DATE literals, TO_DATE(), or plain ...`
binary	`Only as text or an embedded object, not as a data column`	`Dialect-specific: X-quoted literal, 0x hex, or decode()`
separator	`Cells, not delimiters`	`Statement terminators (;)`
encoding	`UTF-8 internally, declared in the package`	`No declaration`
typing	`Real cell types: text, number, date, boolean, error`	`Types belong to the target database, and they differ betwee...`
shape	`Multiple sheets, each a flat grid`	`Statements; a dump usually means CREATE TABLE plus INSERT rows`
ceiling	`1,048,576 rows x 16,384 columns per sheet; 255 sheets per w...`	`No formal limit, but a single INSERT statement has to fit i...`

Data File Converter without the manual work

For batch jobs, large files and scheduling use the Data File Converter converter — an offline desktop app for Windows, Linux and macOS. Free trial.