Home / Data / SQL on CSV & Excel

SQL on CSV & Excel

Run SQL queries on CSV, Excel and JSON files, join them together, and export the result.

Free, no uploads, no sign-up. Runs 100% in your browser.

How SQL on CSV & Excel works

Every file and sheet is loaded into an in-memory SQLite database (sql.js, compiled to WebAssembly) as its own table with guessed column types. You can join, filter, group and sum with normal SQL.

Input: CSV, TSV, XLSX, ODS, JSON, JSONL. Output: CSV, JSON, SQLITE.

How to use SQL on CSV & Excel

1. Drop one or more data files.
2. Click a table or column to insert it, or start from an example.
3. Run the query.
4. Export CSV or JSON, or save everything as a SQLite file.

Tips

• Nothing is uploaded. Your files stay in this browser tab.

SQL on CSV & Excel FAQ

Are my files uploaded?

No. This tool runs entirely in your browser tab. Files are read from your disk into memory and the result is generated locally.

Is it free? Are there limits or watermarks?

Free and open source (MIT). There are no file-size caps, daily quotas, accounts or watermarks.

Does it work offline?

Yes, once the page (and any engine it needs) has loaded, it keeps working without a connection thanks to the service worker cache.

Related tools

• SQLite Browser: Open .db and .sqlite files, browse tables, run SQL and export results to CSV or JSON.
• Data Profiler: A quick health check of any CSV, Excel or JSON file: column types, empty cells, ranges, outliers, duplicates and correlations.
• Spreadsheet Lookup & Join: Bring columns from one sheet into another by a shared key, like VLOOKUP, or find rows missing from the other file.
• Data Format Converter: Convert between JSON, YAML, XML, TOML, INI, CSV, NDJSON, MessagePack, CBOR and BSON.