About the CSV Viewer
A CSV file is just text, which is hard to read when there are many columns. This viewer shows it as a table you can work with. Open a file or paste text, and the separator is detected for you. Click a column title to sort, type in the search box to filter rows, and choose one column to search. Large files are shown 50 rows at a time so the page stays fast. A statistics panel tells you, for any column, how many cells are filled or empty, how many different values there are and, for numbers, the smallest, largest, average and total. The file is read in your browser, so private data is never uploaded.
Updated October 2026
How to use the CSV Viewer
- 1Open a CSV or TSV file, or choose Paste text instead.
- 2Check the row and column count above the table.
- 3Click a column title to sort ascending, again for descending, and a third time to clear.
- 4Type in the search box to filter the rows, and pick the column to search in.
- 5Choose a column in the statistics panel to see details.
Getting to know your data
Start with the statistics for each column. A column with many empty cells may need cleaning, one with only a few different values is probably a category, and a column of numbers with a surprising largest value can reveal a typing error. Sorting a column from smallest to largest is a quick way to find outliers and mistakes at the top and bottom.
The search box filters the rows as you type, so you can check a single customer, product or date in a long file without a spreadsheet. Choose a single column to avoid matches in other columns.
Common problems
- Everything in one column: the file uses a separator that was not detected; try a different export setting.
- Dates look odd: the viewer shows the text as it is in the file.
- Numbers with commas: write them in quotes or use a different separator.
- A file that starts with a title line: delete that line first.
- Merged cells and formulas do not exist in CSV; only values are kept.
Related tools
Combine several files with Merge CSV Files, divide a big one with the CSV Splitter, and switch separators with the CSV Delimiter Changer. Turn the table into JSON with the CSV to JSON Converter or save it as a spreadsheet with CSV to Excel.
Features
- Separator detected automatically
- Sort by any column, numbers or text
- Search all columns or one
- Paging for large files
- Column statistics: filled, empty, distinct, min, max, average, sum
- Handles quoted fields and line breaks
- Private, nothing is uploaded
Frequently asked questions
What kinds of files can I open?
CSV, TSV and plain text files with data separated by commas, semicolons, tabs or pipes. The first row is shown as the column titles.
Is it safe for private data?
Yes. The file is read in your browser and never sent to a server.
How does sorting decide between numbers and text?
If the first values in a column are all numbers, it sorts as numbers (so 9 comes before 10). Otherwise it sorts as text, with numbers inside text compared in natural order.
Why do I see strange characters?
The file may use a different text encoding than UTF-8. Save it as UTF-8 from the program that made it, or convert the encoding first.
Can I edit the data?
This viewer is read-only. To change data, open the file in a spreadsheet, or use the column tools of this site.
How big a file can it open?
A few hundred thousand rows work well. Very large files may be slow because they are held in memory.
Why are some columns empty?
Some rows have fewer cells than the header, or the file has extra separators. The viewer shows what it finds and leaves the rest blank.