CSV Viewer and Analyser

The CSV viewer opens a comma-, semicolon- or tab-separated file as a table you can sort and filter, and describes every column at a glance: what kind of data it holds, how many cells are blank, how many distinct values there are, and for numbers the minimum, maximum, mean, median and total. It is for the moment you receive an export — a bank statement, a sales report, a database dump — and want to understand it before opening a spreadsheet, or when the file is too big for one to open comfortably.

1. Press “Open a file” and choose a .csv or .tsv file, drag one onto the box, or paste CSV text. “Try an example” loads a small order list.
2. Check the column cards: the type, the blanks and the range tell you quickly whether the data is what you expected.
3. Click a column heading to sort by it; click again to reverse, and a third time to go back to the file’s order.
4. Type in “Filter rows” to show only rows containing every word you type, in any column.
5. Copy the rows you are looking at — filtered and sorted — as CSV.

• Files up to 50 MB can be opened. A file with hundreds of thousands of rows takes a few seconds to read on a phone; the table shows 100 rows at a time.
• Types are detected strictly. A column is a number only if every filled cell is one; 1,234.5 and Indian grouping such as 1,23,456 count, but ₹500 or 12% make the column text, so a stray symbol never turns into a wrong total.
• Dates are recognised in the ISO form 2026-09-24 (with or without a time). Other formats, such as 24/09/2026, are treated as text, because 03/04 means different days in different countries.
• Rows with more or fewer cells than the header are padded with empty cells, and the tool says how many there were.
• The first sheet of an Excel file is not read directly; save it as CSV first.
• The file is read and analysed in your browser, in a background worker on your device. It is never uploaded, which makes the viewer safe for statements, payroll exports and customer lists. Closing or reloading the page discards it.

At least one cell is not a plain number — it has a currency sign, a percent sign, a unit, or text such as “N/A”. Sort the column to find it; it will be at one end.

It looks at the first rows and picks the character — comma, semicolon, tab or pipe — that splits them consistently, respecting quoted values. The one it chose is shown above the column cards.

No. Blank cells are counted separately and left out of the minimum, maximum, mean, median and total.

Not here — it is a viewer. To change the shape of the data, the JSON and CSV converter turns it into JSON you can work with.