UtilitySansar
すべてのツール
カテゴリ
DeveloperMathTextDesignEncodingSecurityMarketingDataFinanceCloud
Data

CSV to JSON Converter

Turn CSV into a JSON array with one row per object. Optional header detection, configurable delimiter, and type coercion that turns 1/true/null into real JSON values.

ツール要約

このツールは構造化された入力を受け取り、サーバーへアップロードせずにブラウザで決定的な出力を返します。

ツール名
CSV to JSON Converter
入力の目的
変換・検証・分析するソースコンテンツを入力してください。
出力の目的
コピー・再利用・デバッグに適した正規化された出力を受け取ります。
入力例
id,name,active 1,Alice,true 2,Bob,false
出力例
[ { "id": 1, "name": "Alice", "active": true }, { "id": 2, "name": "Bob", "active": false } ]

Paste CSV above and click Convert to JSON.

ツールの紹介

Turn CSV into a JSON array with one row per object. Optional header detection, configurable delimiter, and type coercion that turns 1/true/null into real JSON values.

ツール概要

The parser is RFC-4180 compliant: it handles quoted fields, escaped quotes ("" → "), mixed \n and \r\n line endings, and trailing blank lines. With header mode on, the first row becomes the JSON object keys; with it off, each row is output as an array. Type coercion converts bare integers, floats, true/false, and null into their JSON-native form — leaving ambiguous strings (like "007" or "01-02") alone.

ユースケース

  • Convert an Excel export to JSON for an API test
  • Seed a web app fixture from a CSV file
  • Pipe spreadsheet data into jq for filtering
  • Prepare CSV survey data for a charting library

入力／出力の例

入力の目的
id,name,active
1,Alice,true
2,Bob,false
出力の目的
[
  { "id": 1, "name": "Alice", "active": true },
  { "id": 2, "name": "Bob", "active": false }
]
Quoted fields handle commas and escaped quotes per RFC 4180.
入力の目的
product,price,notes
"Widget, Blue",19.99,"On ""sale"""
Gadget,42,ships 2 weeks
出力の目的
[
  { "product": "Widget, Blue", "price": 19.99, "notes": "On \"sale\"" },
  { "product": "Gadget", "price": 42, "notes": "ships 2 weeks" }
]
TSV input with the header row disabled outputs an array of arrays. Numeric cells are coerced to numbers.
入力の目的
1	Alice
2	Bob
3	Carol
出力の目的
[
  [1, "Alice"],
  [2, "Bob"],
  [3, "Carol"]
]

よくある質問

Is this CSV to JSON converter free?+
Yes. Convert as much as you need — unlimited rows, no sign-up, no upload to any server.
Does it support tab-separated or semicolon-separated files?+
Yes. Change the delimiter option to Tab, Semicolon, or Pipe before converting. Excel exports from European locales typically use semicolons.
What is type coercion?+
When enabled, 1 becomes the number 1, "true" becomes the boolean true, and "null" becomes null. Turn it off to keep every cell as a string — useful when you want to preserve leading zeros like "007".
Can it handle quoted fields with commas inside?+
Yes. The parser follows RFC 4180: "a, b" is a single cell containing "a, b", and "" inside a quoted cell is treated as a literal double quote.
Is the first row always treated as the header?+
Only when the "First row is header" option is on (default). Turn it off and you get an array of arrays instead of an array of objects.

Share this tool

他のツールを見る

下記の Data カテゴリで関連ユーティリティを探す。

Data をすべて見る

関連ツール

役に立ちそうな厳選ユーティリティ