JSON to CSV Converter は何をしますか?
JSON to CSV Converter はブラウザ上でデータやファイルを変換するツールで、結果と制限を明確に示します。 検証済みの機能: JSON to CSV, CSV to JSON, CSV to TSV, Header-row parsing.
CSV is a table, not a general object format
Choose CSV for flat rows consumed by spreadsheets or data tools. Keep JSON when records contain nested objects, arrays, typed numbers, booleans, or null values that must remain distinguishable.
使い方
- Choose JSON → CSV, CSV → JSON, or CSV → TSV.
- Paste an array of flat JSON objects or a delimited table with a header row.
- Select Convert, verify the columns and quoting, then copy or download the result.
実際の入出力例
Turn two flat records into CSV
入力
[{"name":"Ada","language":"JavaScript"},{"name":"Linus","language":"C"}]出力
name,language
Ada,JavaScript
Linus,CObject keys become the header row and each object becomes one record.
一般的なエラーと対処
| 症状 | 原因 | 対処 |
|---|---|---|
| JSON → CSV says the input must be an array of objects. | The top-level JSON value is an object, scalar, or nested structure rather than tabular records. | Wrap records in an array and flatten nested objects into scalar columns first. |
| CSV columns shift or parsing reports an error. | A value containing a comma, quote, or line break is not quoted correctly. | Wrap the field in double quotes and escape an embedded double quote as two double quotes. |
Important behavior of JSON ↔ CSV
このツール固有の制限: Nested objects need flattening before CSV conversion because a cell is scalar.
標準と実装の参考資料
- RFC 4180 — Common Format and MIME Type for CSV Files (opens in a new tab)Documents conventional CSV records, headers, quotes, and line breaks.
- Papa Parse documentation (opens in a new tab)Documents the parser and serializer used by this page.
JSON ↔ CSV — FAQ
Does the JSON ↔ CSV upload my input?
No. Processing runs in the current browser tab, and the page does not send tool input to a KitLumi processing endpoint.
What input does the JSON ↔ CSV accept?
It accepts an array of JSON objects or a CSV table with a header row. The workspace checks the input and reports malformed or unsupported values before it produces a result.
What does the JSON ↔ CSV produce?
It produces CSV, TSV, or an array of string-valued JSON records. Copy and download controls appear when the output format supports them.
What limitation should I know?
Nested objects need flattening before CSV conversion because a cell is scalar.
更新内容
実質的な更新: JSON ↔ CSV: Added JSON to CSV, CSV to JSON, CSV to TSV, Header-row parsing, responsive controls, explicit runtime disclosure, and task-specific examples and limitations.