CSV to JSON Converter
Convert CSV to JSON, or JSON back to CSV. Handles quoted fields and semicolon or tab separators.
Runs in your browser. Nothing you type is sent anywhere.
About the CSV to JSON Converter
CSV to JSON Converter turns spreadsheet exports into JSON, and JSON back into CSV. It handles quoted fields, commas and line breaks inside quotes, and comma, semicolon or tab separators, which it detects automatically.
Numbers and true/false become real values, but numbers with leading zeros (like 007 or ZIP codes) stay as text so they aren't changed.
How to use it
- Choose a direction.
- Paste your CSV or JSON.
- Choose whether the first row is a header.
- Copy the result.
Example
name,price followed by "Widget, large",12.50 becomes [{"name": "Widget, large", "price": 12.5}].
Questions
What about nested JSON?
When converting to CSV, nested objects and arrays are written into a cell as JSON text.
Different keys in different objects?
The CSV header includes every key found; missing values are left blank.
Can it read Excel files?
Save the sheet as CSV first, then paste it in.