How to convert an api response json to csv for excel
- Step 1Save the API response to a file — From your API client (Postman, curl, browser DevTools), save the JSON response body to a .json file.
- Step 2Drop the file onto the converter — Auto-detect handles JSON arrays, JSON Lines, and single-object responses.
- Step 3Pick how to handle nested arrays — JSON literal preserves structure; pipe or comma join works better when Excel users will read the file directly.
- Step 4Open in Excel or Google Sheets — Double-click the .csv to open in Excel, or File →’ Import in Google Sheets.
Frequently asked questions
What if the response wraps the array under a key like data?+
Auto-detect unwraps a top-level object whose values are arrays. Otherwise, edit the JSON to expose the array, or use jq '.data' to extract it.
Why do I get one row per response when I expected many?+
If the JSON is a single object — not an array — you get one row. Arrays of objects produce one row each.
Will Excel mangle long IDs?+
Excel converts long numeric strings to scientific notation. Pre-quote them or open via Data →’ From Text/CSV and set the column type to Text.
Privacy first
Conversion runs locally in your browser. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.