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).

공식

CSV = headers + (each row joined by delimiter)

J: JSON Input (text) — JSON document

단계별 가이드

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

풀어진 예시

입력

[{"a":1,"b":2},{"a":3,"b":4}]

결과

a,b 1,2 3,4

피해야 할 일반적인 실수

✕Trailing commas in JSON (invalid)
✕Inconsistent keys across objects

자주 묻는 질문

What about nested arrays?

Nested arrays are joined with semicolons within a single cell. For complex nesting, normalize the JSON first.

계산할 준비가 되셨나요? 무료 JSON to CSV Converter 계산기를 사용해 보세요

직접 시도해 보세요 →