How to Export Google Search Results to Excel

SMS Text

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 CSV


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:

Google search results - Excel (SEJ)

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

Ann Smarty
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.
Ann Smarty
  • http://seogadget.co.uk richardbaxterseo

    I didn’t know you could do that with SEOquake. Thanks for sharing :-)

  • http://www.brian-hancock.com Brian Hancock

    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… =/

  • http://www.kandiandkeith.com/ Kandi Humpf

    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.

  • http://twitter.com/moook Mook

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

  • http://www.seosmarty.com/ Ann Smarty

    @Mook, you can switch it off with one click as well as remove any parameters you don’t want to request..

  • http://www.shorehills.net Shorehills

    Is this limited the first 1,000 results or can you get all of them?

  • http://www.seosmarty.com/ Ann Smarty

    @Shorehills, it is limited to whatever Google is limited…

  • http://www.linkedin.com/in/haseebnajam seoz87

    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.

  • http://www.edwardbeckett.com Edward Beckett

    “# 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

  • http://www.autisme-counseling.com/ Sandybali

    :-)
    Very nice and useful info !
    Thank you a lot :-)

  • Jenni

    Thanks a lot i am not aware of it:)

  • Jenni

    seoquake.com its not opening dear can u help me

  • http://www.fox-tutorials.de Tobias

    Oh Ann, good to have you around! Alway a special information I didn’t know yet. Keep it up keep it up..

  • http://www.semconsultancy.com/blog/ Joe Williams

    You can do something similar with the SEOBOOK F.F. plugin too…

  • SEO_Plus

    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…

  • https://www.searchenginejournal.com Ann Smarty

    Yeah, there are some problems with SEOquake site right now, you can install it here:
    https://addons.mozilla.org/en-US/firefox/addon/3036

    As for the above comment, don’t use the addon for every search – only in case you are performing some analysis and you should be fine.

  • http://marketinggossip.blogspot.com Asif Anwar

    Ann, another great post and mostly sought one. I generally search for directories and sites for inbound link building theough Google and preparing a report is a hassle. This is help a lot. As of Excel, you also might be interested in my article in Marketing Pilgrim – How to Write Hundreds of Unique Articles from One Article with MS Excel – Article Theme Versioning

  • http://www.marketing2oh.com Dale Stokdyk

    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?

  • https://www.searchenginejournal.com Ann Smarty

    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!

  • http://www.askwhiz.com Ask Questions

    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.

  • http://www.searchenginerankings.com.au Toan

    Hi Ann,

    where do i go for export?

    Please help!

    • http://www.seosmarty.com/ Ann Smarty

      The option is above the search results, It says “Save”

  • http://www.mydataworks.net Mike w

    These posts are a bit old… Does this still work? If you can save the search results that would be great!!!

  • Rana

    can we do the same with google scholar results?

  • Andy

    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 .

  • Asif Dewan

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

  • Steve

    This is useless. Why don’t you tell us the steps needed to do this through SEOQuake.

  • http://www.nonsuchpr.com Michael White

    Unfortunately it looks like SEOQuake has closed down now. Will have to find another method!

  • Amin

    Very useful. Thanks Ann!