JSON to CSV
Convert a JSON array to CSV. Nested objects are flattened with dot notation.
2sp · 14px · UTF-8
What is JSON to CSV Conversion?
Converting JSON to CSV exports structured API data into a flat tabular format that spreadsheet tools (Excel, Google Sheets) and data platforms (BigQuery, Pandas, Tableau) can consume directly. Each JSON object in the array becomes a CSV row; each key becomes a column header.
Nested objects are a common challenge: this tool flattens them automatically using dot notation — a field like {"address": {"city": "Surat"}} becomes a column named address.city. This makes the conversion lossless even for complex nested structures.
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,24Nested 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,395007Delimiter 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())