코드, 데이터 및 QR 도구

JSON to CSV 변환기

「JSON to CSV 변환기」는 코드, 데이터 및 QR 작업을 위한 브라우저 도구입니다. 입력과 결과는 일반적으로 이 기기에서 처리되며 가입이 필요하지 않습니다.

브라우저에서 로컬 처리가입 불필요개인정보 안내 ↗

Enter one object or a non-empty array of up to 10,000 objects. Maximum 100,000 characters.

Prefixes an apostrophe to string cells and headers whose first non-whitespace character is =, +, -, or @.

사용 방법

사용 방법

  1. Paste one JSON object or an array containing up to 10,000 objects.
  2. Choose whether to protect text that spreadsheet apps could interpret as formulas.
  3. Convert, review the CSV, then copy it or download a UTF-8 CSV file.

Defined row and column rules

The top level must be one object or a non-empty array of objects. Columns are the union of own keys in first-seen JavaScript enumeration order. Nested arrays and objects become compact JSON; missing values and null become empty CSV fields.

CSV and spreadsheet boundaries

Rows use CRLF and fields containing commas, quotes, or line breaks use doubled-quote CSV escaping. Formula protection is enabled by default and prefixes an apostrophe to risky string cells and headers. Copied CSV has no byte-order mark; the download adds a UTF-8 BOM for spreadsheet compatibility. Large JSON integers may lose precision in the browser, so keep exact identifiers as strings.

자주 묻는 질문

더 알아보기

Can I convert a single object?

Yes. It becomes one data row. An array converts each object to a row.

How are nested values handled?

Arrays and objects are stored as compact JSON inside one escaped CSV field; they are not flattened into extra columns.

Why is formula protection enabled?

Spreadsheet applications can execute text beginning with characters such as =, +, -, or @ as a formula. The option prefixes risky text with an apostrophe; turn it off only when exact string preservation matters more.