Query a file with SQL

How it works

• The table is called “dades”. Load your file and write a query: SELECT * FROM dades. The columns and their types are listed alongside.
• Ready-made examples. The example queries use your file's own columns: one click gives you a count or a total per category.
• Export the result. To CSV, Excel, JSON or Parquet, with the same options as the converter.

Which SQL you can use

DuckDB's, which is very close to PostgreSQL: WHERE, GROUP BY, ORDER BY, subqueries, WITH, window functions, PIVOT and plenty of text and date functions. Only read queries are allowed: the file cannot be modified and no other file can be read.

Your file is never uploaded

The query runs inside your browser using DuckDB, with no access to the network or to any other file on your computer. Your data is not sent to any server, not even ours. We only count how often the tool is used, anonymously.