JSON / CSV Converter & Formatter
Beautify, minify and validate JSON text; convert between JSON and CSV for tabular data.
How to use
- Paste JSON or CSV text into the box.
- Pick the action: Format, Minify, Validate, JSON → CSV or CSV → JSON.
- 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:
| a | b.c |
|---|---|
| 1 | x;y |
| 2 | z |
The Turkish edition of Excel expects a semicolon delimiter, so choose it if you will import into Excel.
The most common JSON errors
| Error | Wrong | Right |
|---|---|---|
| Unquoted key | {a: 1} | {"a": 1} |
| Single quotes | {'a': 1} | {"a": 1} |
| Trailing comma | [1, 2, ] | [1, 2] |
| Comment line | // note | JSON 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
© ZDK Mühendislik — the software of this tool may not be copied or reused on other sites without permission.