« Tools

JSON / CSV Converter & Formatter

Beautify, minify and validate JSON text; convert between JSON and CSV for tabular data.

Calculations run in your browser; the data you enter is never sent to any server.

How to use

  1. Paste JSON or CSV text into the box.
  2. Pick the action: Format, Minify, Validate, JSON → CSV or CSV → JSON.
  3. Copy the result or save it as a file.

Method and assumptions

  • JSON → CSV: an array of objects becomes rows; nested objects are flattened into "parent.child" columns and array fields are written as JSON text. Choose the semicolon for Excel in Turkish regional settings.
  • CSV → JSON: the first row is the header; quoted delimiters and doubled quotes ("") are handled; the delimiter can be auto-detected.
  • Your data never leaves the browser.

Example: JSON to CSV

Input: [{"a":1,"b":{"c":"x;y"}},{"a":2,"b":{"c":"z"}}]. The nested object is flattened into a “b.c” column; a value containing the delimiter is quoted. Output with a semicolon delimiter:

ab.c
1x;y
2z

The Turkish edition of Excel expects a semicolon delimiter, so choose it if you will import into Excel.

The most common JSON errors

ErrorWrongRight
Unquoted key{a: 1}{"a": 1}
Single quotes{'a': 1}{"a": 1}
Trailing comma[1, 2, ][1, 2]
Comment line// noteJSON has no comments

The tool shows the error and its approximate position; fix it and try again.

Common mistakes

  • Expecting arrays to become columns: array fields are written as JSON text in CSV.
  • Seeing broken Turkish characters: instead of opening directly in Excel, import with “Data → From Text/CSV” as UTF-8.
  • Giving CSV without a header: in CSV → JSON the first row is taken as the header.

Frequently asked questions

How do I find a JSON error?

"Validate" shows the browser's error message; it is usually a missing quote, comma or bracket.

Turkish characters break in Excel.

"Save" writes the file with a UTF-8 BOM so Excel opens Turkish characters correctly.

How does nested JSON become CSV?

Nested fields are flattened into dot-joined columns such as "address.city".

More tools