JSON to CSV Converter

Turn an array of objects into a spreadsheet. Runs in your browser; nothing is uploaded.

How to convert JSON to CSV or TSV

  1. Paste your JSON array or object into Input (JSON), open a .json file, or click Sample. Syntax errors are underlined as you type.
  2. Choose a Delimiter (comma, semicolon, tab, or pipe), and toggle Header row or Flatten nested objects as needed.
  3. Click Convert to CSV, then copy the result to your clipboard or click Download to save a .csv file ready for Microsoft Excel, Google Sheets, Apple Numbers, or database import.

How JSON structures map to spreadsheet columns

An array of objects becomes a table with one row per object. Every key found across all objects becomes a column in the order first seen, so records with optional or extra keys still line up cleanly.

  • Nested objects: with Flatten nested objects checked, nested keys are joined with dots (for example team.name and team.floor). Uncheck it to keep nested objects as compact JSON strings inside a single cell.
  • Arrays inside objects: serialized as compact JSON inside the cell so row and column alignment is never broken.
  • RFC 4180 escaping: values that contain the delimiter, double quotes, or line breaks are automatically wrapped in double quotes with internal quotes doubled ("").
  • Exact large numbers: 64-bit IDs above 253 − 1 are copied verbatim without floating-point rounding.

Example: nested JSON to flattened CSV

Given a JSON array with nested objects:

[
  { "id": 1001, "name": "Ada Lovelace", "team": { "name": "Core", "floor": 3 } },
  { "id": 1002, "name": "Alan Turing", "team": { "name": "Systems", "floor": 5 } }
]

With Flatten nested objects enabled, the converter produces:

id,name,team.name,team.floor
1001,Ada Lovelace,Core,3
1002,Alan Turing,Systems,5

Choosing the right delimiter for Excel and Google Sheets

  • Comma (,): standard CSV format for Google Sheets, databases, and English locales of Microsoft Excel.
  • Semicolon (;): best for European and Latin American versions of Excel where the comma is reserved as the decimal separator.
  • Tab: produces TSV (tab-separated values), ideal for copying and pasting directly into an open spreadsheet grid.
  • Pipe (|): useful when your text fields contain frequent commas and semicolons.

Frequently asked questions

Why does Microsoft Excel open all CSV values in a single column?
In countries where a comma is used as the decimal separator (such as Germany, France, Spain, or Vietnam), Excel expects a semicolon (;) instead of a comma (,) as the CSV field delimiter. Change the Delimiter dropdown to Semicolon (;) or Tab before downloading.
What happens if some JSON objects have missing or extra keys?
The converter scans every object in the array first and builds the column list from the union of all discovered keys in the order they first appear. Objects that omit a key simply output an empty cell in that column, so every row stays aligned.
Can I convert a single JSON object or an array of primitive values to CSV?
Yes. A single JSON object is exported as a one-row table with its keys as headers, and an array of strings, numbers, or booleans is exported as a single-column CSV.
Are 64-bit IDs rounded when converting JSON to CSV?
No. Integers larger than 253 − 1 are written verbatim from the JSON source without floating-point rounding.

More tools