Data conversion workflow
Convert nested JSON to a useful CSV table
Nested objects and arrays need explicit flattening rules before they can fit into rows and columns.
Map structure before exporting
Review the root array and nested paths instead of accepting an unreadable automatic table.
Choose the record array
Confirm which array represents the output rows.
Inspect nested keys
Review generated column paths and object values.
Choose a flattening approach
Keep nested JSON strings or flatten selected paths.
Export and verify
Open the CSV preview and check representative rows.
How nested data becomes columns
CSV is flat, so nested JSON must be flattened into columns. The converter builds column names from the path, for example user.name becomes the column "user.name".
Arrays of objects become repeated rows with shared parent values, which is the standard shape for spreadsheet imports.
- Objects are flattened with dot-joined paths
- Arrays of objects expand into one row per item
- Scalar values repeat on each expanded row
- Empty and missing fields become empty cells
Common conversion problems
- Different records contain different keys
- Nested arrays do not map cleanly to one cell
- Large numeric identifiers can be changed by spreadsheets
- Newlines and commas need correct CSV quoting
Produce safer CSV
- Preserve identifiers as text when needed
- Use UTF-8 output
- Verify quoted cells
- Document the flattening convention
Frequently asked questions
What does a nested object look like after conversion?
The key user.name is created as a column, so nested fields become readable spreadsheet headers.
How are arrays of objects converted?
Each object in the array becomes its own row, and values from the parent object repeat on every row.
Can I control the column order?
Yes. The converter keeps the order in which keys first appear and lets you reorder or rename columns before download.
Is my JSON uploaded during conversion?
No. Conversion runs locally in your browser.
Convert API data locally
The converter can process JSON in the browser, reducing the need to upload internal API responses.
Open JSON to CSV