How can I copy a table of figures from a web page and paste it into excel and preserve the placement of rows columns and individual cells

How can I copy a table of figures from a web page and paste it into excel and preserve the placement of rows columns and individual cells. It used to be that I could just simply copy and paste and I would be copying the table in html to a table in excel. Nowadays with formating such as CSS what seems to be a table in Html is not. So I end up with the data dispersed over several rows and the columns not matching up when I paste. Any ideas?
Scruples89Asked:
Who is Participating?
 
etech0Connect With a Mentor Commented:
You can use the get external data feature in excel, and then not update it. click data, get external data, from web.
0
 
Alan HendersonConnect With a Mentor Retired marine engineerCommented:
It should still work if you use the correct paste option in Excel.
i.e. Keep source formatting or Match destination formatting.

With Office 2010 it works with the table on this page for instance:
http://www.mistywindow.com/ascii-characters/

Which version of Excel are you using?
Can you post a link to the problem table?
0
 
Scruples89Author Commented:
Thanks. But neither solution really fixes the problem. I am trying to copy and paste a bank statement (can't provide a link here). Even when I use the paste special options in excel it still mixes columns and rows. try it on one of your online accounts, if you don't mind.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
Scruples89Author Commented:
does not solve my problem
0
 
Alan HendersonRetired marine engineerCommented:
CSS with regard to tables has had a bit of a bad rap. It's only HTML page structure which should not be based on HTML tables. When you're talking about HTML data tables within an appropriate DIV, properly scripted CSS should not affect the structure of your table, only the presentation.

I suggest that you reopen this question and ask for more help. The moderator will call in the top
experts in these areas.

:)
0
 
Alan HendersonRetired marine engineerCommented:
On my own bank account site, tables paste successfully into Excel if I use:
Paste special
Unicode text

:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.