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

Posted on 2011-10-27
Last Modified: 2012-05-12
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?
Question by:Scruples89
    LVL 10

    Accepted Solution

    You can use the get external data feature in excel, and then not update it. click data, get external data, from web.
    LVL 23

    Assisted Solution

    by:Alan Henderson
    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:

    Which version of Excel are you using?
    Can you post a link to the problem table?

    Author Comment

    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.

    Author Closing Comment

    does not solve my problem
    LVL 23

    Expert Comment

    by:Alan Henderson
    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.

    LVL 23

    Expert Comment

    by:Alan Henderson
    On my own bank account site, tables paste successfully into Excel if I use:
    Paste special
    Unicode text


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    This article describes how to create custom column layout styles for Bootstrap. The article uses 5 columns to illustrate the concept, but the principle can be extended to any number of columns.
    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now