Skip to content
zspace tools

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.

  1. 01

    Choose a direction

    Pick CSV → JSON or JSON → CSV, then paste your data or open a file.

  2. 02

    Check the options

    Confirm the delimiter, header row and how nested data should be written. Review any notes about rows or values.

  3. 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.