Delimiter:
JSON Input
CSV Output
What this tool does
Free JSON to CSV converter: convert JSON arrays to CSV, TSV, or semicolon-delimited files instantly
How JSON to CSV conversion works and when each format is appropriate
This JSON to CSV converter takes a JSON array of objects and transforms it into a flat CSV table. Each object in the array becomes a row, and each unique key across all objects becomes a column header. The converter automatically handles inconsistent schemas. If some objects have fields that others lack, those cells are simply left empty in the output.
Nested objects and arrays are JSON-stringified into a single cell rather than silently discarded. This means no data is lost in the conversion, though deeply nested structures may require additional processing in your spreadsheet application after export. The three delimiter options, comma, semicolon, and tab, cover the major CSV variants used across different locales and applications.
Common use cases: exporting API response data to Excel for analysis, converting database query results returned as JSON to spreadsheet format, preparing bulk import files for CRMs or email platforms, and transforming JSON logs into tabular format for reporting.
Features and capabilities
Instant Conversion
Converts as you type. No button click. Results appear immediately as you paste or edit the JSON.
Handles Missing Fields
Collects all keys from all objects, not just the first. Missing fields become empty cells, not errors.
3 Delimiter Options
Comma (standard), semicolon (European Excel), or tab (TSV). One click to switch.
Nested Values
Objects and arrays inside fields are JSON-stringified into the cell so no data is silently lost.
Row & Column Count
Shows how many rows and columns were produced so you can verify the conversion at a glance.
Download CSV
Save the output as a .csv file with one click. Ready to open in Excel, Google Sheets, or any data tool.
Copy to Clipboard
Copy the full CSV output for direct pasting into your application.
100% Client-Side
All conversion runs in your browser. Your data never leaves your device.
Examples
JSON to CSV examples: flat arrays, missing fields, and nested values
Real examples showing how different JSON structures convert to CSV
Basic ArraySimple flat array: each object maps directly to a CSV row
JSON Input:
[
{"id":1,"name":"Alice","email":"[email protected]"},
{"id":2,"name":"Bob", "email":"[email protected]"}
]
CSV Output:
id,name,email
1,Alice,[email protected]
2,Bob,[email protected]
The most common case: a flat array where every object has the same keys. Each key becomes a column header, each object becomes a row. This pattern matches most REST API list endpoints, database query results, and data exports.
Missing FieldsInconsistent schema: objects with different keys
JSON Input:
[
{"id":1,"name":"Alice","role":"admin","phone":"555-1234"},
{"id":2,"name":"Bob"},
{"id":3,"name":"Carol","role":"user"}
]
CSV Output (all keys collected):
id,name,role,phone
1,Alice,admin,555-1234
2,Bob,,
3,Carol,user,
When objects have different keys, this tool collects all unique keys from across the entire array and uses them as column headers. Missing values become empty cells. Bob has no role or phone (empty cells), and Carol has no phone. No data is lost or silently omitted.
FAQ
Frequently asked questions about JSON to CSV conversion
What JSON structure can be converted to CSV?
CSV is a flat, tabular format. It represents a 2D table with rows and columns. So only JSON arrays of objects (where each object has the same or similar keys) convert naturally to CSV. Each object becomes a row, each key becomes a column. Nested objects or arrays within the data are JSON-stringified into a single cell. A single JSON object (not in an array) is also supported. It becomes a single-row CSV. Deeply nested JSON hierarchies (like a tree structure) cannot be meaningfully flattened to CSV without custom transformation logic.
What happens to nested objects and arrays in the JSON?
When a field's value is an object or array, this tool JSON-stringifies it and puts the result in the CSV cell. For example, {"address": {"city": "London"}} becomes a cell containing {"city":"London"}. If your data has nested structures you want to flatten, you'll need to pre-process the JSON first. For example, flattening address.city into a top-level field before converting. This is a fundamental limitation of the CSV format, not of this tool.
What delimiter should I use. Comma, semicolon, or tab?
Comma (,) is the standard delimiter for CSV files opened in most English-locale applications. Semicolon (;) is commonly used in European countries where the comma is used as a decimal separator. Excel in these regions defaults to semicolon-separated files. Tab (\t) creates TSV (Tab-Separated Values) files, which are less likely to have conflicts with data that contains commas or semicolons. Choose based on what your target application expects or whether your data contains the delimiter character.
How do I open the CSV in Excel?
Save the CSV file with a .csv extension. In Excel, go to File → Open and select the file. If Excel opens it as a single column (all data in column A), the delimiter is mismatched. Use Data → Text to Columns → Delimited and select the correct delimiter. Alternatively, use the semicolon delimiter if you're using a European locale of Excel. Modern versions of Excel (2016+) usually auto-detect the delimiter correctly for standard comma-separated files.
Are missing fields handled correctly?
Yes. This tool collects all unique keys from across all objects in the array, not just the keys from the first object. If some objects are missing certain keys, those cells are left empty in the CSV output. This means you can safely convert JSON arrays with inconsistent schemas (where different objects have different sets of keys) and the resulting CSV will have columns for all keys, with empty cells where data is absent.
Related Developer Tools
Need a disposable email address?Get a free instant throwaway email. No signup, no trace.
Get Free Temp Mail →