toolboxapp

JSON to CSV

Convert a JSON array of objects into CSV format — ready to open in Excel, import into a database or share as a spreadsheet.

API responses, database exports and programmatically generated data frequently arrive as a JSON array of objects. Converting this to CSV allows it to be opened in Excel or Google Sheets, imported into a database or shared with colleagues who work in spreadsheets. This tool converts any flat JSON array of objects to CSV, using the object keys as column headers and each object as a data row.
0 chars
Data Tools

Runs locally  ·  No data sent to server  ·  Free, no signup

About JSON to CSV

API responses, database exports and programmatically generated data frequently arrive as a JSON array of objects. Converting this to CSV allows it to be opened in Excel or Google Sheets, imported into a database or shared with colleagues who work in spreadsheets. This tool converts any flat JSON array of objects to CSV, using the object keys as column headers and each object as a data row.

How to use JSON to CSV

Paste a JSON array of objects into the input box and click Run. The tool extracts all keys from the array, creates a header row and converts each object to a CSV row. Values containing commas, quotation marks or newlines are properly escaped. Copy the output or use it directly for import.

When to use this tool

Use this when you need to import API response data into Excel, Google Sheets or a database table, when exporting records for a report or data handoff, when sharing structured data with colleagues who work in spreadsheets, or when preparing JSON data for a CSV-only import pipeline.

Privacy

Converting JSON to CSV manually is error-prone, especially when handling special characters, quoted values or large arrays. This tool handles the conversion correctly every time, including proper RFC 4180 escaping. All processing runs in your browser — no data is uploaded.

Frequently asked questions

Does it handle nested objects?

The tool is optimised for flat arrays of objects. Nested objects within a row are serialised as a JSON string in that cell. If you need to flatten nested structures, pre-process the JSON before converting.

What if objects in the array have different keys?

The tool unions all keys found across all objects and uses them as column headers. Objects missing a particular key will have an empty cell in that column.

Is the output compatible with Excel?

Yes. The output uses standard CSV formatting with comma delimiters and RFC 4180 escaping — values that contain commas, newlines or quotation marks are enclosed in double quotes.

Can I convert back from CSV to JSON?

Yes. Use the CSV to JSON tool on this site to convert in the other direction.