Union headers across records
[{"id":"001","name":"Ada"},{"id":"002","notes":"Uses, commas"}]Produces id, name, and notes columns, keeps 001 as text, and quotes the comma-containing notes cell.
📊JSON to CSVReady
JSON to CSV or TSV
Export an array of objects with a visible column plan. Nested values are serialized as JSON text; this tool does not silently flatten them.
Files stay in this browser and are not uploaded. Local files are limited to 5.00 MB. Formula protection is off by default because it changes exported cell values.
Capability checkedVerified September 9, 2026
What works
- Create stable headers from the first occurrence of each key across the array
- Quote commas, quotes, and line breaks according to the selected delimiter
- Optionally prefix formula-like cells with an apostrophe for spreadsheet safety
Important limits
- Nested objects and arrays are JSON-serialized into one cell instead of being flattened into separate columns
- Missing keys and null values both become empty cells
What the JSON to CSV does—and does not do
Exact supported inputs, outputs, limits, and primary sources for the current implementation.
Accepted input
- Pasted or locally opened JSON files up to 5 MB
- A JSON array of objects; each object becomes one output row
- Primitive, null, array, and object values inside a row field
Produced output
- CSV, TSV, semicolon-delimited, or pipe-delimited text
- A union of object keys as headers, with missing and null values exported as empty cells
- Copyable and locally downloadable output
Operational limits
- Local JSON files are limited to 5 MB; pasted data is processed in browser memory
- The input must be an array of objects; an empty array produces an empty export
- The export uses one row per top-level object and does not flatten nested columns
Known limitations
- Nested objects and arrays are JSON-serialized into one cell instead of being flattened into separate columns
- Missing keys and null values both become empty cells
- Spreadsheet formula protection is optional because it intentionally changes exported cell values
- Formula-like values are identified in the visible export plan but are only changed when formula protection is enabled
Standards and primary sources
Continue the workflow
Capability claims last reviewed September 9, 2026. Review dates describe the implementation audit, not content freshness by itself.
Use the JSON to CSV with the right expectations
Open a local JSON file or paste an array of objects. Before conversion, the workbench shows the union of exported headers and flags formula-like cells. It keeps missing and null values visibly equivalent as empty cells, JSON-serializes nested values into one cell, and makes formula protection an explicit opt-in because it changes the exported text.
When it is the right tool
- Turning API fixtures into spreadsheet-ready rows
- Exporting JSON arrays as CSV or TSV
- Reviewing nested values before a flat export
- Preparing a spreadsheet download that should not evaluate formula-like cells
A deliberate choice
Tooleras keeps this page specific to the job above instead of claiming support for adjacent formats, platforms, or edge cases it cannot verify. Open the capability guide for the exact inputs, outputs, limits, and sources.
Checked examples
Need a different tool?
Browse the full catalogue — all free, with data handling documented per tool.