How to copy website tables into Excel 2007

[Leoniee]

I am working for an organization where i have to work on Excel 2007. Today while browsing i came across a table on one of the website which will be very useful for me. So what i need is to copy that table in my Excel spreadsheet. But i don't even have a little idea about how to do that. Do any of you have any idea of doing that ? please let me know.

[MrChris-]

Well, fortunately we have the trick to do that. Here is how:-

• First of all, open a Excel 2007 spreadsheet and go to Data Tab in the file menu.
  
  
• Now select Get External Data just below the Office round button and than click on From Web option.By doing so, you will get opened a window where you need to enter the URL of the site from where you want to get the table.
  
  
• Now you will see yellow arrow icons next to the table data that can be imported.So what you have to do is click the areas of the data you want to import which turns the box to a green checkmark. Once done, click on Import.
  
  
• Now select the cell where the table should appear and click Ok. Thats it.. The table will begin to be retrieved from the site.

[Arzaan]

In case anyone need to import HTML table in Excel 2007 spreadsheet, he should visit this Importing HTML table in a Spreadsheet - Excel 2007

[Leoniee]

Thank you very much for the help. Thats what i really needed. This is gonna very useful in my job. i appreciate your help. Thanks