JSON轉CSV轉換工具
將由物件組成的JSON陣列轉換為CSV格式。非常適合將API資料匯出到試算表。
如何使用本工具
- 1
Paste or type a JSON array of objects into the text box. The array must be non-empty (for example: [{"name":"A","value":1}]).
- 2
Click the Convert button to generate the CSV.
- 3
Read the CSV in the output panel below the button, with the header row first followed by one row per object.
- 4
Select the output text and copy it into a spreadsheet, a .csv file, or wherever you need it.
什麼是JSON轉CSV轉換工具？
JSON是API的通用格式；CSV是試算表的通用格式。在二者之間轉換是一項常見任務：將分析資料匯出到Excel、將CSV資料匯入JavaScript應用程式等。本工具能很好地處理由扁平物件組成的陣列；深度巢狀的結構可能需要預處理。
常見使用場景
Turning a small JSON response from an API into a CSV you can paste straight into Excel or Google Sheets.
Quickly eyeballing tabular API data as rows and columns instead of nested braces.
Preparing a CSV for a bulk-import feature that expects flat columns, when your source data is already a uniform JSON array.
Converting a JSON fixture or seed file into CSV for a quick import into a database GUI.
Generating a CSV snippet for documentation or a bug report without installing jq or writing a script.
Sanity-checking that a JSON array has consistent keys across records by spotting blank or missing cells in the output.