English
JSON to TSV converter
Export JSON arrays with large numbers, all columns and nested values preserved; preview tables and control formula protection. Inputs stay in this browser; no URL fetching or automatic saving. Files must be UTF-8.
No account needed
How to use
- 1Enter a JSON array of objects or equally wide arrays.
- 2Optionally select an array with JSON Pointer; choose headers, formula protection and null handling.
- 3Review the preview and raw result, then download the table.
Good to know
CSV imports default to strings; type detection is optional and 00123 stays a string. CSV cannot retain JSON types; spreadsheets may reinterpret large numbers. Formula protection adds a leading apostrophe.
Ads may process connection data. Personalization follows your privacy choices. Privacy (English)
When to use this tool
Use this to review an API array of objects in a spreadsheet. It collects differing keys as columns, keeps nested values as JSON text and previews the default formula protection.
Worked input and output example
The public example below is processed by the same calculation or conversion code as the tool. No personal input or draft is used.
Example input
[{"id":"00123","note":"=1+1"}]Example result
"id" "note" "00123" "'=1+1"
How to read and check the result
The string =1+1 exports as '=1+1 with protection enabled. This prefix helps prevent spreadsheet formula execution; check it when reimporting elsewhere. Array order remains, but tabular types differ from JSON.