Bulk ImportXml (public version)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDE
1
ENTER URLS BELOW RESULTSENTER XPATH BELOWQuick reference
2
haitihospitalappeal.org/blog/Blog | Haiti Hospital Appeal//titleGet page title//title
3
www.womensfitness.co.ukWomens Fitness | Fitness, Weight Loss, Workouts and Healthy EatingGet anchor text//a
4
healthaffairs.org/blogHealth Affairs BlogPROCESSED 10 OUT OF 10Get links (href)//a/@href
5
http://bootswatch.com/Bootswatch: Free themes for Twitter BootstrapGet a div//div
6
www.bcs.org/category/6044BCS Health | Member Groups | Membership | BCS - The Chartered Institute for
IT
Get a div with a class//div[@class='here']
7
www.distilled.netdistilled: online marketing, PPC & SEO agency in London, Seattle & NYCGet a div with id//div[@id='here']
8
moz.comSEOmoz is now Moz. Software and Community for Better Marketing. - MozGet body//body
9
davidsottimano.comSEO, SEM Consultant - DavidSottimano.comGet list//li
10
http://www.cnn.com/CNN.com - Breaking News, U.S., World, Weather, Entertainment & Video NewsGet list within div//div//li
11
bbc.co.ukBBC - HomepageGet div AND list//div|//li
12
Get div with class and list//div[@class='ok']|//li
13
Instructions
14
1) Enter URLs (Col A) & enter Xpath (C2)
15
2) Click Run button
16
Troubleshooting
17
1) Ensure you're getting the non Javascript source code
18
2) Ensure you have the right Xpath and class/id names. It's case sensitive!
19
3) Check that you are scraping a URL that gives a 200 response code
20
4) Try a separate Importxml statement in another cell, use this xpath "//"
21
made by David Sottimano (2013 March)5) If you still get N/A# or other errors, the Gdocs user-agent may have been blocked by the target website. Nothing you can do :(
22
@dsottimano
23
*Note: Results always concatenate!
24
25
26
27
28
29
30
31
32
33
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
Loading...
 
 
 
Bulk ImportXML