Convert JSON arrays to clean CSV spreadsheets instantly. Preview the table, customise the delimiter, and download your CSV file ready for Excel or Google Sheets.
ExperToolBox's JSON to CSV converter transforms JSON array data into clean, structured CSV files that can be opened directly in Microsoft Excel, Google Sheets, LibreOffice Calc, or any other spreadsheet application. Paste your JSON, see an instant table preview, customise the delimiter if needed, and download your CSV with one click.
This tool is invaluable for developers and data analysts who work with REST APIs (which return data in JSON format) and need to share that data with non-technical colleagues or import it into data analysis tools.
The converter accepts a JSON array of objects at the root level. Each object in the array becomes a row in the CSV, and the keys of the objects become the column headers. If different objects in the array have different keys, all unique keys from all objects will be included as columns.
Nested objects and arrays are converted to their JSON string representation in a single cell. For deeply nested data, you may need to flatten the structure first or use a more specialised tool.
The comma (,) delimiter is the standard for CSV files and works with most applications. The semicolon (;) delimiter is common in European countries where the comma is used as a decimal separator — Excel in some locales defaults to this. The tab delimiter creates TSV (Tab-Separated Values) files, which are useful when your data contains commas. The pipe (|) delimiter is less common but useful when both commas and tabs appear in your data.