JSON to CSV

Convert JSON arrays to CSV with headers.

Developer

Paste a JSON array of objects (e.g. from an API response) and convert it to CSV in one click. Headers are taken from the object keys; you can copy the result or download it as a .csv file for Excel or Google Sheets.

Result will appear here after conversion.

About JSON to CSV

JSON (JavaScript Object Notation) is the standard data format for APIs and web services. Many APIs return data as a JSON array of objects. Converting that data to CSV lets you open it in spreadsheets (Excel, Google Sheets, LibreOffice), run analyses, or import it into other tools. This converter runs entirely in your browser: it parses your JSON, uses object keys as column headers, and outputs comma-separated values — no upload and no server.

How to use

  1. Paste your JSON array of objects into the JSON input box. Ensure it is valid JSON (e.g. from an API or from our JSON Formatter).
  2. Click Convert to CSV. The CSV output appears below.
  3. Use Copy CSV to copy to the clipboard, or Download CSV to save a .csv file.

When to use

  • Exporting API or database results to a spreadsheet
  • Preparing data for reports or mailing lists
  • Sharing tabular data with people who prefer Excel or Sheets
  • Quick backup or archive of JSON data in a universal format

Details

Values that contain commas, quotes, or line breaks are automatically escaped in the CSV (wrapped in double quotes and internal quotes doubled). The first row is always the header row derived from the object keys.

Frequently Asked Questions

What JSON format does this tool accept?
It accepts a JSON array of objects, for example: [{"name":"Alice","age":30},{"name":"Bob","age":25}]. Each object becomes one row in the CSV, and the keys of the first object (or the union of all keys) become the column headers. Nested objects or arrays are converted to strings.
Is my data sent to a server?
No. Conversion happens entirely in your browser using JavaScript. Your JSON data never leaves your device, so it is safe for sensitive or confidential data.
Can I download the CSV file?
Yes. After converting, click "Download CSV" to save the result as a .csv file. You can open it in Excel, Google Sheets, or any spreadsheet application.
What if my JSON has different keys in different objects?
The tool collects all unique keys from every object. If one row is missing a key, that cell will be empty in the CSV. Column order follows the order keys were first seen.