Does the converter run entirely in my browser?

Yes. Both directions use pure JavaScript — JSON.parse / JSON.stringify for the JSON side, and a small custom RFC 4180-style CSV parser for the CSV side. Nothing about the input or the output touches a server. Safe for sensitive data exports.

What CSV format does the parser handle?

Comma-separated values with optional double-quoted fields and "" as the embedded-quote escape (the RFC 4180 / Excel convention). Both LF and CRLF line endings work. Tab-separated (TSV) and other delimiters are not supported in this tool — paste TSV into a spreadsheet first to re-export as CSV, or use a search-and-replace step.

What does "First row is the header" do?

When Yes (default), CSV → JSON treats row 1 as object keys: name,age produces objects like {name: ..., age: ...} . When No, it emits a JSON array of arrays (positional, no keys). Pick No if your CSV has no header or you want raw rows for downstream column processing.

How does JSON → CSV decide what columns to include?

The converter walks every object in the array and collects the union of all keys. Each object then produces one CSV row, filling its known keys and leaving missing-key cells empty. If your JSON has heterogeneous objects, the output is wide; if all objects share the same shape, the output is clean.

Can the tool handle nested JSON objects in CSV cells?

Nested objects and arrays inside the JSON are JSON-stringified into the CSV cell value (so they appear as {...} text). The CSV side stays flat — true hierarchical export would need a different format (e.g., JSON Lines or a nested CSV convention). For most reporting and API-handoff use cases, the flat output is what you want.

What's the maximum input size?

No hard limit — performance depends on your browser and device. Hundreds of kilobytes of either direction is fast; multi-megabyte inputs may take a few seconds and use noticeable memory. For multi-hundred-megabyte CSV/JSON, use a command-line tool like jq , csvkit , or miller .

Why is my JSON-to-CSV erroring with "expects an array (of objects)"?

JSON → CSV requires the top-level JSON value to be an array of objects (the format CSV → JSON produces). If your input is a single object, wrap it in [ ... ] . If it's an array of arrays or array of primitives, restructure to objects first — or convert directly via spreadsheet software which handles those shapes.

转换工具属于转换工具 →

CSV JSON 转换

CSV JSON 转换，在浏览器中快速完成单项任务。

数据留在您的设备无需上传至服务器可离线使用

为什么用这个工具

CSV JSON 转换在浏览器本地运行，适合快速处理与复制结果。

CSV JSON 转换适用于日常高频小任务，打开即用。

默认本地处理，便于快速检查与复制结果。

如何使用

01输入或粘贴所需内容。

02查看结果并复制使用。

复制前快速检查

先确认输入格式符合你的预期。

在把结果用于文档、链接、配置或消息前快速扫一眼。

只复制你真正需要的输出。

使用场景

Convert a spreadsheet export to JSON for an API

Export a Google Sheets / Excel sheet as CSV, paste it in, and copy the JSON array of objects to send as a request body or seed a development database.

Inspect a CSV log file as structured data

Application logs sometimes ship as CSV. Convert to JSON to inspect specific rows with a JSON viewer's structure, search, and filtering — much easier than reading raw rows.

Generate a CSV from API JSON for reporting

Some non-developer stakeholders prefer CSV/Excel over JSON. Take the JSON response from your API, paste it in, and hand back a CSV they can open in Excel.

Reshape data between formats during a migration

When moving data between systems (DB to DB, SaaS to SaaS), you often need to translate between row-oriented CSV exports and document-oriented JSON imports. This tool handles the round-trip quickly without writing a script.

Build a JSON seed file from a CSV mock-up

When mocking up data for a prototype or test, it's faster to type in CSV (or paste from a spreadsheet) than to write JSON by hand. Convert when you're done and use the JSON as a fixture.

使用技巧

