Database administrator with a laptop in a server room aisle

Database administrator checking query results on two monitors

Excel to SQLite script with typed columns

Upload the Excel file, choose SQLite as the dialect, set the table name and convert. Run the downloaded script with the sqlite3 shell or any SQLite client to create and fill the table.

XLSX Encrypted, deleted after conversion

XLS, XLSX, XLSM, XLSB, ODS, CSV, TSV, Numbers, JSON, XML

Google Sheets share link

Convert to

Encrypted, auto-deleted

Demo converts up to 100 rows, once.

Sheet

Delimiter

Encoding

JSON shape

Minify JSON

SQL dialect

Table name

Wrap in a transaction

Dates

Row element

Orientation

Workbook password (if protected)

Trim spaces in every cell Remove duplicate rows Drop empty columns Stack all sheets into one table

SQLite is the easiest way to query a spreadsheet with real SQL, ship data inside an app or hand a single file database to an analyst. XlsConverter writes a SQLite flavored script from any Excel sheet, so you skip the CSV import step and its type guessing.

The script follows SQLite conventions rather than generic SQL. For server databases use Excel to MySQL or Excel to PostgreSQL instead.

How to convert Excel to SQLite in three steps

1Upload the XLSX or XLS workbook.
2Select the sheet, choose the SQLite dialect and name the table.
3Convert, download the .sql file and run it with sqlite3 or your client.

SQLite has no date type, so plan for it

SQLite stores dates as TEXT, REAL or INTEGER, and its date functions only understand ISO 8601 strings, Julian day numbers or Unix time. The converter writes ISO text such as 2026-10-07 14:30:00, which keeps sorting correct and lets you call date() and strftime() directly.

Booleans are another quiet difference. SQLite has no BOOLEAN storage, so TRUE and FALSE cells become 1 and 0. Excel percentages become REAL values (0.15, not 15%), and currency formatting is dropped in favor of the plain number, which is what you want for arithmetic.

Speed depends on transactions. Without a wrapping transaction SQLite commits every INSERT separately, which is painfully slow on large sheets. The script wraps everything in one transaction by default. If you only need a quick look at the data, XLSX to CSV plus the sqlite3 import command also works, and the general XLSX to SQL page explains the inference rules.

Options for Excel to SQLite

Table per sheet: Write one CREATE TABLE and INSERT block for each worksheet in the workbook, or only for the sheet you pick.
Type affinity: Columns are declared as INTEGER, REAL or TEXT so SQLite applies the right affinity on insert.
Date format: Dates are written as ISO 8601 text, which works with SQLite date and time functions.
Transaction wrapper: Wrap all inserts in BEGIN and COMMIT so large sheets load in seconds instead of minutes.

Run it automatically

Teams that rebuild a local SQLite file from a shared workbook can automate it: a pipeline watches a Dropbox or Google Drive folder, converts every new version to a SQLite script and delivers it by webhook or SFTP. Details are on the automation page.

Excel to SQLite questions

How do I convert an Excel spreadsheet to a SQLite database?

Convert the sheet to a SQLite SQL script, then run it with the sqlite3 shell using .read file.sql. The script creates the table and inserts every row.

Does SQLite keep Excel date formats?

SQLite has no date type, so dates are stored as ISO 8601 text, which SQLite date functions read natively.

Can I convert every sheet into its own SQLite table?

Yes. Enable one table per sheet and each worksheet gets its own CREATE TABLE and INSERT block in the same script.

Why is my SQLite import so slow?

Each INSERT outside a transaction is committed on its own. The converter wraps the script in a single transaction to avoid that.

Can I test Excel to SQLite on my own file first?

We offer a one-time demo of up to 100 rows. Full workbooks need a paid plan, starting at 24 USD per month billed yearly.

Related converters

XLSX to SQL Excel to MySQL Excel to PostgreSQL CSV to SQL XLSX to CSV

Convert full files and batches

Pro starts at $24 per month billed yearly. Cancel any time.

See plans