Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Click here to return to the 'Correctly copy and paste tables from the web into Excel' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Correctly copy and paste tables from the web into Excel
Authored by: tsheets on Mar 04, '04 03:03:23PM

There's another way. I've always accomplished this by saving the page as .html. Open Excel and then do a "File Open", open the .html file (you may have to change it so that you can "View All Files.") The table will show up in the page, you'll probably want to delete out all the other junk, but this has always worked for me. Handy if Safari is your primary browser (although FireFox is coming on STRONG.)

[ Reply to This | # ]