How to do it
- Paste or open the JSON. It needs to be an array at the top level — a single object becomes a one-row table.
- Check the header row. Keys appear in the order they were first seen, and every object contributes.
- Export as TSV, or keep editing first: reordering and deleting columns here is faster than doing it after the fact.
What usually goes wrong
Nested objects and arrays
A table cell holds text. Nested values are serialised back to JSON inside the cell rather than being flattened into invented column names.
Missing keys
An object without a key gets an empty cell, not a shifted row. This is the single most common way a hand-rolled conversion corrupts a file.
Newline characters inside a string value are preserved and quoted on export, so a multi-line description survives the trip.