The Paper Room

JSON to CSV Converter

Paste a JSON array of objects and convert it to a CSV file. The tool automatically extracts all unique keys as column headers and fills in values for each row. Nested objects are flattened using dot notation — for example, {"address": {"city": "NYC"}} becomes a column named "address.city".

This is useful when you need to import API response data into a spreadsheet, create reports from JSON data, or prepare data for tools that expect CSV input. Values containing commas or quotes are properly escaped according to RFC 4180.

All processing happens locally in your browser — no data is sent to any server.

By The Paper Room Editorial TeamDeveloper Tools

Frequently asked questions

How are nested objects handled?

Nested objects are flattened using dot notation. For example, {"user": {"name": "Alice", "age": 30}} produces columns "user.name" and "user.age". Arrays within objects are converted to their JSON string representation.

What if objects have different keys?

The tool collects all unique keys from every object in the array to form the header row. Objects missing a key will have an empty value in that column.

Does it handle special characters in values?

Yes. Values containing commas, double quotes, or newlines are wrapped in double quotes per the CSV standard (RFC 4180). Double quotes within values are escaped by doubling them.