learn.howToCalculate
learn.whatIsHeading
The JSON to CSV Converter takes a JSON array of objects (or a single object) and produces a delimited CSV file with auto-detected headers from object keys. Useful for data analysts pulling JSON from APIs into Excel, Google Sheets, or pandas. Handles nested objects (flattened with dot notation), arrays (joined with semicolon), null/undefined (empty cell), and configurable delimiters (comma, semicolon, tab).
Công thức
CSV = headers + (each row joined by delimiter)
- J
- JSON Input (text) — JSON document
Hướng dẫn từng bước
- 1Paste JSON array or object
- 2Choose delimiter (comma, semicolon, tab)
- 3Calculator validates JSON and outputs CSV with detected columns
- 4Copy result to clipboard or paste into spreadsheet
Ví dụ có lời giải
đầu vào
[{"a":1,"b":2},{"a":3,"b":4}]
Kết quả
a,b
1,2
3,4
Lỗi thường gặp cần tránh
- ✕Trailing commas in JSON (invalid)
- ✕Inconsistent keys across objects
Câu hỏi thường gặp
What about nested arrays?
Nested arrays are joined with semicolons within a single cell. For complex nesting, normalize the JSON first.
Sẵn sàng để tính toán? Dùng thử Máy tính JSON to CSV Converter miễn phí
Hãy tự mình thử →