How To Extract Google Results Into a Spreadsheet

Irina Shamaeva recently posted a link to this page which talks about converting your Google search results to an RSS feed.

Article Continues Below
I decided to explore taking this a step further – if I can convert it to RSS, then can I import these results into a spreadsheet?
With the assistance from Aaron Lintz and David Galley (to bounce ideas off of), I took a look at Excel and Google Docs to do this.
First Things First – 
  • You need to use a Google Custom Search Engine (Google CSE) for this – either create your own or use one created by someone else (like my basic one)
  • You need to complete the steps in this article to setup a Google CSE API key. Copy this to a clipboard, you will need it later. 
STEP 1 – Find the CSE id of your search engine
Find the unique identifier your Google CSE of choice. If you have created your own, you can get this in your control panel. If you are using a different one, look at the source code of the page and find the CX number. The id of my search engine is 015706279216314790222:15c3dmuxab8 – it will be in a similar format to that.
STEP 2 –  Plug your CSE id and Google CSE API, and search term into the Google CSE API URL
The basic URL is[CSE ID]&key=[API KEY]&q=[Query]
My example URL is (excluding the API key as this is purely for my use)[API KEY]&q=”project+manager”+Glasgow
You now have your RSS feed.
STEP 3 – For Excel
Excel has a facility to import RSS feeds – the XML Import tool. This blog by Diego Oppenheimer explains how to do it far better than what I can, so check that out.
Once you have done that though, you will probably start to – like me – get a bit frustrated. The limitations of the Google CSE API mean that you can only view 10 results. You can append the URL to view more of the results (only up to 100 though) by adding “&start=[num] – (thanks Aaron for pointing this one out as I had missed it). 
So, can you do a better job in Google Docs? 
STEP 4 – Google Docs
Turns out you can. 
Check out this sheet I created (not the cleverest, but I’m still learning the best way to do things in Google Docs).
Paste the URL you created in Step 2, and it will parse the data from the feed. This is using the Import XML formula in Sheets. This is far more flexible than Excel.
This is definitely a work in progress but thought I would get my notes so far out for feedback. I’m sure this concept can be taken further.


4 Comments on “How To Extract Google Results Into a Spreadsheet

  1. hi, for number three, the ““&start=[num]” trick is not working for me. I can’t put in number 100, however I put in number 50, and I still get just 10 results….

  2. I am actually looking for something that is like this. I really feel Google is just making everything a bit too difficult. I used to subscribe to Google Alerts and get those via RSS… DEAD. Tell me one thing Google can do that BING & FB teaming up can’t do. Nothing. BING get off of your booty and get something going!
    Pretty please.

    Boulder Bridges @ Ready to work Boulder
    ATTN: John inBoulderCO (John Russell Burgreen III)
    4747 Table Mesa Dr
    Boulder, CO 80305
    Location assistance: |
    Boulder Bridges SEO & Marketing
    John BoulderBridgesSEO @ aol(.)com

  3. This didn’t work for me. Takes me to a Google page with a 403 error saying “I don’t have access”. I am wondering if there are other examples of this now or what I am missing. After creating the dev project and the key is that all that you need to do: just plug in?

Leave a Comment

Your email address will not be published. Required fields are marked *