JSON to CSV 変換
「JSON to CSV 変換」はコード、データと QRに使えるブラウザツールです。入力内容と結果は通常この端末内で処理され、登録は必要ありません。
使い方
使い方
- Paste one JSON object or an array containing up to 10,000 objects.
- Choose whether to protect text that spreadsheet apps could interpret as formulas.
- 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.