Learn
History for this tool
The most recent data you entered in this tool, stored only in this browser.
Save what you type here, in this browser? Your work would go into this browser's local storage, so a refresh or a trip to another tool does not wipe it. You also get a short list of previous entries under the form, each one restorable with a click. Nothing is ever uploaded, and there is no account.
Being straight about the trade-off: anything kept there can be read by anyone who can use this browser profile, and by any script that later runs on this site. A tool page can hold a private key, a password or a signed token. Saving is convenient; it is not private.
Saved on this device
Your inputs and history are stored locally.
Not saved
This page forgets your work when you leave it.
About this tool
Flatten an array of JSON objects into CSV, using the union of the keys as the header row. It is the usual way to get an API response into a spreadsheet.Questions
- What happens to nested objects?
- This tool does not create dotted columns. It writes a nested object or array as JSON text in one CSV cell, with quotes escaped when needed. Decide how to handle that cell in the receiving program.
- Why are some cells empty?
- Because not every object has every key. The header is the union of all keys, so an object missing one simply leaves that cell blank.