Why it matters
Clients live in spreadsheets and websites live in JSON. Moving product lists, form entries or analytics exports between the two is a weekly job, and naïve conversions break on the first comma inside a value.
This converter follows the CSV standard (RFC 4180) for quoting, flattens nested objects into readable columns, and adds the small byte-order mark that stops Excel turning £ into £.
How it works
- InputJSON or CSV
- In your browserFlattened or rebuilt, with types kept
- OutputCSV that opens in Excel, or JSON
Where it fits in a designer's workflow
- Plan
- Design
- Build
- Test
- Launch
By the numbers
Show the numbers as a table
| Format | Bytes |
|---|---|
| JSON | 193 |
| CSV | 138 |
How to use it
- Choose a direction with the tabs.
- Paste your JSON array or CSV.
- Pick the delimiter and options.
- Check the preview, then download the result.
FAQ
What JSON shapes work?
An array of objects works best. A single object becomes one row, and an object holding one array (like {"items": […]}) is unwrapped automatically.
How are arrays inside objects handled?
Arrays of plain values are joined with a semicolon in one cell. Arrays of objects are kept as JSON text in the cell.
Why semicolons?
Excel in many European locales expects semicolons, because the comma is the decimal separator there.
Is my data uploaded?
No. Everything is converted in your browser.
