Convert JSON to CSV
Quickly convert a JSON data structure to a CSV file. Runs entirely in your browser, so your data never leaves your device.
0 chars · 0 lines
Output
The result appears here as you type.
How to use Convert JSON to CSV
- 1. Paste the JSON. Put an array of objects, or an array of arrays, into the input pane. Nested keys are flattened sensibly and the union of all keys across objects becomes the column set, so ragged records still line up.
- 2. Decide on a header row. Keep Header row checked to emit the collected keys as the first line, which is what Excel and most import wizards expect. Uncheck it when you are appending rows to a file that already has one.
- 3. Copy the CSV. Use the copy button on the output pane and paste the rows straight into a spreadsheet, a database import dialog or a .csv file. Objects missing a key simply get an empty cell in that column.
When to use Convert JSON to CSV
Convert JSON to CSV is the export path from code back to spreadsheet land. API responses, log records and NoSQL dumps arrive as JSON, but the person who asked for the data wants to open it in Excel or Google Sheets. This tool flattens the objects into rows with a shared header.
- Handing API data to a non-developer. Finance asks for last month's orders and your only source is a REST endpoint. Paste the JSON response here, copy the CSV, and send them a file that opens cleanly in Excel.
- Building a quick pivot table. You exported analytics events as a JSON array and want to slice them by day. CSV drops straight into Google Sheets where a pivot table takes thirty seconds to set up.
- Diffing records from two environments. Staging and production return slightly different objects. Converting both payloads to CSV lines the fields up column by column, so the mismatched city value in one record is obvious at a glance.
- Migrating a NoSQL export to SQL. A mongoexport dump is a wall of JSON documents. Turn it into CSV with a header row and most relational databases can bulk-load it with their standard COPY or LOAD DATA command.
Examples
Convert an array of objects
Input
[{"name": "Ada", "age": 36}, {"name": "Grace", "age": 45, "city": "NYC"}]Output
name,age,city Ada,36, Grace,45,NYC
About the Convert JSON to CSV tool
Convert JSON to CSV runs as plain JavaScript in your browser tab, with no server behind it. Quickly convert a JSON data structure to a CSV file. Whatever you put in stays on your device from start to finish.
The tool is part of EditSafely's CSV Tools section, 133 single-purpose utilities built around the same idea: open the page, get the result, keep your data to yourself.
You can shape the output with the Header row setting, and the result refreshes the moment you change it. A worked example further down the page shows exactly what the tool produces for a real input.
That local-first design has practical benefits beyond privacy. The tool keeps working on a flaky connection once the page has loaded, results are instant because nothing round-trips to a server, and it is safe to use with confidential material.
Frequently asked questions
Does Convert JSON to CSV cost anything?
Yes, it is completely free. All 2,658 tools on EditSafely work without an account, a subscription or usage limits.
Is it safe to paste sensitive or confidential data?
No data leaves your device. The whole tool is JavaScript that runs inside your browser tab, so there is no upload, no server-side processing and no log of what you did. If you disconnect from the internet after the page loads, it keeps working.
How much text can I process at once?
There is no fixed limit. Because the work happens on your own device rather than on a shared server, the practical ceiling is your machine's memory, which comfortably handles inputs far larger than typical online tools allow.
Do I need to sign up or install anything?
Nothing to install and no account needed. Open the page in any up-to-date browser, including on a phone or tablet, and the tool is ready.
How do I use the result?
The output panel has a one-click copy button, and you can keep refining the input while you work; the result updates in place as you type.