Save a workbook as a webpage

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

Note: When you save an Excel workbook as a webpage, 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 webpage.

  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 webpage, select the data that you want to save.

  2. On the File menu, click Save as.

  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. In the File Format list, click Web Page (.htm).

  6. Do one of the following:

    To save

    Select

    Each sheet in the workbook

    Workbook.

    The selected sheet

    Sheet.

    The selected data on the sheet

    Selection.

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

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

  8. Click OK and then click Save.

  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 webpage, 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

    Click

    Each sheet in the workbook

    Workbook.

    The selected sheet

    Sheet.

    The selected data on the sheet

    Selection.

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

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

  7. Click OK and then click Save.

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

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×