01
Quoting and the comma trap
If your CSV has cells that contain commas (a price like "1,200" or a sentence), those cells must be wrapped in double quotes. Embedded quotes inside a quoted cell use <code>""</code> as the escape. The parser handles both — but if your source data uses single quotes or escaped backslashes instead, those won't decode correctly.
02
JSON → CSV uses union of all keys
If your JSON array has objects with different shapes, the CSV header includes every key seen anywhere. Missing keys produce empty cells in their column. This is usually what you want — but it can produce surprisingly wide CSVs if your JSON is sparse.
03
Non-string JSON values get JSON-encoded into cells
Numbers and booleans serialize naturally (e.g., <code>42</code>, <code>true</code>). Nested objects and arrays are JSON-stringified into the cell value (e.g., <code>{"x":1}</code>) so the CSV remains lossless for round-trip. Excel will display the nested JSON as a string.
04
Round-trip safety
CSV → JSON → CSV is lossless for flat object arrays with simple types. It's NOT lossless if your source has nested objects (they become JSON-encoded strings in the CSV and would re-parse as strings, not objects) or if your CSV uses non-RFC quoting conventions.

常见问题

这个工具会上传数据吗？

默认在浏览器本地处理。

CSV JSON 转换

CSV JSON 转换，在浏览器中快速完成单项任务。

数据留在您的设备无需上传至服务器可离线使用

转换方向首行作为表头

CSV 输入

行数

列数

状态

转换完成

JSON 输出

[
  {
    "name": "Alice",
    "age": "30",
    "city": "New York"
  },
  {
    "name": "Bob",
    "age": "25",
    "city": "Berlin"
  }
]

为什么用这个工具

CSV JSON 转换在浏览器本地运行，适合快速处理与复制结果。

CSV JSON 转换适用于日常高频小任务，打开即用。

默认本地处理，便于快速检查与复制结果。

如何使用

01输入或粘贴所需内容。

02查看结果并复制使用。

复制前快速检查

先确认输入格式符合你的预期。

在把结果用于文档、链接、配置或消息前快速扫一眼。

只复制你真正需要的输出。

使用场景

Convert a spreadsheet export to JSON for an API

Export a Google Sheets / Excel sheet as CSV, paste it in, and copy the JSON array of objects to send as a request body or seed a development database.

Inspect a CSV log file as structured data

Application logs sometimes ship as CSV. Convert to JSON to inspect specific rows with a JSON viewer's structure, search, and filtering — much easier than reading raw rows.

Generate a CSV from API JSON for reporting

Some non-developer stakeholders prefer CSV/Excel over JSON. Take the JSON response from your API, paste it in, and hand back a CSV they can open in Excel.

Reshape data between formats during a migration

Build a JSON seed file from a CSV mock-up

When mocking up data for a prototype or test, it's faster to type in CSV (or paste from a spreadsheet) than to write JSON by hand. Convert when you're done and use the JSON as a fixture.

使用技巧

01
Quoting and the comma trap
If your CSV has cells that contain commas (a price like "1,200" or a sentence), those cells must be wrapped in double quotes. Embedded quotes inside a quoted cell use <code>""</code> as the escape. The parser handles both — but if your source data uses single quotes or escaped backslashes instead, those won't decode correctly.
02
JSON → CSV uses union of all keys
If your JSON array has objects with different shapes, the CSV header includes every key seen anywhere. Missing keys produce empty cells in their column. This is usually what you want — but it can produce surprisingly wide CSVs if your JSON is sparse.
03
Non-string JSON values get JSON-encoded into cells
Numbers and booleans serialize naturally (e.g., <code>42</code>, <code>true</code>). Nested objects and arrays are JSON-stringified into the cell value (e.g., <code>{"x":1}</code>) so the CSV remains lossless for round-trip. Excel will display the nested JSON as a string.
04
Round-trip safety
CSV → JSON → CSV is lossless for flat object arrays with simple types. It's NOT lossless if your source has nested objects (they become JSON-encoded strings in the CSV and would re-parse as strings, not objects) or if your CSV uses non-RFC quoting conventions.

常见问题

这个工具会上传数据吗？

默认在浏览器本地处理。

CSV JSON 转换

为什么用这个工具

如何使用

复制前快速检查

使用场景

使用技巧

常见问题

相关工具

JSON 格式化

JSON 到 typescript

表格格式互转

CSV JSON 转换

为什么用这个工具

如何使用

复制前快速检查

使用场景

使用技巧

常见问题

相关工具

JSON 格式化

JSON 到 typescript

表格格式互转

CSV JSON 转换

常见问题

JSON 格式化→

JSON 到 typescript→

表格格式互转→

CSV JSON 转换

常见问题

JSON 格式化→

JSON 到 typescript→

表格格式互转→

JSON 格式化

JSON 到 typescript

表格格式互转

JSON 格式化

JSON 到 typescript

表格格式互转