JSON ↔ CSV Converter

1. 1Paste a JSON array of objects into the input panel, or press Sample. For CSV input, set Direction to CSV → JSON.
2. 2Choose the delimiter and the other options. The result updates as you go, and Swap sends it back the other way.
3. 3Press Copy to copy the result, or Download to save a .csv file that Excel opens with the text intact.

Direction

JSON → CSV (default) or CSV → JSON. Swap moves the result into the input and reverses the direction.

Delimiter

Comma (default), semicolon, tab, or pipe. When reading CSV, Auto-detect picks the delimiter from the first lines, or you can choose one yourself.

Nested objects

Dot paths (default) spreads a nested object over columns such as a.b. JSON string keeps the whole object in one cell. Arrays are always written as a JSON string.

Line break

CRLF (default, as in RFC 4180) or LF for the rows of the CSV.

UTF-8 BOM in the downloaded file

On by default. Adds the three bytes EF BB BF to the start of the downloaded .csv file so that Excel reads it as UTF-8. The output panel and Copy never include the BOM.

First row is a header

On by default when reading CSV. The first row becomes the keys of each object. When off, every row becomes an array.

Detect numbers

Off by default when reading CSV, so every value is a string. When on, values written like a JSON number become numbers, exactly as written. Values such as 007 stay strings.

• JSON to CSV (defaults: comma, CRLF)

  Only values that contain a comma, a double quote, or a line break are quoted. A double quote inside a value is written twice.

  Input

  [{"id":1,"name":"Kim, Jr."},{"id":2,"name":"이\"민\""}]

  Output

  id,name
  1,"Kim, Jr."
  2,"이""민"""

• Nested objects and missing keys

  A nested object becomes a dot path. A key that first appears in a later object is added on the right.

  Input

  [{"a":{"b":1}},{"c":2}]

  Output

  a.b,c
  1,
  ,2

• CSV to JSON (Detect numbers off)

  Every value stays a string, so the leading zeros of 007 are kept.

  Input

  id,zip
  1,007

  Output

  [
    {
      "id": "1",
      "zip": "007"
    }
  ]

• JSON that is not a table

  Input

  "text"

  Output

  This JSON cannot become a CSV table

Examples use the reference cases this tool is tested against.

• JSON Formatter & ValidatorBeautify, minify, and validate JSON with exact error positionsUse it
• JSON ↔ YAML ConverterConvert JSON to YAML and YAML to JSONUse it
• Character & Byte CounterCount characters and bytes in UTF-8, EUC-KR, and Shift_JISUse it