Question 1

What JSON format does this tool accept?

Accepted Answer

The tool expects a JSON array of objects, where each object represents one row. All objects should share the same keys, which become the CSV column headers. Example: [{"name":"Alice","age":30},{"name":"Bob","age":25}].

Question 2

What happens if objects have different keys?

Accepted Answer

The headers are extracted from the first object in the array. If later objects have extra keys, those columns are omitted. If later objects are missing keys, the corresponding cells are left empty.

Question 3

Are nested objects supported?

Accepted Answer

Nested objects are converted to their string representation. For example, a nested object {"address":{"city":"London"}} will appear as the text [object Object] in the CSV cell. Flatten your data before converting if you need nested values as separate columns.

Question 4

Is any data sent to a server?

Accepted Answer

No. Conversion runs entirely in your browser. Your JSON data is never transmitted anywhere.

Question 5

How do I open the downloaded CSV in Excel?

Accepted Answer

Open Excel, go to Data > From Text/CSV, select your file, and choose the correct delimiter. The downloaded file uses commas as the delimiter. If Excel auto-opens it with wrong formatting, use the import wizard instead of double-clicking.

JSON to CSV

When to use this

Export API data to spreadsheets

Database reporting

Data sharing

Free JSON to CSV converter

Quick answers

Related tools