JSON to Excel
Turn JSON arrays into an XLSX worksheet with optional flattening
JSON to Excel — what it does
Turn a JSON array into an XLSX worksheet with a name you choose, optionally flattening nested objects into dotted column headers. Compared with the CSV route this produces a file that opens straight into Excel — no import dialog, no delimiter question, no encoding guesswork.
When this tool helps
- Handing API data to a colleague who works in Excel and does not want to see JSON.
- Building a report worksheet from a system export without an intermediate CSV step.
- Getting nested payload data into a flat table that finance or operations can filter.
How to use it
- Paste the JSON array.
- Enter a worksheet name.
- Turn on flattening if the objects are nested.
- Process and download the XLSX workbook.
Accuracy, limits, and good practice
- Flattening turns address.city into its own column, which is what makes deeply nested payloads usable in a spreadsheet at all.
- Excel may reformat values that look like dates or long numbers on open; check identifiers with leading zeros afterwards.
- Give the worksheet a meaningful name — it is the first thing a recipient sees when the file opens.
Frequently asked questions
What if objects have different fields?
The columns are the union of all keys; records without a given field leave that cell empty.
Why XLSX rather than CSV?
It opens without prompts, preserves the sheet name and avoids the delimiter and encoding issues CSV brings with it.
Can I convert back to JSON later?
Yes, the Excel to JSON tool converts a worksheet into objects or row arrays.
Related tools on this site
- CSV Missing Value Cleaner — Remove incomplete rows or fill blank cells
- Excel Column Statistics — Calculate count, unique values, sum, average, min, max, and median
- HTML Table to CSV — Extract an HTML table and download it as a CSV file
Everything above runs inside this page. JSON to Excel needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
JSON 轉 Excel能做什麼
把 JSON 陣列轉成 XLSX 工作表，名稱由你指定，並可選擇把巢狀物件攤平成點路徑欄位標題。與走 CSV 相比，這裡產出的檔案能直接在 Excel 開啟——沒有匯入對話框、沒有分隔符問題、也不必猜編碼。
什麼時候用得上
- 把 API 資料交給習慣用 Excel、不想看 JSON 的同事。
- 從系統匯出直接做出報表工作表，不必經過 CSV 中繼。
- 把巢狀載荷變成財務或營運能篩選的平面表格。
使用步驟
- 貼上 JSON 陣列。
- 輸入工作表名稱。
- 物件有巢狀時請開啟攤平。
- 執行處理並下載 XLSX 活頁簿。
精確度、限制與實務建議
- 攤平會把 address.city 變成獨立欄位，這正是深層巢狀載荷在試算表中變得可用的關鍵。
- Excel 開啟時可能重新格式化看起來像日期或長數字的值，之後請檢查帶前置零的識別碼。
- 工作表請取有意義的名稱——那是收件人開檔第一眼看到的東西。
常見問題
物件欄位不一致怎麼辦？
欄位取所有鍵的聯集，沒有該欄位的紀錄留空。
為什麼用 XLSX 而不是 CSV？
它開檔不必回答問題、保留工作表名稱，也避開 CSV 帶來的分隔符與編碼問題。
之後可以轉回 JSON 嗎？
可以，Excel 轉 JSON 工具能把工作表轉成物件或列陣列。
本站相關工具
- CSV 缺失值清理 — 刪除不完整資料列或填補空白儲存格
- Excel 欄位統計 — 計算筆數、唯一值、總和、平均、最小、最大與中位數
- HTML 表格轉 CSV — 提取 HTML 表格內容並下載為 CSV 檔案
以上步驟全部在這個頁面內完成，JSON 轉 Excel 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。