'%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 Convert an Excel Workbook to HTML in Microsoft 365
Question details
The user wants to convert an Excel workbook or specific sheet to an HTML web page format but cannot find the export option.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to save or export a spreadsheet as an HTML webpage using Excel for the Web in Microsoft 365.
- Observed behavior
- The "Save As HTML" option is missing in the File menu of Excel for the Web, preventing direct conversion to a web page format.
Verify whether you are currently using Excel for the Web in your browser or the desktop version of Microsoft Excel, as the available export formats differ significantly between the two.
Open the Workbook in Desktop Excel to Save as HTML
Switch from Excel for the Web to the desktop application to access the full range of Save As formats, including HTML.
Excel Online currently does not support exporting files directly to HTML. To bypass this limitation, you must open your workbook in the desktop version of Microsoft Excel, which includes the native 'Save as Web Page' feature.
While viewing your workbook in Excel for the Web, click the "Viewing" or "Editing" button on the top ribbon, and select "Open in Desktop App".
Once the file opens in your desktop version of Excel, click on the "File" tab in the top-left corner and select "Save As".
Click the "Save as type" dropdown menu below the file name field, and select "Web Page (*.htm;*.html)" from the list of formats.
Choose whether you want to save the entire workbook or just the active sheet, select your destination folder, and click "Save".
Use an Online File Conversion Tool
If you do not have access to the desktop version of Excel, you can use a third-party online converter to change your downloaded file into HTML format.
Convert Spreadsheets to HTML Easily with WPS Office
WPS Office provides a fully featured desktop spreadsheet application that lets you easily save your workbooks and sheets as HTML web pages natively, without requiring an expensive subscription.
- 1. Open Your Spreadsheet: Launch WPS Spreadsheets and open your .xlsx or .xls file.
- 2. Navigate to Save As: Click on the "Menu" button at the top left corner, hover over "Save As", and select "Other Formats" from the expanded menu.
- 3. Choose HTML Format: In the Save As dialog box, click the File Type dropdown menu and choose "Web Page File(*.html;*.htm)".
- 4. Export the File: Select your desired save location on your computer and click "Save" to instantly export your spreadsheet to HTML.
Frequently Asked Questions
Why is the HTML option missing in my Excel File menu?
If you are using Excel for the Web (Excel Online) within a web browser, the HTML export option is intentionally excluded. This specific export feature is exclusively available in the desktop versions of Microsoft Excel.
Can I convert a single Excel sheet to HTML instead of the whole workbook?
Yes. When using the "Save As" Web Page (*.htm, *.html) option in desktop Excel or WPS Office, you will be prompted with a choice to save the "Entire Workbook" or just the "Selection/Sheet". Simply choose the active sheet option before finalizing the save.
Will I lose formatting when converting an Excel file to HTML?
Basic formatting like colors, bold text, and cell borders generally transfer well to HTML. However, complex elements like macros, dynamic charts, and advanced pivot tables will not function as they do in the spreadsheet app. It is recommended to review the web page in a browser after conversion.
