CSVQuery
View and explore a CSV file online
Open a CSV file in a readable table, filter each column and check statistics, without installing anything.
Drop a CSV file here or click to choose one
SQL query
Chart
Column summary
What you can do with the CSV viewer
- Read the file as a table, with a filter box under every column.
- Sort and narrow the rows with a short SQL query.
- See each column’s type, empty cells, distinct values, minimum, maximum and average.
- Draw a quick chart of what you see.
Sort and limit the rows
SELECT * FROM data ORDER BY price DESC LIMIT 50
Commas, semicolons, tabs and pipes are detected automatically, so exports from Excel, databases and analytics tools open correctly.
Frequently asked questions
Which separators and encodings are supported?
Comma, semicolon, tab and pipe separators are detected automatically. The file is read as UTF-8.
Why does the table show only 500 rows?
The table shows the first 500 rows to stay fast. Filters and queries still search every row of the file.
Can I open Excel files?
Not yet. Save the sheet as CSV from Excel, then open it here.