How to use
- Choose JSON → CSV or CSV → JSON.
- Paste your data; the result appears instantly. JSON is usually an array of objects like
[{...}, {...}], but a single object or a wrapper such as{"items": [...]}works too. - Pick the delimiter (comma, semicolon, tab or pipe) and whether there’s a header row. When reading CSV, the delimiter is detected automatically.
- Copy or download the result. Use result as input flips the direction so you can convert it straight back.
Conversion rules
| Case | JSON → CSV | CSV → JSON |
|---|---|---|
Nested object {"customer": {"name": "Jane"}} |
Column customer.name |
Turn on “Nest dotted keys” to rebuild the object |
Array {"items": ["T-shirt", "Cap"]} |
Columns items.0, items.1 (or one JSON cell) |
items.0, items.1 become an array again |
| Objects with different keys | Every key becomes a column in first-seen order; missing cells are empty | - |
| Values with commas, quotes, line breaks | Wrapped in double quotes, " doubled to "" (RFC 4180) |
Read with the same rules |
| Values that look numeric | Written as-is | 31 → number; 02134 (leading zero), phone numbers and integers past 2^53 stay strings |
Opening CSV in Excel
Excel for Windows only recognizes a CSV as UTF-8 when it starts with a byte order mark (bytes EF BB BF); otherwise it uses the system’s legacy code page, and accented or non-Latin characters turn into mojibake like José. “Add UTF-8 BOM for Excel” is on by default, so the downloaded file opens correctly with a double-click. The BOM goes into the file only, not into copied text. Semicolon-separated files are common in European locales where the comma is the decimal separator.
Things to watch out for
- CSV formula injection: cells beginning with
=,+or@can run as formulas in Excel. If the data comes from outside sources, turn on “Block Excel formulas” | such values get a leading'so they display as text. Plain negative numbers like-3are left alone. - CSV has no data types. After JSON → CSV → JSON, numbers and
true/falsecome back when “Convert numbers” is on, butnulland empty strings both become empty cells and return as empty strings. - If your JSON won’t parse, the JSON Formatter shows the exact line and column of the error.
FAQ
Can I get an .xlsx file?
A CSV opens directly in Excel; use “Save As” there to get .xlsx. Going the other way, copy a range in Excel and paste it here | it’s read as tab-separated CSV.
Is my data uploaded?
No. Conversion runs in your browser with the papaparse library, so customer lists and other sensitive data never leave your machine.