Guide: Convert CSV to JSON and JSON to CSV
When to use it
To move data from a spreadsheet to an API or the other way around.
Tips
- The first row of the CSV is used as the key names.
- Fields with commas or line breaks are written between quotes.
- If you open the CSV in a Spanish-language Excel, you probably need a semicolon.
Frequently asked questions
What happens with nested objects?
When converting to CSV they are stored as JSON text inside the cell.