How to import an Excel spreadsheet into a webpage table

From Tech-Help

Jump to: navigation, search

To import a table of data in Excel to use as a table in a webpage:

  1. Save the Excel file as a tab-delimited .txt file
    • Before quitting Excel, it may be helpful to delete any extraneous rows or columns
  2. In Dreamweaver, click to insert your cursor where you want to insert the table of data.
  3. From the Insert menu, select Table Objects, then select Insert Tabular Data
  4. From the dialog, browse to select the .txt file you just created with Excel.
    • You can make some of the adjustments to the planned look of the table in this dialog before you click ok.
  5. Once the table is created in your webpage, you can edit it normally in Dreamweaver.
Personal tools
Help