CSVCSV Dock

CSV guide

How to Convert Nested JSON to CSV

CSV is a flat table, while JSON can contain objects and arrays at any depth. A useful conversion therefore needs an explicit record array and a policy for nested values.

Convert nested JSON

Try this guide’s example here

Step by step

  1. Identify the array that represents rows, such as results.items.
  2. Enter that dot-separated array path in the converter.
  3. Enable dot-notation flattening for nested objects such as customer.name.
  4. Keep nested arrays as JSON when preserving structure matters, then review the generated columns.

Check the result

  • Compare the number of exported rows with the length of the selected JSON array.
  • Check records where optional nested properties are missing; their cells should be empty without shifting adjacent values.
  • Reparse one preserved object or array cell as JSON to confirm that quoting and escaping survived the CSV export.

Common pitfalls

  • Flattening can create many sparse columns when object shapes vary widely.
  • Joining array values is lossy when items contain commas or nested objects.
  • An empty array contains no column evidence, so it produces an empty table.

Try the example on this page

Choose Try sample to load this guide’s synthetic data. Adjust the settings, inspect the result and export it here. You can also choose your own file for local processing.

CSV export options
Drop a file, paste data, load a CORS-enabled URL, or try the sample.
Rows0
Columns0
EncodingAuto
DelimiterAuto
Issue groups0

Open a data file to start

The parser runs off the main thread. Once loaded, you can search, sort, validate, repair and export without an account.

Original samples: nested-records.json

Check expected outcomes and file checksums

Privacy boundary

Files selected in the workbench are processed locally. A public URL is requested directly by the browser and must permit cross-origin access. No server proxy is used by the MVP.