Why JSON to CSV Matters
Modern APIs return deeply nested JSON that Excel, Google Sheets, and most BI tools can't read directly. This tool flattens every level into clean rows — saving your team from writing custom scripts every time a new API integration lands.
What is "flattening"?
Nested JSON like user.address.city becomes a single column called user.address.city in the CSV. Every nested key gets its own column — no data loss.
What about arrays inside objects?
Arrays of primitives (like tags or IDs) are joined into a single cell using your chosen separator. You can pick pipe, comma, or extract just the first item.
TSV vs CSV — when to use which?
If your data contains commas (addresses, descriptions), use TSV (tab-separated). It pastes cleanly into Google Sheets and Excel without format issues.
Column picker — what's it for?
Large API responses often have 30+ fields you don't need. Pick only the columns relevant to your report before exporting — no post-processing in Excel needed.
Is my data safe?
100%. Everything runs in your browser. No data is sent to any server. You can even use this tool offline after the page loads.
Works with real API responses?
Yes. Paste the raw JSON from Postman, curl, or your browser's network tab directly. Handles data[] wrappers, paginated responses, and mixed-type fields.