CloudlessToolsConverting CSV to JSON
Paste CSV data or open a .csv file exported from Excel, Google Sheets or a database. With First row is header on, each row becomes a JSON object keyed by the column names. Turn it off to get an array of arrays instead. Quoted fields, commas inside quotes and line breaks inside cells are all handled.
Converting JSON to CSV
Paste an array of objects such as an API response. Every key found in any object becomes a column, so rows with missing fields still line up. Nested objects are flattened into columns like address.city. If your JSON wraps the list in an object, for example {"data": [...]}, the list is found automatically.
Opening the CSV in Excel
Downloaded CSV files include a UTF-8 marker so Excel shows accented letters and emoji correctly.