Free JSON to CSV Converter Online
Convert a JSON array of objects to CSV format. Extracts all keys as headers and outputs clean, comma-separated values ready for Excel or Google Sheets.
JSON arrays of objects are the standard output format for APIs and databases, but spreadsheet users and reporting tools expect CSV. This tool takes a JSON array where each element is an object and produces a CSV with the keys from the first object as headers and each object's values as a row. The output is clean, comma-separated, and ready to open in Excel, Google Sheets, or any data tool. Nested objects and arrays in the values are serialized as JSON strings so no data is lost.
JSON to CSV
How to use this json to csv converter
- Paste your JSON array into the input box. The input must be an array of objects (starting with '[' and ending with ']').
- Click Convert to generate the CSV.
- The first row of the output is the header row, taken from the keys of the first object.
- Click Copy to put the CSV on your clipboard.
Common use cases
- Exporting API data for analysis in a spreadsheet without writing a script
- Preparing a report from a JSON data source for a non-technical stakeholder
- Converting a database query result (returned as JSON) into a CSV for a data analyst
- Exporting a list of users, orders, or products from a JSON-based API
- Creating a CSV seed file for a CMS or bulk-import tool from a JSON data model
Frequently asked questions
What if my objects have different keys?
The converter uses the keys from the first object as column headers. If later objects have additional keys, those columns are not included. If they are missing keys, those cells are left empty.
How are nested objects handled?
Nested objects and arrays are serialized as JSON strings in the CSV cell. If you need nested fields flattened into separate columns, preprocess the JSON before converting.
Are values with commas or quotes handled correctly?
Yes. The converter wraps any value containing a comma, double quote, or newline in double quotes, and escapes embedded double quotes as two double quotes — the standard CSV escaping convention.
Can I convert a single JSON object, not an array?
Not directly. Wrap it in an array first: paste [{...your object...}] and the converter will produce a single-row CSV.