JSON to CSV

Convert a JSON array to CSV. Nested objects are flattened with dot notation.

Input JSON

1

CSV Preview

Paste a JSON array on the left

Example: [{"name":"Ravi","city":"Surat"}]

2sp · UTF-8

JSON to CSV Conversion Example

Input JSON (array of objects):

json

[
  { "name": "Ravi",  "city": "Surat",     "age": 28 },
  { "name": "Priya", "city": "Ahmedabad", "age": 24 }
]

Output CSV:

name,city,age
Ravi,Surat,28
Priya,Ahmedabad,24

Nested Objects — Dot Notation Flattening

Nested objects are automatically flattened using dot notation:

json

[{
  "name": "Ravi",
  "address": {
    "street": "MG Road",
    "city":   "Surat",
    "pin":    "395007"
  }
}]

Becomes:

name,address.street,address.city,address.pin
Ravi,MG Road,Surat,395007

Delimiter Options

Delimiter	Best for
Comma (,)	Default — works everywhere in English locale systems
Semicolon (;)	European countries where comma = decimal separator
Tab (\t)	Data that contains commas or semicolons in values
Pipe (\|)	Data that contains both commas and tabs

Opening CSV in Other Tools

▸Excel — File → Import → From Text/CSV, choose UTF-8 encoding and your delimiter
▸Google Sheets — File → Import → Upload — auto-detects delimiter and encoding
▸Python Pandas — pd.read_csv('output.csv') — works directly with the downloaded file
▸SQL database — Most databases support LOAD DATA or COPY FROM for CSV import

Python Pandas example:

python

import pandas as pd
df = pd.read_csv("output.csv")
print(df.head())

Frequently Asked Questions

A flat array of objects where each object has the same keys. Each object becomes a row, each key becomes a column header.

Nested objects are flattened with dot notation. { address: { city: 'Surat' } } becomes a column named address.city.

If a JSON property is an array, its entire value is placed in one cell as a JSON string. Flatten or expand arrays before converting if you need each item in a separate column.

Excel may use the wrong encoding. Always use File → Import (not double-click) and choose UTF-8 encoding when importing CSV files.