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

3rd 25

51	Banco Bradesco	Brazil	Banking	59.1	4.6	281.4	54.5
52	Banco do Brasil	Brazil	Banking	56.1	5.82	406.46	42.78
53	Royal Bank of Canada	Canada	Banking	35.41	3.58	608.05	78.17
54	Intesa Sanpaolo	Italy	Banking	50.71	3.56	877.66	44.67
55	Samsung Electronics	South Korea	Semiconductors	97.28	4.43	83.3	94.48
56	France Telecom	France	Telecommunications Services	65.92	4.3	132.06	62.39
57	Sanofi-aventis	France	Drugs & Biotechnology	41.99	7.54	114.85	98.07
58	Ford Motor	United States	Consumer Durables	118.31	2.72	194.85	41.8
59	Commonwealth Bank	Australia	Banking	31.84	3.81	500.2	75.1
60	RWE Group	Germany	Utilities	66.57	4.98	130.36	47.93
61	Novartis	Switzerland	Drugs & Biotechnology	44.27	8.4	90.89	126.22
62	BHP Billiton	Australia/United Kingdom	Materials	50.21	5.88	74.86	192.45
63	Zurich Financial Services	Switzerland	Insurance	70.27	3.22	366.66	34.71
64	Statoil	Norway	Oil & Gas Operations	79.76	3.16	97.09	72.26
65	Generali Group	Italy	Insurance	123.14	1.83	607.37	35.19
66	Roche Holding	Switzerland	Drugs & Biotechnology	47.35	7.51	69.64	146.19
67	Westpac Banking Group	Australia	Banking	31.19	3.04	519.03	70.99
68	Rio Tinto	United Kingdom/Australia	Materials	41.83	4.87	95.01	118.34
69	Lukoil	Russia	Oil & Gas Operations	86.34	9.14	70.94	45.18
70	Anheuser-Busch InBev	Belgium	Food, Drink & Tobacco	36.76	4.61	111.58	81.48
71	GlaxoSmithKline	United Kingdom	Drugs & Biotechnology	45.83	8.94	65.38	95.36
72	Merck & Co	United States	Drugs & Biotechnology	27.43	12.9	112.09	116.11
73	Crédit Agricole	France	Banking	91.96	1.61	2,227.22	34.42
74	Munich Re	Germany	Insurance	59.31	3.67	284.21	30.12
75	Apple	United States	Technology Hardware & Equip	46.71	9.36	53.93	189.51
75	Cisco Systems	United States	Technology Hardware & Equip	35.53	6.07	76.4	140.85

---

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

Last 25

77	Rosneft	Russia	Oil & Gas Operations	34.7	6.51	83.11	83.19
78	Mitsubishi Corp	Japan	Trading Companies	63.12	3.8	109.74	42.64
79	National Australia Bank	Australia	Banking	32.5	2.29	574.41	48.8
80	Vale	Brazil	Materials	27.82	5.88	100.81	145.14
81	CVS Caremark	United States	Retailing	98.73	3.7	61.64	47.85
82	Itaúsa	Brazil	Conglomerates	66.36	2.25	342.63	28.74
83	ANZ Banking	Australia	Banking	26.91	2.6	420.52	53.72
84	Tesco	United Kingdom	Food Markets	77.94	3.1	65.61	51.43
85	Unilever	Netherlands/United Kingdom	Food, Drink & Tobacco	57.05	4.83	52.05	91.33
86	Honda Motor	Japan	Consumer Durables	102.82	1.41	117.24	63.22
86	Toronto-Dominion Bank	Canada	Banking	23.6	2.9	517.28	55.43
88	Iberdrola	Spain	Utilities	35.15	3.94	125.21	42.16
89	Comcast	United States	Media	35.76	3.64	112.73	47.76
90	China Life Insurance	China	Insurance	24.01	3.12	153.13	118.75
91	Bank of Nova Scotia	Canada	Banking	23.27	3.29	460.93	47.26
92	UnitedHealth Group	United States	Health Care Equipment & Svcs	87.14	3.82	59.05	39.4
93	Sberbank	Russia	Banking	23.27	3.2	220.62	57.7
94	United Technologies	United States	Conglomerates	52.92	3.83	55.76	65.28
95	Nordea Bank	Sweden	Banking	22.81	3.41	729.06	39.42
96	Bank of Communications	China	Banking	19.05	4.17	392.83	57.34
97	BASF	Germany	Chemicals	72.63	2.02	72.06	52.12
98	Walt Disney	United States	Media	36.29	3.31	69.31	61.17
99	Standard Chartered Group	United Kingdom	Banking	20.94	3.38	435.56	46.16
100	AstraZeneca	United Kingdom	Drugs & Biotechnology	32.8	7.52	53.63	63.56

---

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 3

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/

Answer 4

Hi,

I went to the web and highlight the information from the work Rank to the bottom, right click on the mouse, copy, then went to excel , CTRL + V and everything show up , no problems, I can apply calculations if I want

What do you get

Answer 5

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