What JSON to CSV Converter helps you do
Convert JSON arrays of objects into RFC 4180-style CSV or TSV locally, with optional flattening of nested objects and spreadsheet formula protection. Built for handoffs to Excel or Google Sheets — not for streaming megabyte-scale ETL.
Parsing, conversion, copying, and downloads happen locally in your browser.
How it works
Haivix parses JSON in the browser, normalizes arrays of objects (including nested keys as dot-separated columns when flattening is enabled), escapes quotes and commas per CSV rules, and can prefix formula-like cell values with an apostrophe.
How to use JSON to CSV Converter
- Paste a JSON array, a single object, or an object containing one array into the input.
- Choose CSV or TSV, then decide whether to flatten nested properties and protect formula-like spreadsheet cells.
- Convert the data, review row and column counts, then copy the result or download a UTF-8 file.
When to use it
- Moving API response data into a spreadsheet for ad hoc analysis
- Flattening nested records for reporting without uploading data
- Reducing formula-injection risk when opening exported text in Excel
When not to use it
- Very large datasets that exceed browser memory
- Preserving nested arrays without flattening or custom schema mapping
- Production pipelines requiring schema validation and incremental loads
Example
An array of {"user":{"name":"Ada"},"score":10} with flattening enabled becomes columns user.name and score with one data row.
What to know before you start
- Parsing uses JSON.parse — duplicate keys follow JavaScript last-key-wins behavior.
- Extremely wide flattened objects can produce unwieldy spreadsheets.
- All processing stays local but is still bound by browser memory.
Common mistakes
- Flattening objects with conflicting leaf names without checking column collisions
- Disabling formula protection then opening CSV in Excel with cells starting with =
- Assuming column order matches API field order when keys differ between objects
Conversion guide
JSON to CSV without breaking spreadsheets
Flattening rules, RFC 4180 escaping, and formula protection in Haivix.
Frequently Asked Questions
Use an array of objects, a single object, or an object containing an array. Nested objects can be flattened into dot-separated column names.
Fields containing special characters are wrapped in double quotes, and embedded double quotes are escaped by doubling them.
Cells beginning with =, +, -, or @ can be interpreted as formulas by spreadsheet apps. The enabled protection prefixes those values with an apostrophe.
No. Parsing, conversion, copying, and downloads happen locally in your browser.