Copy HTML Tables to EXCEL

[[G]rumpy [O]ld [D]uffer]

There are many HTML Database Tables, consisting of many pages of
'columnar' information, on the internet that could be better analysed
in some detail when copied to EXCEL.

The process I use at the moment is:-
1. Highlight the required data on the website, right click and copy.
2. Paste into an EXCEL worksheet, using Paste or Paste Special/HTML.
3. This copies the data into EXCEL in HTML format, and keeps the data
in a 'columnar' format, which UniCode Text & Text does not.
Unfortunately this is the veeery slow part of the process.
4. Then copy the data in this worksheet and Paste Special/Values into
another worksheet, to start building up a database.
5. Return to the worksheet containing the HTML format (step 3).
6. Highlight the worksheet and Edit/Clear/All.
7. Select the next Page of Data on the Website (as most are in many
number of pages) and Repeat steps 1. to 7.

Is there a quicker way of getting hands on this data as it is Step 2/3
that is the time consuming stage in this process, taking upto a minute
just to Paste into EXCEL in HTML format? If it were possible to copy
the HTML data from the website and Paste Special/Values straight into
EXCEL it would be much much quicker.





I'm using EXCEL 2000.

 

[Guest]

Hi, Grumpy!

Cheer up, it's Friday!

Have you tried a web query? Menu:

 

[jeff]

Hi,

Sorry for the failed answer...

Try importing using Data>Import External Data> New web
query. type in the url, and select the table/data you
want. click import. It's pretty fast and easy.

jeff

 

[R.VENKATARAMAN]

why not use data-getexternaldata-new webquery
in the newwebquery window copy or fill up the webpage.
item 2 choose the tables only and table nos. required
item 3 rich text format
click ok once .
first time the table is copied automatically in excel
later you an open toolbar for get externaldata and clcik refresh data.

try some experiments