Save a workbook as a Web page

You can save a whole workbook, including tabs to move between sheets, to a Web page. Or you can save parts of a workbook, such as a sheet, a range or a chart, to a Web page. On the Web, your Excel data can be viewed but not changed.

Note: When you save an Excel workbook as a Web page, you can open the resulting file in Excel, make changes, and save the file. However, fewer Excel features are maintained in the file, and you might be unable to change them as you could originally. For best results, we recommend that you use the original workbook (*.xlsx) as your "master" copy that you open, make changes, save as a workbook, and then save as a Web page.

  1. Open or select the workbook that contains the data that you want to publish.

    To save only part of the data on a sheet as a Web page, select the data that you want to save.

  2. On the File menu, click Save as Web Page.

  3. Use the column browser to find the folder that you want, and then double-click the folder.

  4. In the Save As box, type a name for the document.

  5. Do one of the following:

To save


Each sheet in the workbook


The selected sheet


The selected data on the sheet


  1. Click Web Options, and then click each tab to select the options that you want for the Web page.

    For example, you can type the title for the Web page, add search keywords, control when links are updated, control the format and resolution of pictures, and change the character encoding to another language.

  2. Click OK and then click Save.

    Note: To save data to a Web page on an automatic schedule, click Automate.

See also

Limitations of saving a workbook as a Web page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!