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.

Newer versionsOffice 2011



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.