94 chars · 4 lines
53 chars · 3 lines
2 rows3 columnsNested objects flattened
94 chars · 4 lines
53 chars · 3 lines
JSON conversion guide
Paste a JSON object or an array of objects into the converter above. VetaTool discovers the available fields, flattens nested objects, escapes CSV values correctly, and produces a downloadable file without sending the source data to a server. This tool is free to use. No account or payment is required.
Last updated
Nested objects become dot-separated column names. For example, a name inside user becomes user.name, while user.address.city becomes its own column.
This keeps one CSV row for each top-level JSON object and makes deeply nested data usable in spreadsheets and import tools.
Array values are serialized as JSON inside a single CSV cell. Fields that only appear in some records are still included as columns, with empty cells where the field is missing.
Spreadsheet-safe mode protects string cells that begin with formula characters such as equals, plus, minus, or at signs. The converter adds a leading apostrophe so spreadsheet software treats the value as text instead of executing it as a formula.
Numeric values such as -5 remain numbers, and you can disable the protection when an exact raw export is required.
A nested user object becomes separate user.name and user.active columns, while the tags array remains JSON inside one CSV cell.
[
{
"id": 1,
"user": { "name": "Ada", "active": true },
"tags": ["json", "csv"]
}
]id,user.name,user.active,tags
1,Ada,true,"[""json"",""csv""]"Common questions
No. Conversion happens in your browser, so pasted JSON and imported files are not sent to a VetaTool backend.
Yes. Nested object keys are flattened with dot notation, such as user.name and user.address.city.
Array values are kept as JSON text inside one correctly escaped CSV cell, which avoids duplicating parent rows or creating unexpected combinations.
It prefixes formula-like string values with an apostrophe so Excel and similar applications treat them as text. Real numeric values are unchanged.
Looking for broader references? Browse all developer guides.