Skip to main content
FileForge

JSON to CSV Converter

Convert a JSON array of objects into CSV that opens cleanly in Excel or Google Sheets, with correct quoting and a stable column order.

Runs in your browser — files never leave your device

Free · No sign-upOutputs CSV
Loading tool…

How to use JSON to CSV

  1. Paste a JSON array of objects (or a single object).

  2. Click Convert to CSV.

  3. Preview the output.

  4. Copy it or download a .csv file ready for Excel or Sheets.

About this tool

API responses arrive as JSON; stakeholders want spreadsheets. This converter takes an array of objects, builds the column set from the union of all keys (objects may have different keys), and emits standards-compliant CSV: values containing commas, quotes or line breaks are quoted and escaped so spreadsheets import them intact. Nested objects and arrays are serialized as JSON strings inside their cell, keeping the data lossless.

This is the tool for the common handoff moment when a developer has data as JSON but a colleague, client, or reporting tool needs it as a spreadsheet they can open, filter and sort in Excel or Google Sheets.

Common ways people use this

  • Turning an API response into a spreadsheet to share with a non-technical colleague
  • Exporting JSON data from an app or database into CSV for reporting purposes
  • Converting a JSON array into a format that can be opened, filtered and sorted in Excel

Tips for better results

  • If your objects don't all share the same keys, don't worry — the converter automatically creates a column for every key that appears anywhere in the array.
  • Import phone numbers, ZIP codes or ID numbers as text in Excel afterward if you need to preserve leading zeros, since Excel applies its own type guessing on import.

Frequently asked questions

What happens to nested objects?
They are written into their cell as a JSON string, so no data is lost. If you need them flattened into separate columns, restructure the JSON before converting.
My objects don't all have the same keys — is that a problem?
No. The columns are the union of every key found; objects missing a key get an empty cell in that column.
Will Excel mangle values like phone numbers?
Excel applies its own type guessing on import (e.g. stripping leading zeros). The CSV itself is correct; import the column as text in Excel to preserve such values.
Can I convert a single JSON object instead of an array?
Yes, a single object is treated as a one-row result, producing a CSV with a header row and one data row.
What delimiter does the output CSV use?
Comma by default, matching the most common CSV convention — the same as accepted by the CSV to JSON tool's default setting.

Related tools

Other tools people commonly use alongside this one.

CSV to JSON

Turn CSV data — pasted or from a file — into a JSON array of objects, using the header row as keys. Quoted fields and embedded commas are handled correctly.

Developer

JSON Formatter

Paste minified or messy JSON and get a cleanly indented, readable version. Invalid JSON produces an error with the line and position of the problem.

Developer

JSON Minifier

Strip every unnecessary space and line break from JSON to get the smallest valid representation — with the size saving shown.

Developer