JSON to CSV

Processed locally

app.csv.view

You can also load data via #data={"name":"Ada"} or #url=... It is cleared from the address bar after it is read.

Flatten an array of objects into table text (CSV), or convert a table back to JSON. A middle step before pasting an API list into Excel, or for turning an ops spreadsheet into test data. Column names usually come from object keys.

Array → table

Keys on the same object level become headers. Best for “user list” / “order list” shapes where each row is one record.

After conversion you can copy or download export.csv。

Nesting needs flattening

Deep objects are usually flattened into columns like user.name , or only one level is kept. If the structure is too deep, extract the list with JSONPath first.

For objects with inconsistent fields, headers try to union every key that appeared.

Local conversion

Table contents are not uploaded. Exports that contain business data can stay on this device.

For a formatted workbook, use the Excel page to generate xlsx.

Example

JSON array

[
  { "id": 1, "name": "Ada" },
  { "id": 2, "name": "Bob" }
]

CSV

id,name
1,Ada
2,Bob

Can a non-array convert?

A single object can be treated as one row. For deep nesting, extract a list with JSONPath first.

How is this different from the Excel page?

CSV is plain text; Excel is better for generating or reading .xlsx directly.

How are commas and newlines handled?

Commas and quotes inside field values are escaped per CSV conventions. If Excel shows garbled text, confirm the encoding is UTF-8.

Do I need to click convert?

Yes. After pasting, click “Convert” to build the preview and download.

Recommended workflow

Prepare an array of objects (the most common list API shape).
Convert and check that headers cover the columns you need.
Download CSV or copy the text into spreadsheet software.
If there are too many columns, project a slimmer structure with JSONPath first.

CSV has no types: numbers and strings may be reformatted by Excel. Import critical IDs as text columns.