deotpit — 2012-02-05T04:35:34-05:00 — #1
There is a 2000 lines table in an HTML site, containing information I want to have in an Excel spreadsheet.
Can it be downloaded ? is there a way to convert "Table" HTML code to Excel?
Thanks a lot
stevie_d — 2012-02-05T13:36:07-05:00 — #2
Load the webpage in your browser, highlight the table contents, copy, paste into Excel ... works for me!
deotpit — 2012-02-05T14:42:02-05:00 — #3
What this did to me, it pasted the whole table over one column. I couldnt make it dispersed over more then one column.
stevie_d — 2012-02-05T14:57:19-05:00 — #4
What browser? What version of Excel?
Another option is to open the HTML file in Word, and this should preserve the table structure. You can then copy and paste from Word into Excel more easily.
system — 2012-02-05T19:59:20-05:00 — #5
Silly question, are you sure the page in question ACTUALLY used table tags? A lot of dimwits out there are now abusing all sorts of other tags on TABULAR DATA, pretty much flushing semantics down the toilet and then having the nerve to call it more semantic. See the skins of several recent forum upgrades for examples of said stupidity in action. (vBulletin for example).
Also, what browser did you 'cut' from where it failed? All browsers are not created equal on this... the worst of the lot being drumroll..... IE. I know, no surprises there. Safari, FF and Chrome will auto-bold and center TH, while cut/paste from opera treats all elements as flat cells.
Also, only select the table, if you select 'extra' bits it can confuse Excel.
Try this small example table:
Which FF, Safari, Chrome and Opera all do a right fine job to Excel or LibreOffice -- while IE makes a right mess of it with a single column result in LibreOffice and one massive cell in Excel.
Excel can also just act... weird if you're using older versions (office 97)... or bleeding versions. (office 2010 on x64, it's fine on x32 for some reason) -- 2k3 and XP both handling it well... You may end up having to use libreoffice as a intermediary should you be on one of the versions that just completely screws up cut/paste.
Which is why increasingly I'm using LibreOffice instead of Office... even if the word processor still kerns text like a sweetly retarded rhesis monkey on crack. (It's not AS bad as it used to be when it was openOffice, at least on Windows (freetype is still USELESS for working with text) -- so glad there's a non-sun non-oracle fork now!)
deotpit — 2012-02-06T03:43:09-05:00 — #6
Thanks a lot both of you.
"Deathshadow" is right. I checked the code, didnt find css code neither <table> tags but lots of <tr><td><div><span
I added <table> tags, got rid of all the divs and spans and then i managed to transfer the table to Excel as Stevie suggested.
I thank you very much for your help and sorry for someone else's misleading code.