XPATH to Extract Text from Webpage

Support
#1

Hi All

I have been a user of SEO Tools for Excel for a few years now and have just started to explore XPATH.

I have a situation where I need to extract text from a webpage (well actually a list of it so we can do content auditing)

So far my formula looks something like this:

=xpathonurl("url","/html/body/div[2]/div/div[3]/div[1]/text()")

for some reason I can get a variation to work on the websites home page but not the category page that the xpath was extracted from

any help would be appreciated

Thank you

#2

Can you possibly share the URL of the page you're trying to get the data from, as well as point out what data you're trying to extract?

If the data you're trying to extract is in a table, when grabbing the XPath from the Inspector in Chrome (I'm assuming that's what you're doing), if you see "/tbody" in it, try removing it.

There is also a plugin for Chrome called XPath Helper Wizard, which is an alternate method of generating XPath's to use with XPathonURL, that might work for you.

1 Like