Paste a JSON array of objects. The columns are every key that appears in any object, in first-seen order; missing values become empty cells.
How it works
Fields containing a comma, a quote or a line break are wrapped in double quotes, with inner quotes doubled, so Excel and Google Sheets read them back correctly.
Nested objects and arrays are written as JSON text in a single cell. Flatten them first if you need separate columns.
To open the result in Excel with non-English characters intact, save it as UTF-8 and use Data → From Text/CSV rather than double-clicking the file.
Examples
[{"a":1,"b":"x, y"},{"a":2}]a,b
1,"x, y"
2,These examples are run by the tool itself in our automated tests, so the results shown are what it really returns.
Guides that use this
- How to clean a messy CSV before you analyse it — 2 min read
- Excel data analysis: formulas, PivotTables and the ToolPak — 3 min read
More tools
Legal entity
Devansh Yadav
Moradabad, Uttar Pradesh
Governing law: Courts at Moradabad, Uttar Pradesh
Phone: +91 8433475698
Legal: legal@analyzeit.in