You are here


Google Docs SEO Scraper Spreadsheets

We've produced a number of Google Docs spreadsheets that we share with the SEO community, intended to save time and offer useful functions to collect data about search engine rankings.

Bulk check results count

Bulk check top 10 rankings with Google Docs

Continuing our series of Google Docs SEO scrapers, this latest entry will show you how to bulk check the top 10 Google rankings for a list of keywords using Google Docs.

In a hurry? Grab your spreadsheet from the link below:

Use File >> Make a copy for your own version to work with.

This spreadsheet will check the top 10 results for numerous keywords, producing results like this:

Scrape top 100 search results with Google Docs

Our Google Docs spreadsheet to bulk check numbers of Google results has proven to be one of our most popular free tools. So, we're going to share more of our custom Google spreadsheets to allow you to perform additional functions.

Today, we'll show you how to scrape the title and URL of the top 100 Google results for any search query. Results will look like this:

Briefing: Google Mobile Algorithm, April 2015

Download this briefing as a PDF


Google will be introducing a significant modification to their mobile search result rankings on or around April 21st 2015.

How to access Google's Adwords Keyword Planner Tool

Google's Keyword Planner tool is one of the most comprehensive sources of keyword data available. While there are a few caveats, everyone involved with websites or online marketing are likely to find valuable data in Google's tool. And best of all, it's free!

1. Get a Google Account

The simplest method is to visit and follow the steps provided to make an account. If you already have a Gmail address or Google Account, skip this step.

Introducing getWaiter!

Here at SEO[Thing] we're always interested in technological innovation, so we're proud to be associated with the launch of an innovative new system designed to help restaurants (and others in the hospitality industry) improve customer service via the use of mobile.

Get Waiter combines a mobile app which you, as a customer, can use in a restaurant or bar with a web-based system for merchants. The way it works is:


Has the Panda gone soft? A first look at the July 2013 Update

With an apparent Panda update underway, we decided to take a look at statistics for commonly cited victims of the original Panda update. Google have suggested the update will be 'softer' than previous ones. Could it bring the recovery that many are hoping for?

Choosing sites and data source

Our personal preference for a source of data on general visibility is Searchmetrics - who have a broad data set in addition to several years' worth of data.

Using Transposh for Wordpress? It won't help your rankings

Update: the developers of the Transposh plugin appear to have resolved the issue identified in this article - you should now be able to rank translated pages using Transposh.

Co-occurrence, not occurrences: rethinking web copy for SEO

Are you writing your SEO copy for robots or people?

Keyword density is a phrase that (rightly) sends shudders down the spines of SEOs everywhere - even those who used to use keyword density as a basic way to assess their on-page targeting. So what's wrong with keyword density, and what should you be using instead?

Bulk Check Google Results Count with Google Docs

Update: we've updated this spreadsheet to the new Google Docs format - no more 50 limit on importxml lookups (and hopefully, more reliable results).

If you like this, also check out our spreadsheet to scrape the top 100 results and other Google Docs spreadsheets for SEO.