Scraping and Cleaning Your Data with Google Sheets: A Closer Look

Ecompromo | September 27, 2015 | SEO Resources

funny people url 2.png

Posted by tags. We also happen to notice that the tags are “children” of the

tags. What these values mean is a topic for another post, but what we need to keep in mind is that for this particular URL, this is where our desired information lives that we need to extract. It will almost certainly live in a different area with different modifiers on any other given URL; this is just the information that’s unique to the site we’re on.

Let’s get to the scary stuff (maybe?): how to write the formula.

I put the formula in cell A3, where I have the red arrow. As can be seen in the highlighted rectangle, I wrote =IMPORTXML(A1, “//h3//a[@target=’_blank’]”), which yielded a wonderful, organized list of all the top Twitter handles to follow from the page. Voila. Cool, right?

Something to remember when doing this is that the values have been created via a formula, so trying to copy and paste them regularly can get messy; you’ll need to copy and paste as values.

Now, let’s break down the madness.

Like any other function in Sheets, you’ll need to begin with an equal sign, so we start with =IMPORTXML. Next, we find the …read more

Related Posts