JSON to CSV & CSV to JSON — Free Converter
Convert JSON to CSV and CSV to JSON for free online. Bi-directional, handles quoted fields. Browser-based — files never uploaded.
Convert JSON to CSV and CSV to JSON in one click — both directions, one tool. PDFFlare's JSON to CSV converter handles arrays of flat objects, single objects, and arrays of primitives. The included CSV parser is RFC 4180-compliant: quoted fields, escaped quotes, CRLF endings, and embedded line breaks all work.
Everything happens in your browser — your data never goes to a server. Need to validate the JSON shape before converting? JSON Formatter is your friend. Want TypeScript interfaces from the same JSON? JSON to TypeScript one click away.
How to Convert JSON to CSV (and CSV to JSON)
Pick a direction
Choose JSON → CSV (default) to flatten an array of objects into a spreadsheet, or CSV → JSON to read a CSV file as a JSON array.
Paste your data
Paste an array of flat objects (for JSON → CSV) or a CSV with a header row (for CSV → JSON) into the input panel.
Click Convert and copy the result
Click Convert. The result appears in the output panel. Click Copy Output to copy it to your clipboard, or use the ⇄ Swap button to move the output back to the input and flip direction.
When Do You Need a JSON / CSV Converter?
Loading API data into a spreadsheet: Copy an API response, convert to CSV, paste straight into Excel or Google Sheets for ad-hoc reporting and slicing.
Importing CSV into a script: Got a CSV from sales, accounting, or a vendor? Convert it to JSON in one click so your script can JSON.parse it instead of hand-rolling a CSV reader.
Sharing data with non-technical teammates: Engineers think in JSON; everyone else thinks in spreadsheets. Convert JSON to CSV before sending it over so nobody has to learn a new format.
Bulk-editing data offline: Convert API output to CSV, edit it in Excel, then convert back to JSON to feed it into your import script. Round-trips for any flat object data.
Why Use PDFFlare for JSON ↔ CSV?
Both Directions
JSON → CSV and CSV → JSON in the same tool. The ⇄ Swap button moves the output back to the input and flips direction in one click.
RFC 4180 CSV Parser
Quoted fields, escaped quotes, CRLF endings, and line breaks inside cells are all parsed correctly. Not a naive comma-split.
100% Browser-Based
Your data stays on your device. Safe for customer records, production exports, or anything you can't upload to a random web service.
No Signup Required
No account, no rate limits, no upgrade prompt. Open the tool, paste, click, copy.
Frequently Asked Questions About JSON to CSV
An array of flat objects is ideal — each object becomes one row, with all unique keys becoming the column headers. A single object becomes a 2-row CSV (headers + one data row). Arrays of primitives become a single-column CSV with header 'value'.
Nested objects and arrays inside cells are serialized as inline JSON strings rather than failing. For deeply nested data, consider flattening it first — a JSON Flatten tool is on our roadmap.
Yes. PDFFlare's CSV parser is RFC 4180-compliant: it correctly handles fields wrapped in double quotes, escaped quotes inside quoted fields (e.g., ""hello""), commas and line breaks inside quoted fields, and CRLF line endings.
Currently the parser uses comma as the delimiter (the C in CSV). Tab-separated and semicolon-separated input would need a future option — for now, a quick find-and-replace on the input gets you there.
On JSON → CSV the tool unions all keys across all objects, so missing keys produce empty cells in the CSV (preserving column alignment). On CSV → JSON, missing trailing cells produce empty strings on the resulting object.
JSON → CSV → JSON round-trips for flat data. For nested objects and arrays, JSON-as-string serialization is one-way — you'd need to JSON.parse the cell value to get the structure back. Pure flat data round-trips perfectly.
No. PDFFlare's JSON to CSV converter runs entirely in your browser. Your data — including any sensitive customer records or production exports — never leaves your device.
The Copy Output button gives you the result on your clipboard, ready to paste into Excel, Google Sheets, or a .csv file. A direct download button is on our short-term roadmap.