Convert JSON to CSV
Flatten JSON into CSV.
Entrada JSON
Opciones de conversión
Salida CSV
How do you convert JSON to CSV?
Docuboxer's JSON to CSV converter turns arrays of JSON objects into CSV tables directly in your browser, without uploading your data to any server. It's the shortest path from an API response, a database export or a structured log to Excel or Google Sheets: the tool automatically flattens nested objects using dot notation (user.address.city becomes a column), collects every field present anywhere in the array, and writes a CSV with UTF-8 plus BOM so Excel displays accented and special characters correctly on a double-click. You can pick the output delimiter — comma or semicolon, depending on your regional settings — and preview the table before downloading. Because everything happens in your device's memory, it's equally suited to internal or customer data that shouldn't leave your machine, and it keeps working offline once the page has loaded. Free, no signup.
How to use Convert JSON to CSV
- Paste your array of JSON objects, or load a JSON file with structured data, into the input panel.
- The tool automatically flattens nested objects and turns each field into a column of the resulting CSV.
- Preview the generated table, adjust the output delimiter if needed, and download the CSV ready to open in Excel.
Common use cases
Export API responses to spreadsheets
Convert JSON responses from REST APIs containing arrays of objects into tabular CSV you can open in Excel or Google Sheets for analysis, charts and reports.
Reports for non-technical teams
Turn data that lives in JSON — users, orders, metrics — into a table anyone on the team can open, filter and comment on in their usual spreadsheet, without asking them to read JSON.
Analyze logs and structured events
Convert JSON log exports (analytics events, webhooks, audit trails) to CSV so you can sort by date, group by field and spot patterns with pivot tables.
Migrate data to legacy systems
Transform JSON exports from modern applications into CSV compatible with older systems, relational databases and BI tools that require tabular input.
Customer data without the cloud
Convert sensitive information — client lists, transactions, payroll exported as JSON — without passing it through a converter that processes it on its servers: here it never leaves your browser.
Frequently asked questions
How do I convert JSON to CSV and open it in Excel?
Paste the JSON array or load the file, preview the resulting table, and download the CSV. The file is written with UTF-8 and BOM, so Excel opens it with a double-click and displays accents and special characters correctly — no manual import steps.
How are nested JSON objects handled?
Nested objects are flattened using dot notation in the column headers. For example, a user.address.city field becomes a column named user.address.city in the CSV, with its value on each row.
What if the objects in my array have different fields?
The tool creates a column for every unique field found in any object of the array. Cells where an object lacks a given field are left empty in the CSV, so no data is lost.
What happens to arrays inside the objects?
Inner arrays are serialized as JSON text inside the corresponding cell, so the data is preserved intact. If you need one row per array element, reshape the structure before converting.
Why do special characters look broken when opening a CSV in Excel?
Because Excel assumes a legacy encoding when a UTF-8 file has no BOM (a marker at the start of the file). This tool adds the BOM automatically when generating the CSV, so accented characters and symbols display correctly straight in Excel.
Can I use a semicolon as the CSV separator?
Yes. If your Excel uses a European or Latin American regional configuration, it probably expects semicolons between columns. The tool lets you choose comma or semicolon as the output delimiter before downloading.
Is my JSON data uploaded to a server?
No. The conversion runs entirely in your browser: no server requests, no logs, no data retention. It works offline once the page has loaded, and closing the tab leaves no trace.