JSON to CSV Converter: Convert JSON to CSV Online
Turn a JSON array into CSV for Excel or Google Sheets. Flattens nested objects, quotes values correctly and guards against formula injection. Runs in your browser.
Paste a JSON array and get CSV with one row per item. Every key becomes a column, nested objects can be flattened into columns such as address.city, and values with commas, quotes or line breaks are quoted correctly.
What it does
- Writes one row per array item and one column per key, in the order the keys first appear.
- Fills missing keys with empty cells, so uneven objects still line up.
- Flattens nested objects into columns such as address.city when you ask.
- Quotes values that contain the delimiter, quotes, line breaks or edge spaces.
- Writes lists and objects that are not flattened as JSON text in one cell.
- Optional formula protection adds a leading apostrophe to cells that start with =, +, - or @.
Example
Before
[{"name":"Ana","age":30,"address":{"city":"Pune","zip":"411001"}},{"name":"Smith, Bob","age":25,"address":{"city":"New York"}}]After
name,age,address.city,address.zip
Ana,30,Pune,411001
"Smith, Bob",25,New York,Frequently asked questions
- What JSON does it accept?
- An array of objects (the usual case), an array of arrays, an array of plain values, or a single object.
- What is formula injection?
- A spreadsheet treats a cell that starts with = as a formula. If the data comes from users, a cell such as =HYPERLINK(...) can run when opened. The protection option adds an apostrophe so the cell stays text.
- Why does Excel show my accents wrongly?
- Excel may assume an old encoding for a plain CSV. Import the file with UTF-8 selected, or open it in Google Sheets.
- Is my data uploaded?
- No. The conversion runs in your browser.
More tools
Code formatters
CSS beautifier CSS minifier HTML beautifier HTML minifier JavaScript beautifier JavaScript minifier JSON formatter YAML formatter XML formatter SQL formatter Markdown preview
Converters
Base64 encoder and decoder URL encoder and decoder Unix timestamp converter CSV to JSON HTML entity encoder and decoder Number base converter Time zone converter JSON to TypeScript XML to JSON HTML to Markdown Date difference calculator
Text tools
Regex tester Remove duplicate lines Lorem ipsum generator Word counter Case converter Text diff checker
Color and images
Color converter Contrast checker Image to Base64 Image resizer
Network
Subnet calculator Download time calculator Common ports list CIDR to IP range IPv6 address expander and compressor MAC address formatter curl command builder
Server and files
Cron expression explainer chmod calculator HTTP status codes
Encoding and security
Password generator UUID generator Hash generator JWT decoder QR code generator Password strength checker Wi-Fi QR code generator