Monu Tools

JSON 轉 CSV 轉換器

將 JSON 轉為 CSV,也可將 CSV 轉回 JSON,雙向均可。選擇分隔符、處理帶引號的欄位並複製結果。一切都在瀏覽器中執行。

如何使用 JSON ⇄ CSV

  1. 01

    選擇方向:JSON 轉 CSV 或 CSV 轉 JSON。

  2. 02

    貼上你的資料並選擇分隔符(逗號、分號或 Tab)。

  3. 03

    從輸出面板複製轉換後的結果。

What it does

This converter turns a JSON array of objects into CSV and parses CSV back into JSON, in both directions. Pick the direction, paste your data, choose the delimiter, and copy the result.

It is handy for moving data between spreadsheets, APIs and config files, and the whole conversion is client-side, so your data stays private.

The JSON shape it expects

It expects JSON as an array of objects, like [{"name":"Mo","age":3}]. The CSV columns are the union of all the keys across the objects, a single object becomes one row, and any nested value is written as JSON text inside its cell.

Quoting and delimiters

It follows the standard CSV quoting rules, so a value that contains the delimiter, a quote or a line break is wrapped in quotes and escaped correctly, and the CSV parser reads those values back without losing data.

You can choose comma, semicolon or tab as the delimiter. Comma is the default and most common; semicolon suits regions where the comma is the decimal separator and spreadsheets expect it; tab produces TSV.

Type inference on the way back

When reading CSV back into JSON, it infers types sensibly: plain numbers and true/false become real JSON values, while a value with a leading zero such as 007 stays as text so identifiers and codes are not mangled.

常見問題

它期望什麼樣的 JSON 結構?

一個物件陣列,如 [{"name":"Mo","age":3}]。欄位是所有鍵的聯集。單個物件變為一行,巢狀值會以 JSON 形式寫入儲存格內。

它處理值內的逗號和引號嗎?

處理。包含分隔符、引號或換行的欄位會按 CSV 標準加引號並轉義,CSV 解析器也能正確讀回。

數字和布林值會被轉換嗎?

讀取 CSV 時,普通數字和 true/false 會變成真實的 JSON 值,而帶前導零的值(如 007)保持為文字,以免識別碼被破壞。

我的資料會被上傳嗎?

不會。轉換完全在你的瀏覽器中執行;你貼上的內容不會離開你的裝置。

來源

嵌入此工具

將此工具加入你自己的網站。複製下方的程式碼片段,它會自動保持最新。

<iframe src="https://monu.tools/embed/zh-Hant/json-csv-converter" width="100%" height="640" style="border:1px solid #e5e5e5;border-radius:12px;max-width:680px" loading="lazy" title="Monu Tools"></iframe>

相關工具