Check JSON Shape before Converting to CSV
Understand why flat object arrays become tables while nested values need review.
Reviewed 2026-09-14 · ToolMarket
A table-friendly JSON shape
An array such as [{"name":"A","age":20},{"name":"B","age":21}] maps cleanly to CSV columns and rows. Expected output has name,age headers and two data rows: A,20 and B,21. Use JSON Formatter to catch syntax errors first.
Nested objects and arrays do not automatically expand into meaningful columns. Inspect how they appear in the result.
Validate the export
Compare the output column names and row count with the original. Keys found only in some objects may create blank cells.
When opening the CSV in a spreadsheet, check text encoding and identifiers with leading zeros.