Skip to main content
Tools

CSV Viewer

View CSV and TSV files as a sortable, filterable table, with delimiter and Big5 detection. Files never leave your device.

0 characters · 1 line

Drop files here, or

.csv, .tsv, .txt

Files are never uploaded.

How to use

  1. Drop a CSV or TSV file on the file area or paste the content, or click “Example” to try it.
  2. The delimiter is detected automatically and the first row is used as column names; you can change both above.
  3. Click a column name to sort, click again to reverse, and a third time to clear sorting.
  4. Type in “Filter” to show only rows that contain the text, optionally within one column.

FAQ

Is my file uploaded?

No. The file is read and shown in your browser only and is never sent to a server, so it is safe for reports that contain personal data.

Why does the text look garbled?

“File encoding” is automatic by default: valid UTF-8 files are read as UTF-8 and anything else as Big5, the Traditional Chinese encoding common in older Excel exports and Taiwanese open data. If the text still looks wrong, pick an encoding by hand; the one actually used is shown below the options.

Why are only the first 1,000 rows shown?

Drawing tens of thousands of rows at once slows the browser down. Sorting and filtering still apply to all rows, so you can reach any row that way, and the row count covers the whole file.

How does sorting work?

When both values in a column are numbers, they are compared numerically (thousands separators such as 1,234 are fine). Text is sorted by the rules of the page language, with natural number order, so “item 2” comes before “item 10”. Empty cells always go last.

Which delimiters are supported? Can fields contain commas or line breaks?

Commas, semicolons, tabs and pipes (|) are detected automatically. Following RFC 4180, fields wrapped in double quotes may contain the delimiter, line breaks and doubled quotes (""). An unclosed quote is reported with its position.

Keyboard shortcuts

/
Search tools (on a tool page, goes to the homepage search)
?
Show this help
Esc
Close a dialog
Ctrl / ⌘Enter
Run the tool's main action (where supported)

While you type in a text field, / and ? are typed as usual.