The Nested JSON Problem
Real-world JSON from APIs is rarely flat. You get nested objects like {"user": {"address": {"city": "Seattle"}}}. Spreadsheets need flat rows and columns. Our tool automatically flattens nested structures using dot notation.
How Flattening Works
Nested keys are joined with dots: user.address.city becomes a CSV column header. Arrays are converted to comma-separated strings within cells. This preserves all data while making it spreadsheet-compatible.
Example: API Response to CSV
Take a typical API response — nested user profiles, addresses, order histories — and you get a flat CSV where every column is one specific data point. Nothing lost, just reorganized.
Frequently Asked Questions
How deep can nesting go?
There's no depth limit. Objects nested 10+ levels deep will all be flattened correctly.
What happens to arrays inside objects?
Array elements are joined with commas within a single cell. For example, ["tag1","tag2"] becomes "tag1,tag2" in the CSV.