>_QueryLocalCSV & JSON tools that run in your browser

How do I preview the first rows of a CSV file with SQL?

SELECT * FROM data LIMIT 10;

Run this query on the demo dataset →

The fastest way to sanity-check a file you just loaded is SELECT * FROM data LIMIT 10. LIMIT caps the number of rows returned so you're not scrolling through the whole file just to see what columns and types you're working with. This is usually the very first query to run on any new dataset.

A table named data with columns: order_id (integer), customer (text), country (text), category (text), quantity (integer), unit_price (real), order_date (text, YYYY-MM-DD).

Want to run it on your own file? Open it with CSV viewer: your file becomes the table data, and you can paste this query with your own column names.

Related recipes