About CSV Viewer
Open a CSV or TSV file as a table you can read, search and sort. Paste the data or open a file from your computer, and the tool shows it as a table with a header row. Click a column heading to sort, type in the filter box to find rows, and download just the rows you are looking at. The file is read in your browser and never uploaded.
How to use CSV Viewer
- Paste CSV into the box, press Open file to choose a .csv, .tsv or .txt file, or press Sample.
- Leave Delimiter on Auto-detect, or choose comma, semicolon, tab or pipe. Untick First row contains column names if there is no header.
- Click a column heading to sort ascending, click again for descending, and a third time to go back to the original order.
- Type in Filter rows to keep only rows where any column contains your text, then press Download shown rows to save them as a CSV.
Tips and good to know
- A column sorts as numbers when every filled cell is a number, so 9 comes before 10. Otherwise it sorts as text, ignoring upper and lower case and treating digits naturally, so b2 comes before b10. Codes with a leading zero, such as 007, sort as text.
- Empty cells always come last, whichever direction you sort.
- Quoted fields can contain commas, quote marks and line breaks. The first rows decide the auto-detected delimiter, so choose it by hand if the guess is wrong.
- If some rows have more or fewer cells than the header, a Heads-up chip says how many. Short rows are padded with empty cells, and extra cells get headings such as Column 4.
- Large files show 100 rows per page with Previous and Next buttons. Files over about 2 million characters are refused so the page stays fast.
- Download shown rows saves the current filter and sort order, using your delimiter, with quotes only where needed.
Frequently asked questions
Does this change my file?
No. It only shows the data. Sorting and filtering affect what you see, and the original file is untouched. The download is a new file.
Why is a column sorted in an odd order?
If even one filled cell in the column is not a number, the whole column is sorted as text. Check the column for stray words, spaces or symbols.
Why do I see Column 1, Column 2 instead of names?
Either First row contains column names is unticked, or a heading cell in your file was empty. Empty headings are named by their position.
Can it open Excel files?
No. Save the sheet as CSV from Excel or Google Sheets first, then open that file here.
Is my data uploaded?
No. The file is read and shown entirely in your browser, and nothing is sent or stored.
Is CSV Viewer free?
Yes. CSV Viewer is free: no sign-up, no paid plan, no trial and no limit on how often you use it. It runs in your browser, and ToolzAura is paid for by ads, so every tool stays free.
Are my files uploaded?
No. This tool runs in your browser, so your input stays on your device.