About the JSON to CSV
Columns are built from the union of keys across all objects, in the order they first appear, so records with missing fields still line up and the gaps become empty cells. If the JSON is an object that wraps the array, such as {"data": {"items": [...]}}, the converter finds the array for you.
With Flatten nested keys on, {"address": {"city": "London"}} becomes a column address.city and array items become tags.0, tags.1. Turn it off to keep nested values as a JSON string in a single cell, which is easier to convert back. null becomes an empty cell.
A field is quoted when it contains the delimiter, a double quote, a line break or leading/trailing spaces; inner quotes are doubled. Choose semicolon output if your spreadsheet uses a comma as the decimal separator. The conversion runs in your browser, so API responses with private data stay on your machine.
How to use it
- Paste a JSON array or open a .json file.
- Decide whether nested objects should be flattened into dot-named columns.
- Choose the output delimiter.
- Copy the CSV or download converted.csv and open it in Excel or Sheets.