Share via

Copying and pasting Web tables into Excel?

Anonymous
2010-05-31T03:55:09+00:00

Hi, gang.  I'm trying to copy a spreadsheet from a web (the Forbes Global 2000 (http://www.forbes.com/lists/2010/18/global-2000-10\_The-Global-2000\_Rank.html)) into Excel so that I can access the data without having to do laborious searches on the Forbes website.  Does anyone know if there's a simple way of doing this, maybe with an Import-from-Webpage function in Excel, or something similar?

For the record, I've tried screen captures and the regular copy-and-paste, but those features won't auto format to an Excel spreadsheet, and I'm loathe to input all that data myself.

Of course, I intend to contact Forbes to see if they have any data they can give out, but I'm not holding my breath....

Thanks,

Greg

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-05-31T04:25:46+00:00

    Hmm.  When I do it the way you describe, it dumps all the data into a single cell, A1.  Could it be that I don't have Excel configured properly, or the same way you have yours configured?

    Wait, wait, wait!  Breaking news update: When I hit Paste Special instead of just Ctrl+V, then chose Text, everything went smoothly.

    Okay, problem solved.  Funky, but fixed.

    Thanks, Shane!

    -Greg

    P.S. For what it's worth, I'm using Firefox and had to hold down the Ctrl button while copying.

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2010-06-01T17:28:13+00:00

    I copy the web content, select the top left cell of the range I want to populate, and use Alt-E-S-U, which is Paste Special - Unicode Text. It usually does what I expect.

    -Jon

    Jon Peltier, Microsoft Excel MVP

    Peltier Technical Services, Inc.

    http://peltiertech.com/WordPress/

    10 people found this answer helpful.
    0 comments
  3. Anonymous
    2010-05-31T07:04:59+00:00

    1st 25

    Rank Company Country Industry Sales ($bil) Profits ($bil) Assets ($bil) Market Value ($bil)
    1 JPMorgan Chase United States Banking 115.63 11.65 2,031.99 166.19
    2 General Electric United States Conglomerates 156.78 11.03 781.82 169.65
    3 Bank of America United States Banking 150.45 6.28 2,223.30 167.63
    4 ExxonMobil United States Oil & Gas Operations 275.56 19.28 233.32 308.77
    5 ICBC China Banking 71.86 16.27 1,428.46 242.23
    6 Banco Santander Spain Banking 109.57 12.34 1,438.68 107.12
    7 Wells Fargo United States Banking 98.64 12.28 1,243.65 141.69
    8 HSBC Holdings United Kingdom Banking 103.74 5.83 2,355.83 178.27
    8 Royal Dutch Shell Netherlands Oil & Gas Operations 278.19 12.52 287.64 168.63
    10 BP United Kingdom Oil & Gas Operations 239.27 16.58 235.45 167.13
    11 BNP Paribas France Banking 101.06 8.37 2,952.22 86.67
    12 PetroChina China Oil & Gas Operations 157.22 16.8 174.95 333.84
    13 AT&T United States Telecommunications Services 123.02 12.54 268.75 147.55
    14 Wal-Mart Stores United States Retailing 408.21 14.34 170.71 205.37
    15 Berkshire Hathaway United States Diversified Financials 112.49 8.06 297.12 190.86
    16 Gazprom Russia Oil & Gas Operations 115.25 24.33 234.77 132.58
    17 China Construction Bank China Banking 59.16 13.59 1,106.20 184.32
    18 Petrobras-Petróleo Brasil Brazil Oil & Gas Operations 104.81 16.63 198.26 190.34
    19 Total France Oil & Gas Operations 160.68 12.1 183.29 131.8
    20 Chevron United States Oil & Gas Operations 159.29 10.48 164.62 146.23
    21 Barclays United Kingdom Banking 65.91 15.17 2,223.04 56.15
    22 Bank of China China Banking 52.2 9.45 1,016.31 147
    23 Allianz Germany Insurance 130.06 6.16 834.04 52.74
    24 GDF Suez France Utilities 114.65 6.42 245.95 83.36
    25 E.ON Germany Utilities 117.38 12.05 214.58 68.26
    25 Goldman Sachs Group United States Diversified Financials 51.67 13.39 849 84.95

    If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

    5 people found this answer helpful.
    0 comments
  4. Anonymous
    2010-05-31T04:08:35+00:00

    I went to the sight and carefully highlighted from the top left corner of the table, left of RANK to the bottom right corner of the data in the table 63.56, I then press Ctrl+C, moved to cell A1 in and Excel spreadsheet and Ctrl+V.

    Everything came in perfectly, I was able to copy it to here, (this post) but it was too long to Submit so you will need to do it from the web site.

    If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

    3 people found this answer helpful.
    0 comments
  5. Anonymous
    2013-04-23T02:31:05+00:00

    When I tried to do this as you described....One row ended up as two rows

    2 people found this answer helpful.
    0 comments