CSV Viewer
Local only — nothing is uploaded unless you save or share it.
A CSV viewer that opens a file as a table you can search and sort. Nothing is uploaded.
- Drop the CSV or TSV file on the page, or paste its text into the box.
- Check the separator and header row, then filter or press a heading to sort.
- Download the rows you kept as a CSV, or copy them into a spreadsheet.
Press a column heading to sort by it, again to reverse, a third time for the file's order.
Save this tool
Keep CSV Viewer handy
Use your browser's Share menu, then “Add to Home Screen”.
Embed
Put CSV Viewer on your website
Paste this into your page. It shows the tool, free, with a link back to it.
About this tool
Drop a file on this CSV viewer, or paste the text, and it opens as a table: the separator is detected for you, whether the file uses commas, semicolons, tabs or pipes, and the first row is read as the column names unless you say otherwise. Type in the filter to keep only the rows that contain something, and press a column heading to sort by it. Sorting reads a column the way a person does: when every cell in it is a number, including the shapes spreadsheets export such as 1,234.50, 12 % or $3, it sorts as numbers, so 100 comes after 9; otherwise it sorts as text, with file 9 before file 10. Empty cells always go last. It is a quick way to open a CSV file without Excel, and without Excel's habits: nothing is turned into a date, no leading zero is dropped from a postcode, and a long number is not shortened. Quoted fields that contain the separator, a line break or a quote are read correctly, because the parser is the same one our CSV to JSON converter uses. A file saved by Excel on Windows in its old Western European encoding is recognised, so names with æ, ø or é come out right. Big files are fine: only one page of rows is drawn at a time, so a file of a hundred thousand rows stays quick to search and sort. When you have the rows you want, download them as a CSV, or copy them to paste straight into a spreadsheet. The file is read in your browser and is not uploaded.
Frequently asked questions
How do I open a CSV file without Excel?
Drop it here. The file opens as a table in your browser, with no program to install and no account. Unlike Excel, nothing is reformatted on the way in: dates stay as written, postcodes and phone numbers keep their leading zeros, and long numbers are not shortened.
Why is everything in one column?
Because the file uses a different separator from the one being read. Danish, German and most other European exports use semicolons, since the comma is their decimal mark, and some systems use tabs or pipes. The separator is detected from the first line, and if the guess is wrong you can pick it from the list.
How big a file can it open?
Without an account up to 50 MB; with any account up to 500 MB, which is about five million rows of a typical export and about as much text as a browser can hold at all, so it is not a plan setting. Only one page of rows is drawn at a time, so searching and sorting stay quick even near the limit.
How does sorting handle numbers?
A column sorts as numbers when every filled cell in it reads as one: plain numbers, thousands separators, a comma or a point as the decimal mark, percentages, currency signs and negative amounts in brackets. Anything else sorts as text, in a natural order where 9 comes before 10. Empty cells go last whichever way you sort.
Can I save the rows I filtered?
Yes. Download gives you exactly the rows that match the filter, in the order they are sorted, as a CSV with the same separator as the file. Copy puts them on the clipboard separated by tabs, which a spreadsheet splits into columns when you paste.
Is my file uploaded?
No. The file is read and parsed in your browser, and the table is drawn there. Nothing about its contents is sent anywhere.
Help improve this tool
Found a bug, want a change, or need a tool we don't have?
You have an unsent draft.
Thanks — that's with us. You'll find the reply in your inbox.Go to my messages