Copying and pasting Web tables into Excel?

Question

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

Answer 1

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

Answer 2

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.

Answer 3

I'm having problems posting here, so I put out a file called Data.xls at http://www.mediafire.com/myfiles.php

See if you can open it and if not I will be back on tomorrow, but its midnight here and I'm off to nod.

---

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

Answer 4

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

Answer 5

2nd 25

27	EDF Group	France	Utilities	95.17	5.6	342.63	92.23
28	AXA Group	France	Insurance	145.86	5.17	1,016.70	46.02
29	Lloyds Banking Group	United Kingdom	Banking	106.67	4.57	1,650.78	50.25
29	Procter & Gamble	United States	Household & Personal Products	76.78	13.05	135.29	184.47
31	ENI	Italy	Oil & Gas Operations	121.01	6.27	163.52	82.22
32	Telefónica	Spain	Telecommunications Services	79.11	10.84	154.98	108.19
33	IBM	United States	Software & Services	95.76	13.43	109.02	167.01
34	UniCredit Group	Italy	Banking	92.17	5.59	1,438.91	43.95
35	Hewlett-Packard	United States	Technology Hardware & Equip	116.92	8.13	113.62	121.33
36	Nestlé	Switzerland	Food, Drink & Tobacco	97.08	10.07	105.16	173.67
37	Verizon Communications	United States	Telecommunications Services	107.81	3.65	227.25	82.21
38	China Mobile	Hong Kong/China	Telecommunications Services	66.22	16.87	104.46	199.73
39	ConocoPhillips	United States	Oil & Gas Operations	136.02	4.86	152.59	72.72
40	\_\_\_\_	United States	Drugs & Biotechnology	50.01	8.64	212.95	143.23
41	Nippon Telegraph & Tel	Japan	Telecommunications Services	106.98	5.53	181.48	68.68
42	ENEL	Italy	Utilities	91.87	7.74	221.26	50.92
43	Deutsche Bank	Germany	Banking	62.98	6.93	2,150.60	39.75
44	Credit Suisse Group	Switzerland	Diversified Financials	50.26	6.11	988.91	53.93
45	Sinopec-China Petroleum	China	Oil & Gas Operations	208.47	4.37	110.66	130.06
46	Vodafone	United Kingdom	Telecommunications Services	58.35	4.38	217.97	112.26
47	Johnson & Johnson	United States	Drugs & Biotechnology	61.9	12.27	94.68	174.9
48	BBVA-Banco Bilbao Vizcaya	Spain	Banking	49.27	6.03	760.39	48.2
49	Microsoft	United States	Software & Services	58.69	16.26	82.1	254.52
50	Siemens	Germany	Conglomerates	112.23	3.36	133.94	80.07

---

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