Developer Tools
CSV to JSON & JSON to CSV Converter
Convert CSV to JSON, or JSON back to CSV. Paste data or open a .csv, .tsv or .json file, preview the result and copy or download it — your data never leaves your browser.
Runs in your browser
Features
What you get
Both directions
CSV → JSON and JSON → CSV in one place. Each side keeps its own input when you switch, and opening a .json or .csv file switches automatically.
Standards-compliant CSV parsing
Quoted commas, escaped quotes, multi-line cells, BOMs and CRLF or LF line endings are handled — never a naive split on commas.
Any delimiter
Auto-detects comma, tab, semicolon and pipe when reading, and writes any of the four.
Nothing silently lost
Duplicate headers are renamed, ragged rows are reported, missing JSON keys become empty cells, and very large numbers that browsers can't store exactly are flagged.
Nested JSON, flattened
address.city-style columns for nested objects; arrays as JSON text or one column per item (tags.0, tags.1).
Spreadsheet-friendly output
Optional UTF-8 BOM for Excel, CRLF or LF line endings, and a warning — plus an opt-in apostrophe prefix — for values a spreadsheet could run as formulas.
How to use
How to use the CSV to JSON & JSON to CSV Converter
CSV is parsed with Papa Parse, a widely used parser that follows RFC 4180: quoted fields can contain commas, line breaks and doubled quotes (""). Duplicate headers are renamed name, name_2, name_3 and blank headers become column_N; rows with too few or too many cells are listed. For JSON to CSV, the columns are every key found across all records in first-seen order; nested objects become dot-path columns such as address.city, arrays are written as JSON text or one column per item, and fields containing the delimiter, quotes or line breaks are quoted and escaped.
- 01
Choose a direction
Pick CSV → JSON or JSON → CSV, then paste your data or open a file.
- 02
Check the options
Confirm the delimiter, header row and how nested data should be written. Review any notes about rows or values.
- 03
Copy or download
Check the preview table, then copy the result or download a .json, .csv or .tsv file.
Examples
Worked examples
CSV headers become keys
name,city / Amit,Mumbai becomes [{"name": "Amit", "city": "Mumbai"}]. "Loves chai, hates meetings" in quotes stays one value.
Nested JSON to columns
{"id": 1, "address": {"city": "Pune", "pin": "411001"}} becomes the columns id, address.city, address.pin.
European CSV
name;price / Café;3,50 is detected as semicolon-separated, and 3,50 is kept exactly as written.
Technical specifications
- CSV parser
- Papa Parse 5 (RFC 4180)
- Delimiters
- Comma, tab, semicolon, pipe (auto-detect when reading); custom when reading
- JSON input shapes
- Array of objects, single object, array of arrays, array of values, or a records array under a top-level key
- Nested JSON
- Dot-path columns; arrays as JSON text or indexed columns
- Duplicate headers
- name, name_2, name_3 …; blank → column_N
- CSV output
- RFC 4180 quoting, CRLF or LF, optional UTF-8 BOM
- Input formats
- .csv, .tsv, .txt, .json
- Max file size
- 20 MB (inputs over 1 MB convert on demand)
- Processing
- In your browser
Privacy
CSV and JSON files are read and converted in your browser. Your data is never uploaded or stored, and nothing you paste is sent to analytics.
Read the full privacy policy.
FAQ
CSV to JSON & JSON to CSV Converter questions
CSV (comma-separated values) stores a table as plain text, one row per line. JSON stores structured data that apps and APIs read directly. ZSpace Tools' CSV to JSON & JSON to CSV Converter turns each CSV row into a JSON object keyed by the header row, and turns a JSON array of objects into a CSV table with one column per key — reporting anything that doesn't fit instead of dropping it.
CSV is parsed with Papa Parse, a widely used parser that follows RFC 4180: quoted fields can contain commas, line breaks and doubled quotes (""). Duplicate headers are renamed name, name_2, name_3 and blank headers become column_N; rows with too few or too many cells are listed. For JSON to CSV, the columns are every key found across all records in first-seen order; nested objects become dot-path columns such as address.city, arrays are written as JSON text or one column per item, and fields containing the delimiter, quotes or line breaks are quoted and escaped.
Choose CSV → JSON, paste the data or open the .csv file, confirm the delimiter and whether the first row holds headers, then copy the JSON or download it as a .json file.
Choose JSON → CSV and paste or open your JSON. An array of objects becomes one row per object, with a column for every key. Pick the delimiter, then copy the CSV or download a .csv file.
With flattening on, a nested object such as address: { city } becomes an address.city column. Arrays are written as JSON text in one cell by default, or as one column per item (tags.0, tags.1) if you choose. Nothing is dropped.
Duplicates are renamed in order — name, name_2, name_3 — and blank headers become column_1, column_2 and so on. Every rename is listed so you can check it.
The converter lists every affected row. Missing cells are filled as empty, and extra cells are kept under generated column names so no data is lost.
Spreadsheet apps may treat a cell starting with =, +, -, @ or a tab as a formula. Your data isn't changed unless you turn on “Spreadsheet-safe export”, which prefixes those values with an apostrophe so they open as text.
Turn on “UTF-8 BOM for Excel”. Excel uses the BOM to recognise UTF-8; without it, some versions show characters such as é or ₹ incorrectly.
No. Parsing and conversion happen entirely in your browser.
Related tools
JSON Formatter & Validator
Beautify, minify and validate JSON, with exact line and column for every error.
Text Diff Checker
Compare two texts and see added, removed and changed lines, words or characters — side by side or unified.
PDF to Excel Converter
Pull tables out of PDFs into Excel (XLSX) or CSV — numbers stay numbers, IDs stay exact.