JSON to CSV / XLSX / XML / YAML / TOON
Convert API JSON payloads to Excel, XML, YAML, or compact TOON — 100% private client-side processing.
Active Converter
JSON to CSV / Excel / XML / YAML / TOON: Flattening REST API Payloads Locally
Technical Anatomy of Hierarchical JSON Conversion
JSON (JavaScript Object Notation, RFC 8259) represents arbitrary trees of objects, arrays, strings, IEEE 754 numbers, booleans, and null. While ideal for REST and GraphQL APIs, business analysts need flat 2D grids (CSV/Excel), enterprise SOAP gateways require XML, DevOps pipelines expect YAML, and AI engineers increasingly adopt compact TOON to save context-window tokens.
Flattening an array of nested JSON objects into a spreadsheet requires scanning the union of all keys across every element (handling sparse optional fields gracefully), expanding nested maps via dot-notation (shipping.country), and serializing sub-arrays cleanly before handing the 2D matrix to SheetJS for native .xlsx generation.
Nested REST API JSON Input vs. Flattened CSV & YAML Output
// Input: Nested E-Commerce API Response (orders.json)
[
{ "id": 501, "customer": { "name": "Karim", "city": "Casablanca" }, "total": 299.0 }
]
# Converted Excel / CSV Output:
id,customer.name,customer.city,total
501,"Karim","Casablanca",299
# Converted YAML Output:
- id: 501
customer:
name: Karim
city: Casablanca
total: 299
Real-World Software & Hardware Ecosystem
Full-stack developers, QA testers, and data analysts convert .json payloads exported from Postman, Insomnia, Stripe / Shopify Webhooks, MongoDB Compass, Firebase Firestore, and Elasticsearch into Excel workbooks, Kubernetes YAML manifests, or LLM-ready TOON payloads.
Troubleshooting & Edge Cases
- Wrapped API Envelopes (
{"data": [...]}): Many REST APIs wrap the record array inside a top-level object alongside pagination metadata. If you want one row per item, paste the inner[...]array directly or inspect the flattened columns in Table view. - NDJSON / JSON Lines (
.jsonl): Streaming logs output one JSON object per line without enclosing square brackets or commas. Wrap lines in[...]with commas between objects to parse as a standard JSON array. - 64-Bit Integer Precision Loss: JavaScript
Numberrepresents integers safely up to2^53 - 1(9,007,199,254,740,991). Keep Snowflake IDs or Twitter/Discord 64-bit IDs quoted as strings in source JSON to avoid rounding the last digits.
Comparing JSON Target Formats (Excel vs. XML vs. YAML vs. TOON)
| Target | Structure Style | Primary Downstream Consumer |
|---|---|---|
| Excel (.XLSX / .CSV) | Dot-flattened 2D rows | Business analysts, Power BI, Google Sheets |
| YAML (.YAML) | 2-space indented hierarchy | Kubernetes, Helm, GitHub Actions, Ansible |
| XML (.XML) | Strict paired tag tree | Enterprise SOAP APIs, SAP, legacy Java services |
| TOON (.TOON) | Compact token-optimized rows | LLM prompts (30–60% fewer tokens than JSON) |
Command-Line jq Pre-Filtering for Deep API Responses
# Extract the inner data array from a paginated REST JSON response using jq:
jq '.data.items' raw_api_response.json > clean_array.json
Frequently Asked Questions
Nested objects such as {"user": {"name": "Omar", "city": "Fes"}} are flattened using dot-notation column headers (user.name, user.city) so every deep API attribute lands in its own clean spreadsheet cell without printing '[object Object]'.
TOON (Token-Oriented Object Notation) is a compact, indentation-and-tabular serialization format engineered to cut LLM prompt token usage by 30–60% compared to verbose repeated-key JSON arrays.
Strict RFC 8259 JSON forbids trailing commas after the last item, single-quoted strings ('key'), and JavaScript comments (// or /* */). Fix those minor syntax quirks in the left editor and the live preview updates immediately.
Yes. Switch the right-hand preview to Table view, click the × icon on any column header you want to drop, filter rows by keyword, and click Export Excel.