JSON Table Exporter
Turn a JSON array into a spreadsheet-ready table, with the cells that spreadsheets treat as formulas made inert.
A list of objects. Each object becomes a row.
2 rows, 4 columns
Runs entirely in your browser. Your input is not uploaded or stored.
/id,/name,/active,/tags 9007199254740993,"Ana, Rose",true, 2,Tilly,false,"[""new""]"
What the conversion did
- 2 rows, 4 columns.
- Columns are JSON Pointers, so a key written
"a.b"and a nesteda→bstay apart as/a.band/a/b. - 1 array value written as compact JSON in a single cell.
- Numbers keep the digits they were written with, so a value past 9,007,199,254,740,991 is not rounded.
- Spreadsheet-safe text puts an apostrophe before a cell starting
=,+,-or@. That changes the text, and spreadsheets differ in what they treat as a formula — it is a convenience, not a security control.
CSV cannot describe nesting, so this conversion is not reversible in general.
How to use this calculator
- Paste or drop a JSON array of objects. A single object is treated as one row if you ask it to be.
- Pick the delimiter, whether to add a UTF-8 BOM, and what an absent value should look like in a cell.
- Check the preview table, then copy the CSV or download it.
How it works
Columns come from the keys actually present across the rows, in first-seen order, so a key that only appears halfway down still gets a column rather than shifting everything after it.
A value beginning =, +, - or @ is what a spreadsheet reads as a formula. Spreadsheet-safe text prefixes those cells so they open as the text you exported instead of being evaluated by whoever opens the file.
A UTF-8 BOM is offered because Excel on Windows will otherwise read a UTF-8 CSV as the local code page, which is what turns an accented name into mojibake.
Worked example
A cell that looks like a formula. A value of =1+1 is exported so that it opens as the text =1+1, not as the number 2. Without that, a column of part numbers like -A100 becomes a column of negative numbers.
Common mistakes
- Expecting nested objects to flatten into columns — they are not invented for you.
- Skipping the BOM and then opening the file in Excel on Windows.
- Assuming a CSV preserves types: everything in a CSV is text when it is read back.
Tips
- Runs entirely in your browser. Your input is not uploaded or stored.
Frequently asked questions
Why does my =SUM cell come out as text?
Because a CSV cannot tell a spreadsheet that a cell is data rather than a formula. Turning spreadsheet-safe text off exports it raw, but then anyone opening the file runs whatever it says.
What happens to a key that only some rows have?
It still becomes a column, and the rows without it get your chosen empty-cell value rather than being skipped.
Is anything uploaded?
Runs entirely in your browser. Your input is not uploaded or stored.
Related tools
- YAML JSON Workbench
- XML Layout Workbench
- Local ZIP Workshop
- CSV to JSON Converter
- JSON Formatter & Minifier
- Base64 Encoder / Decoder
Explore more in PDF, Image, File, Data & Developer Tools.
Cite this tool
Zerdly. (2026). JSON Table Exporter. Retrieved from https://www.zerdly.com/tools/json-table-exporter/
Tip: Enter any known values to calculate the remaining results.
Designed to run locally in your browser. Tool inputs are not intentionally stored by Zerdly unless stated otherwise.



