JSON Formatter, Validator and JSON to CSV Converter

Paste JSON to format, validate or minify it, convert an array of objects into CSV for a spreadsheet, or turn a CSV export into JSON for an API. Errors name the line and column so you can fix them quickly.

How to use it

  1. Choose a mode: Format, Minify, Validate, JSON to CSV or CSV to JSON.
  2. Paste your data or load the sample.
  3. Press Run, then copy or download the output.

Example

The sample JSON is an array of three customers, one with a nested address. Converting to CSV flattens the nested field into a column named address.city.

Benefits

  • Nested objects are flattened into dotted column names so spreadsheets can open them.
  • CSV parsing handles quoted fields, embedded commas and line breaks.
  • Nothing is sent to a server, which matters for customer or financial data.

Limitations

  • CSV has no types, so numbers and booleans are only converted if you turn on type detection.
  • Very large files (tens of megabytes) may be slow because everything runs in the browser tab.

Frequently asked questions

Why does JSON to CSV show arrays as text?

Arrays inside a cell are written as JSON text so no data is lost. Flatten them in your source if you need one value per column.

Which delimiters are supported?

Comma, semicolon, tab and pipe. Auto-detect looks at the first line.

Does validation accept comments or trailing commas?

No. It follows the strict JSON standard, the same rules JSON.parse uses.

Related tools