How to Transfer JavaScript HTML Table Data to Excel

Written by james highland
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Transfer JavaScript HTML Table Data to Excel
Web page tables arrange data much like an Excel spreadsheet does. (www and Internet image by mbs from Fotolia.com)

Microsoft Excel is a spreadsheet application that stores data of nearly any kind in a columnar grid. You can add data to a spreadsheet manually, by typing or pasting it into the cells, or you can import data from other sources. JavaScript and HTML are languages that create and format Web pages. They often structure "tables" on websites, which are also columnar grids that can contain nearly any type of data. You can transfer the data from one of these Web page tables into an Excel spreadsheet using a tool built into the Excel program.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Open the Microsoft Excel spreadsheet that will contain the transferred data from the Web page table.

  2. 2

    Click the "Data" tab on the Excel ribbon toolbar.

  3. 3

    Click on the "Get External Data" group on the Data tab.

  4. 4

    Click the "From Web" option. A pop-up box will appear titled "New Web Query."

  5. 5

    Type the URL for the Web page that contains the table data you wish to transfer into Excel. You can also copy the URL from any Web browser and paste it into this field, if desired. Then click the "Go" button. The window will surf to the Web page just as if you were in a Web browser program.

  6. 6

    View the small yellow squares that appear all over the Web page in the Web Query window. They include a small black arrow inside the square. These identify sections of the Web page that correspond to JavaScript or HTML tables structured in a columnar grid. You can transfer data only if it displays this yellow icon in its upper left corner.

  7. 7

    Click on the yellow square icon next to any table you wish to transfer into Excel. If you wish to transfer the entire Web page, click the yellow square at the top left of the page, if it exists.

  8. 8

    Click the "OK" button. Excel automatically transfers the selected table and all its contents into the spreadsheet.

Tips and warnings

  • You may optionally configure different criteria that manage how Excel handles certain types of Web data. Before pressing "OK" on the Web Query window, press the "Options" button. Here you can specify how Excel works with the different Web page fonts, formats and styles or whether the program should ignore them complete and just import the raw data and text. You can also control how it handles specific HTML language elements, such as "" tags. If your transfer is not what you expected, repeat it after adjusting these settings. It may take a few tries to get the import exactly as you expect.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.