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: chocky on Mar 04, '04 02:03:31PM

I tried the suggestion using Firefox and still wound up having everything pasted into a single column. But I did find a solution.
Choose "View Source" from within any browser. Select everything from the appropriate <table> tag all the matching </table> tag and past that into Excel. Bingo. Works from all the browsers I tried, even Safari.



[ Reply to This | # ]
Correctly copy and paste tables from the web into Excel
Authored by: bignumbers on Mar 05, '04 04:50:18PM

Thie method (viewing the source then copy/paste into Excel) is the method I've been using for quite a while. I'm pretty sure it's worked since Excel 2001 on OS 9. I use it all the time from any browser into Excel v.X.



[ Reply to This | # ]