Developer & Data tool
Turn an array of JSON objects into a table, or move CSV rows into JSON.
CSV-to-JSON cell values are strings; numeric and date types are not restored automatically.
Change the data shape
Paste an array of objects. Keys across the objects form the columns, missing values become empty cells, and nested values become JSON text in a single cell.
Provide a CSV whose first row contains headers. Quoted commas and line breaks are read, and each data row becomes an object keyed by those headers.
Inspect the output for missing or repeated column names before copying or downloading. Switching direction replaces the input with an example, so keep your original first.
A worked example
The value 95 is also a string. Apply any numeric conversion needed in the program that uses this output.