JSON to CSV

Turn an API response or JSON export into a spreadsheet-ready CSV file.

● Your files are processed locally in your browser and are not uploaded to our servers.

How it works

Each object of the array becomes a row and every key found in any object becomes a column, so records with missing fields still line up. Nested objects are flattened into dotted column names (address.city); arrays are written as JSON text. Values containing the delimiter, quotes or line breaks are quoted per RFC 4180.

FAQ

My accents look broken in Excel

Keep the “Excel UTF-8 mark” option on — it adds a BOM so Excel reads the file as UTF-8.

Excel puts everything in one column

In many European locales Excel expects semicolons. Choose the semicolon delimiter.