Convert Excel Worksheets into Separate Workbooks in Excel for the Web
Question details
The user wants to convert individual Excel worksheets into separate workbook files.

- Product
- Excel for the web and Microsoft Teams
- Device & OS
- not provided
- Scenario
- A workbook is open in Excel for the web or Teams, and its worksheets need to be saved as individual workbooks.
- Observed behavior
- The web or Teams interface may not provide the desktop option to move or copy a worksheet directly into a new workbook.
Identify the worksheets you need to separate and check whether their formulas refer to other sheets. If you plan to use desktop Excel, confirm that it is installed and that you can open or download the workbook.
Copy each worksheet into a new workbook in desktop Excel
Use desktop Excel to preserve the original worksheets while creating separate files.
In Excel for the web or Teams, choose Open in Desktop App if available. Otherwise, download the workbook and open it in desktop Excel.
Right-click the worksheet tab, select Move or Copy, and choose (new book) under To book. Select Create a copy, then click OK.
In the new workbook, choose File > Save As and save it with a descriptive file name.
Return to the original workbook and repeat Move or Copy and Save As for each worksheet that needs its own file.

Create separate workbook copies in Excel for the web
Use this workaround when desktop Excel is unavailable and the web version cannot copy a sheet into a new workbook.
Create separate worksheet files with WPS Spreadsheets
Open the Excel workbook in WPS Spreadsheets, copy the worksheet content into a new workbook, and save each result as an Excel file.
- 1. Open the source workbook: In WPS Spreadsheets, choose Open and select the Excel workbook.
- 2. Copy the worksheet content: Select the worksheet tab, click the Select All corner above row 1 and left of column A, and copy the selected cells.
- 3. Paste into a new workbook: Choose File > New to create a workbook, select cell A1, and paste the copied content.
- 4. Save and repeat: Choose File > Save As and save the new workbook as an XLSX file. Repeat for each worksheet, then check formatting and formulas; copying cells may not preserve every worksheet object or setting.

Frequently Asked Questions
Can Excel for the web move a worksheet into a new workbook?
The option may not be available in Excel for the web or Teams. Open the file in desktop Excel and use the worksheet tab's Move or Copy command, or create separate workbook copies in the web version.
How do I keep the original worksheet when using Move or Copy?
In desktop Excel, right-click the worksheet tab, choose Move or Copy, select (new book), and check Create a copy before clicking OK.
What happens to formulas that refer to other worksheets?
They may become external links when a sheet is copied to a new workbook, or break if referenced sheets are deleted. Open each resulting workbook and check those formulas.
Can I split multiple worksheets at once?
To create a separate file for each sheet, repeat Move or Copy and Save As for each worksheet in desktop Excel. For many sheets, a VBA macro in desktop Excel can automate the process.




