📊
CSV Viewer
Sortable, searchable table · CSV → JSON · JSON → CSV · open and download files
Ctrl+Enter = run
CSV to JSON
Free online CSV to JSON converter. Paste or open a CSV file and get a JSON array of objects, with numbers and true/false turned into real JSON values (leading-zero values like zip codes stay text). Also converts JSON to CSV and shows CSV as a sortable table. Fully client-side.
Free
No login
100% browser-based
Your input never leaves your device
What is a CSV to JSON?
CSV (Comma-Separated Values) is the lowest-common-denominator format for tabular data — every spreadsheet, database, and data tool can export and import CSV. But raw CSV text is unreadable when columns misalign, values contain commas, or there are hundreds of columns.
This tool parses CSV and renders it as a formatted HTML table, handling quoted fields, embedded commas, and newlines inside values correctly. Supports comma, semicolon, and tab delimiters. No file is uploaded — everything is processed in your browser.
What delimiters does this CSV viewer support?
This tool supports comma (,), semicolon (;), tab (\t), and pipe (|) delimiters. It also has an auto-detect mode that tries to identify the delimiter from your data. European Excel exports often use semicolons; TSV files from spreadsheets use tabs.
How large a CSV file can I paste?
This tool handles CSV files up to a few thousand rows without performance issues. For very large files, the table shows the first 1,000 rows for speed, but filtering, sorting, downloads and the JSON conversion include every row. All processing happens in your browser.
Can I sort the CSV table?
Yes — click any column header to sort by that column. Click again to reverse the sort. Sorting is alphabetical for text columns and numeric for number columns (auto-detected). The sort only affects the display, not the original data — but Download saves the rows in the order you see them.
What is the difference between CSV and TSV?
CSV (Comma-Separated Values) uses commas as delimiters. TSV (Tab-Separated Values) uses tab characters. TSV is often preferred when values themselves contain commas (like addresses or sentences) because tabs rarely appear in data. Both are plain text and can be opened in Excel, Google Sheets, or any spreadsheet app.
Why does my CSV look wrong when opened in Excel?
Three common causes: 1) Excel uses the system locale's list separator (semicolons in many European countries) — change to comma in Excel's import wizard. 2) Excel may show accented letters and symbols as garbled text in a UTF-8 file without a byte order mark (BOM). CSV downloads from this tool include the BOM, so Excel reads them correctly. 3) Date fields auto-format differently based on locale. Use Data → Text to Columns in Excel for reliable CSV import.
How do I handle commas inside CSV values?
Wrap the value in double quotes: John,"Smith, Jr.",New York. If the value contains double quotes, escape them by doubling: "He said ""hello""". This is defined in RFC 4180. Most CSV parsers handle this correctly. Always quote fields that may contain commas, newlines, or double quotes.
Can I open a CSV file instead of pasting it?
Yes. Drop a .csv, .tsv or .txt file on the input box, or use Open file. Files up to 50 MB are read in your browser and never uploaded. Very large files (tens of MB) can make the page slow, so for big datasets a desktop tool like LibreOffice Calc, csvkit or Miller (mlr) may suit you better.