CSV / TSV Viewer + Converter

Paste a CSV or TSV; we **auto-detect the delimiter** and parse it per RFC 4180 (quotes, `""` escapes, newlines inside fields). Tabular preview, per-column stats (unique / empty / numeric), one-click export to JSON / TSV / Markdown / CSV.

First row is the header

Delimiter→ ,

Open file

Source

4 rows · 4 cols

name 4u · 0∅	age 4u · 1∅	city 4u · 0∅	active 2u · 0∅
Alice	30	Taipei	true
Bob	25	Taichung, City	false
Charlie		Tainan	true
Diana	40	Kaohsiung	true

[
  {
    "name": "Alice",
    "age": "30",
    "city": "Taipei",
    "active": "true"
  },
  {
    "name": "Bob",
    "age": "25",
    "city": "Taichung, City",
    "active": "false"
  },
  {
    "name": "Charlie",
    "age": "",
    "city": "Tainan",
    "active": "true"
  },
  {
    "name": "Diana",
    "age": "40",
    "city": "Kaohsiung",
    "active": "true"
  }
]

›How to use

Paste CSV or click Open file to load .csv / .tsv. The delimiter is auto-detected (, ; Tab |) — override if needed.
First row is header is on by default; uncheck if your file has no header → we synthesise col1, col2…
Live tabular preview below (200-row cap for speed; export still contains everything). Each header shows unique count, empty count, and a numeric-column flag (#).
Output tabs at the bottom: JSON (array of objects), TSV (paste into Google Sheets), Markdown (GFM table), Normalised CSV (canonical quoting).

Tips

Full RFC 4180 — quoted fields with commas / newlines inside, "" for an escaped double quote. Even weird Excel CSVs parse fine.
European Excel CSV uses ; (German / French / CEE). Auto-detect handles it.
TSV → Google Sheets: switch output to TSV, Cmd-C, then Cmd-V into any cell — auto-splits into columns.
Numeric-column flag (#) only fires when 80%+ of cells are valid numbers — handy schema sniff.

💡 200-row preview cap keeps rendering snappy; the export still contains the full dataset. Files never leave your browser.

CSV / TSV Viewer + Converter

Related tools