SEO

How to Export Google Search Results to Excel

Saving Google results as an Excel file may open up plenty of possibilities for advanced analysis you would never think of before.

SEOquake (Update: if the site it down, you can install it here) is a FireFox addon that has plenty of options – and one of them is the ability to export Google search results in a CSV file which you can open with Excel.

The export file contains:

  • Each listing URL;
  • Any additional data you set SEOquake to retrieve (e.g. Google PageRank; Google cache date, Yahoo links, etc).

seoquake csv2 How to Export Google Search Results to Excel


This handy little feature allows for a wealth of possibilities. Do you want to know how many people saved each page of your site to Delicious and how many backlinks each one has? No problem!

  • Configure SEOquake to only show you Yahoo backlinks to a page and Delicious index,
  • Set Google to show you 100 results per page;
  • Run {site:yoursite.com}search in Google;
  • Export results to csv;
  • Play with all those sorting and filtering options Excel has to offer.

This will give you an idea of how many backlinks versus Delicious bookmarks (considering both can be the metrics of the resource usefulness) the site has:

seoquake excel How to Export Google Search Results to Excel

Important: here’s an absolutely fantastic post on scraping Google results teaching how to export search listings titles, descriptions and URLs

 How to Export Google Search Results to Excel
Ann Smarty is the blogger and community manager at Internet Marketing Ninjas. Ann's expertise in blogging and tools serve as a base for her writing, tutorials and her guest blogging project, MyBlogGuest.com.
 How to Export Google Search Results to Excel

You Might Also Like

Comments are closed.

29 thoughts on “How to Export Google Search Results to Excel

  1. I’m a big fan of SEOQuake and never realized it could do this – nice find! Now if only Google and SEOquake would get along so I don’t have to see that nasty CAPTCHA so often… =/

  2. Great post! I’m also a big fan of SEOquake and didn’t know it could do that. I usually use the darn import web query in excel but this is much cleaner.

  3. this is huge!
    it is a shame it uses so much memory, it takes so long to request many parameters…and export them…

  4. no doubt you can do a lot with seo quake. I am using it as a bulk Page Rank checker now a days :P. Have extracted 2500 urls page rank at a time though got temporary ip banned for a day by google then.

  5. “# Set Google to show you 100 results per page;
    # Run {site:yoursite.com}search in Google;
    Export results to csv … ”

    I do that … a lot :)

    Cool Stuff Ann

  6. be forewarned that SEO Quake can get your IP banned from Google and frequent abuse might shut the whole thing down.

    Talking / promoting this tool to much could put an end to it – or worse, Google might decide to build these features into their interface and only tell us what they want to tell us…

  7. Hi Ann,

    Nice post — you’re always a great source for new tools and ideas!

    Question about the post: Is there a way to also capture page title and description with SEOQuake or similar?

    I haven’t found a way to do that; instead, I found a FF extension called Outwit Hub to “scrape” web pages with. See my blog article at marketing2oh.com to see examples and let me know if you have an easier way?

  8. Hey Dale, your post is great! While you were too humble to link to it, I updated my post linking to your article. Thanks for sharing!

  9. i have been using SEO quake for quite a while now. I am pleased to know about this feature. now it makes my work of downloading high PR links easier.

  10. Does google really bans the IP. I have over 40000 pages to be extracted for a domain and the domain is live and cannot afford to go off.

    Please help if I should go for SEOQuake or how? I am taking the data for my inventory .

  11. Can anybody show or tell me how to use this to get Google search urls in excel? Please!