JSON to CSV

API responses and exports are rarely flat. The converter finds the list of records automatically, even when it sits inside a wrapper such as {"data": [...]} or {"results": {"items": [...]}}, and lets you pick another list if there are several. Every nested object is flattened into columns named with dot paths: contact.email, address.geo.lat and so on. Columns appear in the order they are first found, and a record that lacks a field gets an empty cell.

JSON Lines files, with one JSON object per line, are recognized as well.

• Join values in one cell: ["vip", "new"] becomes vip; new. Arrays of objects are kept as JSON text.
• One column per item: tags.0, tags.1, orders.0.sku, orders.1.sku and so on.
• One row per item: pick an array such as orders and get one row per order, with the customer fields repeated on each row. This is the layout pivot tables need.
• Keep as JSON text: every array is written as JSON in a single cell.

CSV output can use comma, semicolon, tab or pipe delimiters, and the Excel-friendly option adds a UTF-8 BOM so non-English text opens correctly in Excel. Excel output keeps numbers and true/false as real values, keeps strings like 007 as text, and adds filter buttons to the header row. Large files are processed in a background thread, so the page stays responsive. To check or tidy the JSON first, use the JSON Formatter. To convert the other way, use CSV to JSON.