'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Download or Save a Single Worksheet in Excel for the Web
Question details
The user needs to download or export just one specific worksheet from an Excel for the Web workbook, rather than downloading the entire file.
- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Attempting to isolate and save a single sheet from a multi-sheet workbook while using the browser-based version of Excel.
- Observed behavior
- Excel for the Web only downloads the entire workbook, and the 'Move or Copy' option is completely unavailable when right-clicking the worksheet tab.
Ensure you have a desktop spreadsheet application (like Microsoft Excel or WPS Office) installed on your computer, as extracting a single sheet requires desktop features.
Use Desktop Excel to Extract and Save the Worksheet
Since Excel for the Web lacks the native feature to export a single sheet, opening the workbook in the desktop application is the most reliable method.
Excel for the Web is optimized for browser performance and does not include the 'Move or Copy' sheet function found in the desktop version. By opening the file in your desktop app, you can easily isolate the sheet and save it as a new file in XLSX or the legacy XLS format.
In Excel for the Web, look at the top ribbon and click the 'Editing' dropdown or directly click 'Open in Desktop App' to launch the file in your installed Excel program.
Once the workbook opens in the desktop application, right-click the specific worksheet tab you want to save at the bottom of the screen and select 'Move or Copy...'.
In the dialog box that appears, click the dropdown menu under 'To book:' and select '(new book)'. Make sure to check the box next to 'Create a copy' so you do not remove the sheet from the original file, then click 'OK'.
A new window will open containing only your selected worksheet. Go to 'File' > 'Save As', choose your desired location, select your preferred format (XLSX or XLS), and click 'Save'.
Manually Copy and Paste Data into a New Web Workbook
If you do not have a desktop application installed, you can manually copy the data into a brand-new web workbook.
Extract and Save Single Worksheets with WPS Spreadsheet
Overcome browser limitations effortlessly with WPS Office. Our free desktop suite provides comprehensive sheet management features, allowing you to easily extract, copy, and save individual worksheets in perfectly compatible Microsoft Office formats.
- 1. Download the File: Download your entire workbook from Excel for the Web to your local computer.
- 2. Open with WPS: Launch WPS Spreadsheet and open the downloaded workbook.
- 3. Copy the Sheet: Right-click the worksheet tab at the bottom, select 'Move or Copy Sheet', choose '(new book)', check 'Create a copy', and click 'OK'.
- 4. Save as New File: Go to 'Menu' > 'Save As' to save your new single-sheet file in your preferred format.
Frequently Asked Questions
Why is the 'Move or Copy' option missing in Excel for the Web?
Excel for the Web is a streamlined, lightweight version of the desktop software designed for browser performance. It does not include certain advanced file management features like 'Move or Copy', which is why the option doesn't appear in the right-click context menu of the worksheet tab.
Can I save a file as an XLS format using Excel for the Web?
No, Excel for the Web exclusively supports and saves files in the modern XLSX format. To save a worksheet in the older legacy XLS format, you must open the file in a desktop spreadsheet application like Microsoft Excel or WPS Office.
Will copying the sheet to a new workbook preserve my formulas?
Yes, when you use the 'Move or Copy' feature in a desktop spreadsheet application, all formulas, formatting, and internal data references within that specific sheet are preserved in the newly created file.
