Convert CSV to a SQLite database without uploading anything
Large CSV exports quickly become awkward in a spreadsheet, especially when you need to compare several files. This page turns one or more CSV files into a single .sqlite database that you can query with SQL. Each file becomes a table named after the filename. Headers become column names, and numeric values remain numbers so sorting and aggregation work correctly. The conversion uses the SQLite engine compiled to WebAssembly through sql.js, so the output is a standard SQLite database. Sales exports and customer records remain on your device.
How it works
- Drop one or more .csv files. Each becomes a table named after its file.
- Column names come from the header rows; numbers are stored as numbers.
- Download the single .sqlite database and start querying.
Frequently asked questions
What do I open the .sqlite file with?
Any SQLite client: DB Browser for SQLite (free, graphical), DBeaver, or the sqlite3 command-line tool that ships with macOS and most Linux distributions. It’s a standard SQLite database file, so anything that speaks SQLite can query it.
Is this really SQLite, or a lookalike?
It is SQLite itself. The official source compiled to WebAssembly as sql.js and run in your browser. The database it writes is a normal SQLite file, which is why every standard tool opens it.
Can I trust this with confidential business data?
The database is built in your browser’s memory and downloaded from there. No server receives the CSV files or the resulting database. You can disconnect after the page loads and the conversion will still work.
How large can the CSVs be?
There’s no artificial limit. The constraint is your device’s memory, since the database is assembled in RAM. Files in the hundreds of megabytes are routine on a modern laptop; multi-gigabyte inputs can work but depend on how much memory your machine and browser will give the page.