asked on

copy html table to excel, missing hyperlink

Hi,

I trying to copy the contents of a webpage to an excel document.

The webpage consist of a html table with fields such as website and emailto:.

I perform the following:
- 1 highlight the webpage html table.
- Ctrl +C "Copy"
- Move to excel 2003, Ctrl + V ( Paste )
- All the data is successfully copied to the excel cells, but the hyperlinks beneath website and emailto: are not copied.

Any ideas?
thanks
Ed

ASKER CERTIFIED SOLUTION

Wayne Taylor (webtubbs)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

geeksupport

ASKER

Thanks Wayne,

It is getting me closer.

Hope you can assist further to close the loop for me.

I'm looking at

- www.mychild.gov.au

->on the bottom right -> "find a local child care service" -> "search now"

-> in the "state" drop down, select "south Australia"

-> click in "search.

I would like to tabulate the returned data into excel spreadsheet to later convert to csv for importing to a mysql database.

Somehow the method you outlined doesn't collect the data. Maybe I'm doing something wrong.

Your assistance is appreciated

SOLUTION

Wayne Taylor (webtubbs)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

geeksupport

ASKER

Thanks Wayne,

For looking into this.

What do you think is the best way I can collect the data.

Manually cut and paste?

cheers
Ed

Wayne Taylor (webtubbs)

Yeah, I think the easiest way is a manual copy/paste.

Wayne