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).
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:
Important: here’s an absolutely fantastic post on scraping Google results teaching how to export search listings titles, descriptions and URLs
Latest posts by Ann Smarty (see all)
- Content Marketer’s Resource Box: Free Ebooks and Cheatsheets - April 26, 2013
- 3 WordPress Plugins to Diversify Your Content - April 5, 2013
- aHrefs versus MajesticSEO: The Real Test - February 5, 2013
I didn’t know you could do that with SEOquake. Thanks for sharing :-)
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… =/
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.
this is huge!
it is a shame it uses so much memory, it takes so long to request many parameters…and export them…
@Mook, you can switch it off with one click as well as remove any parameters you don’t want to request..
Is this limited the first 1,000 results or can you get all of them?
@Shorehills, it is limited to whatever Google is limited…
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.
“# 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
:-)
Very nice and useful info !
Thank you a lot :-)
Thanks a lot i am not aware of it:)
seoquake.com its not opening dear can u help me
Oh Ann, good to have you around! Alway a special information I didn’t know yet. Keep it up keep it up..
You can do something similar with the SEOBOOK F.F. plugin too…
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…
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.
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
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?
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!
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.
Hi Ann,
where do i go for export?
Please help!
The option is above the search results, It says “Save”
These posts are a bit old… Does this still work? If you can save the search results that would be great!!!
can we do the same with google scholar results?
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 .
Can anybody show or tell me how to use this to get Google search urls in excel? Please!
This is useless. Why don’t you tell us the steps needed to do this through SEOQuake.