Office Compatibility Issues

Convert Excel Worksheets into Separate Workbooks in Excel for the Web

Algirdas JasaitisAlgirdas Jasaitis Nov 18, 2026 868 views

Question details

The user wants to convert individual Excel worksheets into separate workbook files.

Convert Excel Worksheets into Separate Workbooks in Excel for the Web
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.
Before you start

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.

Solution 1Recommended

Copy each worksheet into a new workbook in desktop Excel

Use desktop Excel to preserve the original worksheets while creating separate files.

1
Open the workbook in Excel

In Excel for the web or Teams, choose Open in Desktop App if available. Otherwise, download the workbook and open it in desktop Excel.

2
Copy a worksheet

Right-click the worksheet tab, select Move or Copy, and choose (new book) under To book. Select Create a copy, then click OK.

3
Save the new workbook

In the new workbook, choose File > Save As and save it with a descriptive file name.

4
Repeat for other sheets

Return to the original workbook and repeat Move or Copy and Save As for each worksheet that needs its own file.

Copy each worksheet into a new workbook in desktop Excel
Check cross-sheet references: Formulas that refer to other sheets may become external links or need adjustment in the new workbook.
Split worksheets with WPS

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. 1. Open the source workbook: In WPS Spreadsheets, choose Open and select the Excel workbook.
  2. 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. 3. Paste into a new workbook: Choose File > New to create a workbook, select cell A1, and paste the copied content.
  4. 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.
Create a separate workbook for each worksheetOpen and save Microsoft Excel XLSX filesWork with a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

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.