Excel to SQLite
Turn a workbook into a queryable database.
When to use it
Use it to turn a spreadsheet into a database you can query with SQL, or to give an app data in SQLite form.
How it works
- Choose a file, or drop it onto the box above.
- The first row becomes the column names.
- Press the Convert to SQLite button.
- Download the result, or add a next step without downloading.
Supported formats
- Input
- XLSX, XLSM
- Output
- SQLite
- Files
- One file at a time
Where your file goes
This tool runs in your browser: the file is processed on your device and is not uploaded. The Network tab of your browser's developer tools shows this.
On first use, your browser downloads the code this tool needs from this site. Your file is not sent anywhere.
What is kept, and what is not
Leading zeros are kept as text. Integers beyond safe range stay text. Formula cells store their computed value.
Limits
- Only XLSX and XLSM workbooks are accepted. For a CSV file, convert it to Excel first.
- Files up to 512 MB each.
- The work happens in your device's memory, so a phone may fail on a file that a computer handles.
If something goes wrong
Column names look wrong
The first row of each sheet becomes the column names. Put a header row at the top and remove empty rows above it.
The page becomes slow with a very large file
Close other tabs, or use a computer instead of a phone.
My file is not accepted
Check the formats listed above. A damaged file, or one with the wrong extension, is refused with a message saying why.
Questions
What happens to each sheet?
Each sheet becomes a table in the database.
Are leading zeros and long numbers kept?
Yes. Leading zeros and integers beyond the safe range are stored as text, and formulas store their computed value.
Continue with the result
The result can go straight into another tool on this page, without downloading it and uploading it again: