Question 1

What JSON structure works for CSV conversion?

Accepted Answer

The converter works best with a JSON array of objects where all objects share the same keys — this is the most common format for API list responses. Each object becomes one row, and the keys of the objects become column headers. If your objects have different keys, the converter performs a union of all keys and leaves blank cells where a key is absent. Single objects are also supported and produce a one-row CSV.

Question 2

How are nested objects handled?

Accepted Answer

Nested objects and arrays inside JSON properties are serialized as JSON strings within the CSV cell. For example, an address object becomes the string {"street":"123 Main",...}. If you need nested objects as separate columns, flatten your JSON before converting — you can use a JavaScript transformation like Object.assign to spread nested properties into the parent object before pasting.

Question 3

Are special characters and commas in values handled correctly?

Accepted Answer

Yes. The converter correctly implements CSV escaping rules. Values containing commas, double quotes, or newlines are enclosed in double quotes. Double quotes within values are escaped by doubling them. This ensures the output is valid CSV that Excel and other tools will parse correctly without data corruption.

Question 4

Can I open the CSV directly in Excel?

Accepted Answer

Yes. Download the .csv file and open it in Excel or Google Sheets. Excel on Windows should recognize it automatically. If values with special characters appear incorrectly, try importing via Data > From Text/CSV in Excel and specify UTF-8 encoding. Google Sheets handles UTF-8 CSV perfectly when you use File > Import.

JSON to CSV Converter

What is a JSON to CSV Converter?

How to Use PureFormatter

Frequently Asked Questions