Online CSV Viewer
Open a CSV or TSV file as a table you can scroll, search and sort, even when it is too large for Excel. The delimiter and column types are detected for you, and the file never leaves your browser.
Next steps
Quick start
- 1
Open the CSV file
Choose or drop a .csv, .tsv or .txt file, or try the sample file. It is read in your browser, not uploaded.
- 2
Check the columns
The header row, column types and delimiter are detected for you. If the columns look wrong, pick the delimiter yourself.
- 3
Search, sort and scroll
Search every column at once, sort by any column, and scroll to load more rows.
- 4
Export what you see
Download the rows you are viewing, with your search and sort applied, as CSV or JSON.
Data stays on your device
The file is read by DuckDB running as WebAssembly in your browser. It is not uploaded.
A read-only viewer for CSV and TSV files. It shows every row in a scrollable table with the row count, lets you search all columns and sort by any column, and exports what you are viewing as CSV or JSON. It works on files with millions of rows because the data is handled by DuckDB in your browser instead of a spreadsheet.
Up to 1.5 GB
File size
In your browser
Processing
CSV, JSON
Export
Large files
Open CSVs up to 1.5 GB, far beyond Excel's 1,048,576-row limit. Rows load as you scroll.
Search and sort
Search every column at once and sort by any column. Numbers and dates sort by value.
Delimiter detection
Comma, semicolon, tab and pipe files open without settings, with a menu to override the delimiter.
CSV and JSON export
Download the rows you are viewing, with your search and sort applied.
Private
Your file is not uploaded. Everything runs in your browser.
How do I open a CSV file without Excel?
Choose the file above or drop it on the viewer. It opens as a table in your browser, with no software to install and no account. The viewer only reads the file; it never changes or saves it.
Can I open a large CSV file?
Yes, up to 1.5 GB. The file is read by DuckDB, a database engine that runs in your browser, so you are not limited to Excel's 1,048,576 rows. Files up to 300 MB are loaded into memory, which keeps searching and sorting quick. Larger files are read from disk as you browse, so searching or sorting them reads the whole file each time and takes longer. For files over 1.5 GB, split them with the CSV Splitter first.
How is the delimiter detected?
DuckDB samples the start of the file and works out the delimiter, quoting, whether the first row is a header, and the type of each column. Commas, semicolons, tabs and pipes all work. If the columns come out wrong, choose the delimiter from the Delimiter menu and the file reopens with it.
Can I open TSV files?
Yes. Tab-separated .tsv and .txt files open the same way as CSV files. The tab delimiter is detected automatically.
Is my CSV file uploaded?
No. The file is read in your browser tab and is not sent to ChatDB or anywhere else. Only the DuckDB engine (about 8 MB) is downloaded, the first time you open a file.
Why are all my columns shown as text?
Column types are detected from the top of the file. If a value further down does not fit, for example the word N/A in a column of numbers, the viewer reopens the file with every column as text so no row is lost. Sorting is then alphabetical, so 10 comes before 9.
Can I edit the CSV file here?
No, this viewer is read-only, so you cannot change a file by accident. To change cells or add rows, use the CSV Editor. You can export the rows you are viewing as CSV or JSON.
Can I open a .csv.gz or Excel file?
Not in this viewer. Open gzip-compressed CSV files in the Gzip CSV Reader, and .xlsx, .xls or .ods workbooks in the Excel Viewer.
What is a CSV file?
A CSV (comma-separated values) file is a table saved as plain text: one row per line, with the values in each row separated by a comma. Many exports use a semicolon, a tab (TSV) or a pipe instead. Any text editor can open a CSV, but a large file is hard to read that way, and spreadsheet apps change values as they open them, dropping leading zeros or turning long IDs into scientific notation. This viewer shows the file as a table and leaves the file itself untouched.
Example: checking an export
Press Try a sample file above to open an orders export with 2,000 rows and 10 columns. Sort by total to see the largest orders, or search for Canada to see only the rows that mention it, with the match count above the table. Numbers are detected as numbers, so total sorts by value rather than alphabetically. Press CSV or JSON to download the rows you are looking at.
Limits and related tools
- Files up to 1.5 GB and up to 2,000 columns.
- UTF-8 files open directly. Files saved as UTF-16 with a byte order mark, or Shift-JIS, are converted first. For other encodings, convert the file with the CSV Encoder.
- Exports contain up to 200,000 rows. To convert a whole file, use the CSV to Parquet converter or the CSV to JSON converter.
- To change values, use the CSV Editor. To group and total rows, use Query CSV with SQL. To break a big file into parts, use the CSV Splitter.
- Compressed .csv.gz files open in the Gzip CSV Reader, and Excel workbooks in the Excel Viewer.