How to use CSV Viewer
- Paste CSV or TSV, or choose a CSV, TSV or XLSX file. For a workbook, choose the worksheet by name or number.
- Check the delimiter, header setting and any parsing warnings before relying on the columns.
- Use Find rows containing for a text search. Open the additional options for column-specific conditions, sorting, hidden columns and preview pages.
- Review matching-row counts and download the filtered CSV if needed. It contains every matching row and all columns, including columns hidden in the preview, with the chosen formula-prefix policy.
Example: CSV Viewer
Open a small CSV that holds a quoted comma and a quoted line break.
Options
- CSV or TSV text
- Paste the rows to inspect, or leave this empty and choose a file. Values are shown exactly as they appear in the text.
- Worksheet name or number
- Choose the worksheet used for table inspection. An empty choice uses the first visible sheet; otherwise enter its name or 1-based position.
- The first row holds the column names
- For table inspection, enable this when the first record names the columns. Without headings, refer to columns by their 1-based positions.
- Find rows containing
- Case-insensitive. Filtering changes which rows are shown, not the values themselves.
- Column to search
- Used when the search is limited to one column. Enter the column name exactly as it appears in the header.
- How to find rows
- Match text uses the search box above. The conditions option reads the condition lines below instead.
- Conditions, one per line
- Write a column, a test and usually a value, such as: status equals open. Text tests ignore letter case. Quote a column name that holds a space: "First name" starts with A. The tests are contains, does not contain, equals, does not equal, starts with, ends with, is empty, is not empty, is greater than, is at least, is less than and is at most.
- Sort by column
- Leave empty to keep the file order. Enter the column name exactly as it appears in the header.
- Sort keys, one per line
- One column name per line, in order, with an optional asc or desc after it. These keys replace the single Sort by column when they are set, and the Sort values as choice above applies to every key.
- Sort values as
- Text is the default because it keeps an identifier such as 0012 in place. Either way the cell text is left exactly as it was.
Supported inputs and limits
- Chosen CSV/TSV/XLSX input replaces pasted text; up to 20 MiB, 100,000 rows, 500 columns and 2,000,000 cells.
- Preview pages hold at most 250 rows.
- Header filters, condition controls and sort keys change the view, never source cell text.
- Hidden columns remain in the CSV download, which includes every matching row.
- Resize controls affect presentation only.
More details
Formula protection prefixes risky exported strings.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Sorting never rewrites your values
A sorted view is a new order for the rows on screen, not an edit to the text you opened. That matters for an identifier column, where 0012 is a label rather than the number twelve. The row number follows each row back to its original position in the file.
What the warnings mean
Short rows, long rows and repeated header names produce a warning rather than a silent guess. Reading those notes first stops a column count from looking right when the file is not rectangular.
Questions about CSV Viewer
Why does my ID column show 0012 instead of 12?
Every cell is kept as text, so a leading zero is never coerced into a number. A sort may compare a value, but the displayed text does not change.
Why do some rows show empty cells?
Those rows hold fewer values than the header, so the missing cells are padded and a warning reports the count.
My file is refused as not UTF-8. What do I do?
Re-export it as UTF-8. In Excel, choose CSV UTF-8 rather than the older CSV option.
Does hiding a column remove it from the file?
No. Hidden columns are omitted only from the preview. The download contains every column and every matching row, with the selected formula protection.