JSON to CSV

Flatten JSON into a CSV file for any spreadsheet

CSV is the lowest common denominator of data exchange: every spreadsheet, database and reporting tool imports it. JSON to CSV converts a JSON array of objects into a CSV file with a header row, so data from a web service or an export can be opened, filtered and charted in seconds.

Paste the JSON or drop a .json file. The columns are the union of all keys in the records, in the order they first appear, so records with missing fields simply have empty cells. Nested objects become dotted columns such as customer.name and arrays become numbered columns, one per item; this keeps every value reachable and lets CSV to JSON rebuild the original structure later. Values containing commas, quotes or line breaks are quoted correctly, booleans are written as true and false, and null becomes an empty cell. Choose a comma, semicolon or tab delimiter to match the spreadsheet and locale you are importing into.

A JSON file that is not a list of objects is still converted: an object becomes a single row, a list of values a single column, and the result tells you how it was laid out. The file is saved as UTF-8 with a byte-order mark so accented and non-Latin text opens correctly in Excel. For a formatted workbook with several sheets use JSON to Excel.