JSON to CSV Converter (and CSV to JSON)

Paste JSON and get a CSV you can open in Excel or Google Sheets, or paste CSV and get clean JSON for your code. Nested objects are flattened into columns like address.city, arrays are handled the way you choose, and numbers, true/false and empty values are detected when converting back.

  • Both directions
  • Nested JSON
  • Excel-ready CSV

How to use the JSON to CSV Converter tool

  1. Pick the directionChoose JSON → CSV or CSV → JSON.
  2. Paste or open your dataPaste text or open a .json or .csv file. JSON Lines (one object per line) works too.
  3. Adjust the optionsPick the delimiter, how arrays are written, and whether numbers and true/false become real JSON types.
  4. Download or copyCheck the table preview, then download the file or copy the result.

Features

  • Flattens nested JSON{"address": {"city": "Pune"}} becomes a column called address.city. Every key from every row becomes a column.
  • Rebuilds nestingChoose “nested by dots” to turn address.city columns back into nested JSON objects.
  • Smart typesNumbers, true/false and null are detected, but codes like 0110001 or long phone numbers stay as text.
  • Any delimiterComma, semicolon (for European Excel), tab or pipe, with automatic detection when reading CSV.
  • PrivateConversion runs in your browser. Your data is never uploaded, so it’s safe for customer lists and exports.

How JSON becomes a table

CSV is a flat table, while JSON can be nested. The converter turns each object in a JSON array into one row and each key into a column. Nested objects get dotted column names, and keys that only appear in some rows still get a column (empty for the other rows):

JSONCSV columns
{"id": 1, "name": "Aarav"}id, name
{"address": {"city": "Pune", "pin": "411001"}}address.city, address.pin
{"skills": ["PHP", "SQL"]}skills = “PHP; SQL”, or skills.0 and skills.1, or ["PHP","SQL"]

If your JSON is an object that wraps the list, such as {"data": [ … ]} from an API, the converter finds the first array of objects and uses that.

Opening the CSV in Excel

  • Special characters look wrong? Tick “Excel-friendly (UTF-8 BOM)” so Excel reads Hindi, accented letters and ₹ correctly.
  • Everything is in one column? In countries that use a comma for decimals (Germany, France, Brazil…), Excel expects semicolons. Choose “Semicolon”.
  • Leading zeros disappear? Excel turns 0110001 into 110001 when it opens a CSV. Import the file with Data → From Text/CSV and set that column to Text, or use the JSON to Excel tool, which keeps text columns as text.

CSV to JSON for developers

When converting CSV to JSON, the first row is used as the keys. With “Detect numbers, true/false and null”, 42 becomes a number, true a boolean and empty cells become null, which is usually what an API or database import expects. Values with leading zeros and numbers longer than 15 digits stay strings, so PIN codes, phone numbers and IDs aren’t damaged. Choose “Array of arrays” for compact data, or JSON Lines for streaming imports into tools like BigQuery, Elasticsearch or MongoDB.

Quotes, commas and line breaks inside values are handled according to RFC 4180, the CSV standard. To check or pretty-print the JSON afterwards, use the JSON Formatter; to convert Excel files, use Excel to CSV.

Frequently asked questions

How do I convert JSON to CSV?
Paste your JSON array (or open a .json file) with “JSON → CSV” selected. The CSV appears instantly; click “Download CSV”.
What happens to nested JSON objects?
They are flattened into dotted columns, for example address.city. You can rebuild them later with “CSV → JSON” and “nested by dots”.
How are arrays converted?
Choose to join them in one cell (a; b), keep them as JSON text, or give each item its own column.
Can I convert CSV to JSON?
Yes. Select “CSV → JSON”. The delimiter is detected automatically and the first row becomes the keys.
Why does Excel show strange characters?
Tick “Excel-friendly (UTF-8 BOM)” before downloading so Excel uses the correct character encoding.
Is my data uploaded?
No. The conversion runs in your browser and nothing is sent to a server.