Convert CSV ↔ JSON
Convert CSV tables to JSON and back without uploading your data.
Convert CSV ↔ JSON: how it works
Convert CSV tables to JSON or export JSON arrays as CSV. Choose a delimiter and whether to use headers, then paste content or load a UTF-8 file. Quotes, delimiters inside fields and quoted line breaks are handled by a locally bundled copy of Papa Parse.
- Choose CSV → JSON or JSON → CSV and load or paste your data.
- Select the delimiter and header option. Review formula protection when exporting CSV.
- Convert, review and copy or download the result. An optional UTF-8 BOM helps open CSV files in Excel.
Frequently asked questions
Are leading zeros and types preserved?
CSV → JSON keeps every value as text, including 00123 and true. Without headers it produces arrays of rows. JSON → CSV accepts flat objects or arrays of rows; null and missing values become empty cells. Array rows receive column_1, column_2, etc. headers. Very large JSON numbers can lose precision.
Which data is rejected?
Files over 1 MB, uneven rows, empty or duplicate headers and nested JSON values are rejected. Limits are 10,000 rows, 100 columns and 500,000 cells. Completely empty CSV lines are skipped.
What does formula protection do?
It prefixes text and headers that spreadsheets might interpret as formulas with an apostrophe. This changes those values; disable it only for trusted data when exact preservation is needed.