Exporting a table from Excel as an HTML web page

Exporting from Excel

Open a spreadsheet in Excel, e.g. 'Microsoft Office uses' table done the first week

Delete any unwanted columns or rows:

• Click on the unwanted row / column
• Edit > Delete
• Resize any rows / columns to make the page look tidy

Select the part of the spreadsheet you would like to be exported

Export the table as HTML:

• File > Save as...
• When the Save as... dialog appears change the 'Save as type' to Web Page (*.htm, *.html)

The dialog will change...

• You can choose to export the entire workbook, or just the highlighted selection
• You can choose to rename the title of the page, e.g. Uses for Microsoft office
• Create a relevant filename for the web page, e.g. office_uses.html

You can then choose to Save (and the document will take its name) or Publish. Publish will leave the original document as an Excel file.

Tidying up the code

Open the web page in Dreamweaver

From the top menu bar select Commands > Clean up Word HTML

It will complain a little, but force it to convert the document anyway from the version of Office that you have. Excel exports in a very similar manner to Word, and, with a little persuasion, Dreamweaver can halve the length of the code, speeding up download times.

Re-save your document.

Back

Back to IT Principles Home