How to View and Sort CSV Data Online
Paste your CSV text
Open a CSV or TSV file in any text editor or spreadsheet export, copy the raw rows, and paste them into the input box. The first row is treated as the column headers and every following non-empty line becomes a data row.
Click Visualize CSV
The tool reads the first line to detect whether your data is separated by commas, semicolons, or tabs, then renders an HTML table. A summary line reports the row count, column count, and which delimiter was detected so you can confirm it parsed correctly.
Click a header to sort
Click any column heading to sort the rows by that column. Columns where every value reads as a number sort numerically; otherwise rows sort alphabetically. Click the same header again to flip between ascending and descending, shown by the ^ and v markers. Use Clear to empty the input and table.
What the Parser Detects and Handles
The visualizer parses pasted text entirely in your browser. The table below describes how it handles common CSV traits so you know what to expect before you paste a file.
| Trait | How the tool handles it |
|---|---|
| Delimiter | Auto-detected from the first line. Tabs and semicolons are recognized alongside commas, and the most frequent separator wins. |
| Header row | The first non-empty line becomes the clickable column headers used for sorting. |
| Quoted values | Double quotes toggle quoting, so a delimiter inside quoted text is kept as part of the cell rather than splitting it. |
| Blank lines | Empty or whitespace-only lines are skipped instead of producing empty rows. |
| Whitespace | Each cell value is trimmed, so leading and trailing spaces around values are removed. |
| Number sorting | If both values in a comparison read as numbers, the column sorts numerically; mixed or text values sort alphabetically. |
When This Tool Is the Right Fit
Quick inspection
Use it to glance at an exported CSV, count rows and columns, and confirm the delimiter before importing the file somewhere else.
Sorting on the fly
Reach for it when you want to reorder rows by a column to spot the largest values or group similar text without opening a spreadsheet app.
Mixed separators
Helpful when you are unsure whether a file uses commas, semicolons, or tabs, since the detected delimiter is reported back to you.
Not for editing
This is a read-only viewer. If you need to edit cells, add formulas, build charts, or save changes, use a full spreadsheet application instead.
Common Problems and Fixes
The table splits into the wrong columns
The delimiter is detected only from the first line. If your header row uses a different separator than the data, or contains stray commas, the count can be off. Check the detected delimiter in the summary and adjust the first line so it matches the rest of the file.
Nothing happens when I click Visualize
The tool ignores empty input. Make sure you pasted at least one line of text into the box, then click Visualize CSV again.
A column will not sort as numbers
Numeric sorting only applies when both compared values parse as numbers. Values with currency symbols, thousands separators, or stray text fall back to alphabetical sorting. Remove non-numeric characters from those values if you need a numeric order.
Some rows are missing
Blank lines are skipped on purpose. If a real row vanished, it was likely treated as empty after trimming, or it lost its delimiter. Confirm the row contains the separator and is not just whitespace, then paste again.