'%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 Save an Excel Workbook or Spreadsheet as HTML
Question details
The user wants to export or save an entire Excel workbook or a specific worksheet as a static HTML web page for online publishing.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Publishing spreadsheet data online as a static web page without using live workbook functionality.
- Observed behavior
- The user needs the correct steps to convert and save their live spreadsheet data into a static HTML file format.
Ensure your spreadsheet data is fully formatted as you want it to appear online, and double-check that no sensitive or private information is visible before saving it as a web page.
Save Entire Workbook or Selection as a Static Web Page
Use Excel's built-in 'Save As' feature to export your spreadsheet or entire workbook as an HTML file.
Excel allows you to export your data directly into an HTML format. You can choose to export the entire workbook, a single worksheet, or a specific selection of cells. This method produces a static web page, meaning the formulas and live features will no longer be interactive.
Open your Excel workbook, click on the 'File' tab in the top-left corner, and select 'Save As'.
Click 'Browse' and navigate to the folder where you want to save the HTML file.
In the 'Save as type' drop-down list, scroll down and select 'Web Page (*.htm; *.html)'.
Below the file type drop-down, choose either 'Entire Workbook' to save all sheets, or 'Selection: Sheet' to save only the active worksheet or highlighted cells.
Click the 'Publish' button if you want to customize further options, or simply click 'Save' to immediately generate the HTML file.
Save Spreadsheets as HTML Quickly with WPS Office
WPS Spreadsheet offers a highly compatible and user-friendly way to manage your data and export it directly to HTML. Enjoy a lightweight, free alternative to Microsoft Office that easily handles your web publishing needs.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet document you wish to convert.
- 2. Access the Save As options: Click the 'Menu' button in the top left corner, hover over 'Save As', and select 'Other Formats'.
- 3. Choose Web Page format: In the save dialog, click the 'File Type' drop-down menu and select 'Web Page (*.htm; *.html)'.
- 4. Save the file: Select your desired save location and click the 'Save' button to export your spreadsheet as a static HTML page.
Frequently Asked Questions
Will my formulas still work in the HTML file?
No, saving an Excel file as a static HTML web page removes live functionality like formulas and macros. It will only display the final calculated values as text.
Can I save just one specific chart or table as HTML?
Yes. Highlight the specific chart or range of cells before going to 'Save As'. When selecting the Web Page format, choose the 'Selection' radio button instead of 'Entire Workbook'.
Why does my HTML file look slightly different from the Excel sheet?
Complex formatting, frozen panes, and certain graphical elements may not translate perfectly into standard HTML. It is highly recommended to keep your spreadsheet formatting simple when exporting for the web.
Can I automatically update the HTML page when the spreadsheet changes?
Standard static HTML saves will not update automatically. However, you can use Excel's 'AutoRepublish' feature found within the 'Publish' dialog box to automatically update the web page every time you save the workbook.
