HTML Table extractor

	C	D	E
1	HTML Table extractor
2	Extract data from an HTML table with Google Sheets.
3
4	➊	Install ImportFromWeb	INSTALL
5
6	➋	Copy this spreadsheet and activate ImportFromWeb	MAKE A COPY
7
8
9
10		Input the webpage URL	https://en.wikipedia.org/wiki/List_of_countries_by_air_pollution
11
12		table
13		Part of a series on
14		Pollution
15		Air pollution from a factory
16		Air Acid rain Air quality index Atmospheric dispersion modeling Chlorofluorocarbon Combustion Exhaust gas Haze Household air pollution Global dimming Global distillation Indoor air quality Non-exhaust emissions Ozone depletion Particulates Persistent organic pollutant Smog Soot Volatile organic compound
17		Biological Biological hazard Genetic Illegal logging Introduced species Invasive species
18		Digital Information Effects of violence in mass media
19		Electromagnetic Light Ecological Overillumination Radio spectrum
20		Natural Ozone Radium and radon in the environment Volcanic ash Wildfire
21		Noise Transportation Health effects from noise Marine mammals and sonar Noise barrier Noise control Soundproofing
22		Radiation Actinides Bioremediation Depleted uranium Nuclear fission Nuclear fallout Plutonium Poisoning Radioactivity Uranium Radioactive waste
23		Soil Agricultural Land degradation Bioremediation Defecation Electrical resistance heating Illegal mining Soil guideline values Phytoremediation
24		Solid waste Advertising mail Biodegradable waste Brown waste Electronic waste Food waste Green waste Hazardous waste Industrial waste Litter Mining Municipal solid waste Nanomaterials Plastic Packaging waste Post-consumer waste Waste management
25		Space Space debris
26		Thermal Urban heat island
27		Visual Air travel Advertising clutter Overhead power lines Traffic signs Urban blight Vandalism
28		War Chemical warfare Herbicidal warfare Agent Orange Nuclear holocaust Nuclear fallout Nuclear famine Nuclear winter Scorched earth Unexploded ordnance War and environmental law
29		Water Agricultural wastewater Biosolids Diseases Eutrophication Firewater Freshwater Groundwater Hypoxia Industrial wastewater Marine Monitoring Nonpoint source Nutrient Ocean acidification Oil spill Pharmaceuticals Freshwater salinization Septic tanks Sewage Shipping Sludge Stagnation Sulfur water Surface runoff Turbidity Urban runoff Water quality Wastewater
30		Topics History Pollutants Heavy metals Paint
31		Misc Area source Brain health and pollution Debris Dust Garbology Legacy Midden Point source Technofossil Waste ToxicLists Diseases Law by country Most polluted cities Least polluted cities by PM2.5 Treaties Most polluted riversCategories By country
32		Environment portalEcology portal
33		.mw-parser-output .navbar{display:inline;font-size:88%;font-weight:normal}.mw-parser-output .navbar-collapse{float:left;text-align:left}.mw-parser-output .navbar-boxtext{word-spacing:0}.mw-parser-output .navbar ul{display:inline-block;white-space:nowrap;line-height:inherit}.mw-parser-output .navbar-brackets::before{margin-right:-0.125em;content:"[ "}.mw-parser-output .navbar-brackets::after{margin-left:-0.125em;content:" ]"}.mw-parser-output .navbar li{word-spacing:-0.125em}.mw-parser-output .navbar a>span,.mw-parser-output .navbar a>abbr{text-decoration:inherit}.mw-parser-output .navbar-mini abbr{font-variant:small-caps;border-bottom:none;text-decoration:none;cursor:inherit}.mw-parser-output .navbar-ct-full{font-size:114%;margin:0 7em}.mw-parser-output .navbar-ct-mini{font-size:114%;margin:0 4em}html.skin-theme-clientpref-night .mw-parser-output .navbar li a abbr{color:var(--color-base)!important}@media(prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .navbar li a abbr{color:var(--color-base)!important}}@media print{.mw-parser-output .navbar{display:none!important}}vte
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100