CSV viewer with SQL

Open a CSV file, run SQL on it, filter and export the result. The file never leaves your device.

Processed on your device, never uploaded

CSV file

Drop a CSV file

Or paste it below. The first run downloads the SQL engine (about 34 MB), then it stays on your device.

Or paste CSV

SQL

Query on the table "data"

Result

Load a CSV file. The result of your query appears here.

What it does

The CSV viewer loads a table into a small database that runs in your browser. You write ordinary SQL against a table called data. The file never leaves your device.

How to use it

1Drop a CSV file or paste CSV.
2Write a query, or start from a ready one.
3Export the result as CSV or JSON.

Questions

Is my file uploaded?

No. The file and the query stay on your device. The SQL engine itself is a one-time download of about 34 MB.

How large a file can it open?

Files of several hundred MB work on most computers, because the file is read in pieces.

Which SQL does it use?

DuckDB SQL, which is close to standard SQL. Try SUMMARIZE data for a quick overview.