JSON to CSV

How JSON maps to CSV

CSV is a flat, rectangular format: one row per record, one column per field. JSON is a tree. The conversion therefore needs an array of records to act as the rows, and a strategy for anything nested.

Jsonviewpro finds the row array automatically — a top-level array, or a common wrapper property such as data, results, items or records. If the document is a single object it becomes a single row.

How to convert JSON to CSV

• Paste or upload your JSON.
• Check the detected source — Jsonviewpro shows which array it is using for rows.
• Choose whether to flatten nested objects, whether to include a header row, and which delimiter to use.
• Review the preview, then Copy CSV or Download CSV.

Flattening nested objects

With flattening on, {"user": {"name": "John"}} becomes a column named user.name. Arrays of primitives are joined with a semicolon; arrays of objects expand to indexed columns such as items[0].sku.

With flattening off, nested values are written as JSON text inside the cell. That keeps the column count small and is the better choice when you plan to parse the cell again later.

Delimiters, quoting and Excel

Fields containing the delimiter, a double quote or a line break are quoted, and inner quotes are doubled, per RFC 4180. If your locale uses the comma as a decimal separator, choose semicolon as the delimiter — that is what Excel expects in those locales.

Handling irregular records

Records do not have to share the same shape. Jsonviewpro collects the union of every field it sees, in first-appearance order, and leaves cells empty where a record has no value. If your data is irregular in ways you did not expect, the JSON Analyzer will tell you which fields are missing and where types disagree.