JSON ↔ CSV Converter
Convert JSON to CSV and CSV to JSON, with quoted fields and nested values handled.
Converted CSV appears here.
About the JSON ↔ CSV Converter
This JSON to CSV converter turns an array of JSON objects into a spreadsheet ready CSV, and turns CSV back into a clean JSON array. Paste an API response or export and switch direction to go either way. The column order follows the order keys first appear, and every object contributes its keys, so rows with extra or missing fields still line up under the right headers.
Use it to load a JSON API response into Excel, Google Sheets, or a database import, or to turn a spreadsheet export into JSON for a script or a fixture file. Values that contain commas, quotes, or line breaks are quoted and escaped correctly, and nested objects or arrays are serialized as JSON inside the cell rather than silently dropped.
When converting CSV to JSON, the first row is treated as the header and becomes the object keys. The parser understands quoted fields, doubled quotes inside a quoted value, and newlines inside a cell, so well formed CSV from any spreadsheet round trips without mangling.
Everything runs in your browser. The data you paste is never uploaded, which makes this safe for exports that contain customer records, internal identifiers, or anything you would not send to a random web tool.
Reach developers and designers who use these tools every day. Privacy-first, no trackers.
Frequently asked questions
Is my data uploaded anywhere?
No. The conversion runs entirely in your browser with JavaScript, so the JSON or CSV you paste never leaves your machine. It is safe for exports that contain customer or internal data.
What JSON shape does it expect for JSON to CSV?
An array of objects, like [{"a":1},{"a":2}], where each object is one row. A single object is also accepted and becomes one row. The columns are the union of all keys, in the order they first appear.
How are commas and quotes inside values handled?
Any value containing a comma, double quote, or line break is wrapped in double quotes, and existing quotes are doubled, which is the standard CSV escaping that Excel and Google Sheets expect.
What happens to nested objects and arrays?
CSV is flat, so a nested object or array is written into the cell as a JSON string rather than expanded into more columns. That keeps the data lossless and reversible if you convert back.
Does CSV to JSON keep numbers as numbers?
Values are kept as strings to avoid guessing types and corrupting things like ZIP codes or IDs with leading zeros. If you need typed values, parse the JSON afterward and coerce the fields you know are numeric.