JSON to CSV Converter

For a table, the converter needs a list of records. If the JSON is an array, each item becomes a row; if it is an object that holds one array of objects, such as the users of an API response, the rows come from that array, and the line under the result says so, as in “Rows taken from users”. Nested objects are flattened into columns with names joined by dots, such as address.city, and arrays into numbered columns, such as tags.0 and tags.1. The columns are those of all the rows, not only of the first one, so a key that appears only in later rows still gets its column. JSON Lines, one object per line, works too.

Under “Separator” choose a comma, a semicolon for spreadsheets in many European languages, a tab or a vertical bar, and untick “First row is column names” to leave out the header row. Text with the separator, quotes or line breaks is quoted correctly, null becomes an empty field, and numbers are written exactly as in the JSON, even very long ones. The downloaded .csv file opens in Excel with all letters intact. If the JSON has an error, such as a missing comma or a single quote, you see the line, the column and the reason. With “From” and “To” you can also convert JSON to XML, or CSV back to JSON.