What it does
Paste delimited data to see it as a readable table. The delimiter is auto-detected from the first line, or you can force comma, semicolon, tab or pipe. Quoted fields with embedded delimiters, quotes and line breaks are handled per RFC 4180.
How to use
- Select a column header to sort by it; select again to reverse the order. Sorting is natural, so numbers inside text sort correctly.
- Type in the filter box to show only rows that contain the text, in any column.
- Rows with fewer fields than the widest row are padded with empty values, so ragged data still displays.
Example
Paste name,role,years followed by a row such as "Linus, Torvalds",Engineer,30. The comma inside the quotes stays in the name field, and the status line reports the row and column counts and the delimiter it chose. Pasting a,b,c over rows of different lengths pads the short rows, and a row with an extra value gets a column named "Column 4" so nothing is dropped.
Limits
- Display is capped at 2,000 rows at a time. The status line says when more rows match; the filter and the sort still work on every row, so narrow the filter to see the rest.
- Auto-detect looks only at the first line, so if that line holds no delimiter, pick one from the menu.
- Every value is treated as text. Dates and numbers are not converted, and spreadsheet formulas are not calculated.
- A quoted field that is never closed is reported as an error instead of guessing where it ends.
- Column headers can be sorted from the keyboard: focus one and press Enter or Space.
This tool only displays data. To turn CSV into JSON objects, or JSON back into CSV, use the JSON ⇄ CSV Converter. To order a plain list of lines or remove duplicates, use Sort & Deduplicate Lines, and to see what changed between two exports, the Text Diff Checker.
Examples
- A comma inside a quoted value. For the text
name,role,years, then"Linus, Torvalds",Engineer,30, then two more rows, the viewer reports “3 row(s), 3 column(s) using "," as delimiter”. The quoted name stays in one cell. The last row has only two values, so its third cell is empty. - Semicolons. The text
name;city;scorewith three rows is detected automatically: “3 row(s), 3 column(s) using ";" as delimiter”. Many spreadsheet programs in countries that write decimals with a comma export CSV with semicolons.
Choose the delimiter yourself if the guess is wrong, switch “First row is header” off for data without column names, click a column heading to sort by it and type in the filter box to keep only matching rows.
Frequently asked questions
Can I convert CSV to JSON?
Yes. Use the JSON CSV Converter.
How do I load my data?
Paste the CSV text into the input box. The table is built as you type, and clicking a column heading sorts by that column, a second click reverses the order.
Is my data uploaded?
No. The file never leaves your device.
Privacy
This tool runs entirely in your browser. What you enter is processed on your device and is not sent to a server.