Split Excel Workbook
Export every worksheet as an individual XLSX file in a ZIP archive
Split Excel Workbook — what it does
Export every worksheet of a workbook as its own XLSX file, delivered together in a ZIP. A multi-tab workbook is convenient for the person who built it and awkward for everyone who only needs one tab; splitting hands each recipient a file that contains exactly their part.
When this tool helps
- Distributing per-department or per-client sheets from one master workbook.
- Breaking a large multi-tab file into pieces that open and calculate faster.
- Archiving each worksheet as an independent document.
How to use it
- Choose the Excel file.
- Split the workbook.
- Download the ZIP.
- Check that each output file contains the expected sheet.
Accuracy, limits, and good practice
- Formulas that reference other sheets break once those sheets are in separate files — convert formulas to values first if the workbook calculates across tabs.
- Output files take their names from the sheet names, so rename tabs beforehand if the filenames need to be meaningful.
- Splitting is also a privacy step: sending one sheet as its own file removes any chance of a recipient reading the other tabs.
Frequently asked questions
What are the split files named?
After their worksheet names, so tidy the tab names first with the sheet renamer if you want specific filenames.
Can I split only some sheets?
This exports every sheet. To pick a subset, use the extract worksheets tool instead.
Do cross-sheet formulas survive?
No, their targets no longer exist in the same file. Flatten formulas to values before splitting a calculating workbook.
Related tools on this site
- CSV Delimiter Converter — Convert comma, semicolon, tab, or pipe-delimited data
- CSV Transposer — Swap CSV rows and columns and download the result
- Excel to HTML Table — Convert a selected Excel worksheet into a responsive HTML table and downloadable webpage
Everything above runs inside this page. Split Excel Workbook needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
拆分 Excel 活頁簿能做什麼
把活頁簿的每個工作表各匯出成一個 XLSX，並一併打包成 ZIP。多分頁活頁簿對建立者很方便，對只需要其中一頁的人卻很麻煩；拆分後，每個收件人拿到的檔案剛好只含他那一份。
什麼時候用得上
- 把主活頁簿依部門或客戶分頁分別發送。
- 把龐大的多分頁檔案拆成開啟與計算都更快的小檔。
- 把每個工作表當成獨立文件封存。
使用步驟
- 選擇 Excel 檔案。
- 執行拆分。
- 下載 ZIP。
- 確認每個輸出檔含有預期的工作表。
精確度、限制與實務建議
- 跨表參照的公式在分成不同檔案後會失效——若活頁簿跨分頁計算，請先把公式轉成數值。
- 輸出檔名取自工作表名稱，若檔名需要有意義，請先改好分頁名稱。
- 拆分同時也是隱私處理：把單一工作表當成獨立檔案寄出，收件人就完全沒機會看到其他分頁。
常見問題
拆出的檔案怎麼命名？
以工作表名稱命名，若對檔名有要求，請先用工作表改名工具整理。
可以只拆部分工作表嗎？
本工具會匯出全部工作表。要挑選部分請改用提取工作表工具。
跨表公式能保留嗎？
不能，參照對象已不在同一檔案中。有計算的活頁簿請先把公式轉成數值再拆。
本站相關工具
- CSV 分隔符轉換 — 轉換逗號、分號、Tab 或直線分隔資料
- CSV 行列互換 — 交換 CSV 的資料列與欄位並下載結果
- Excel 轉 HTML 表格 — 將指定 Excel 工作表轉為響應式 HTML 表格與可下載網頁
以上步驟全部在這個頁面內完成，拆分 Excel 活頁簿 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。