For most people, this is sort of an SEO 101 thing, but I still run into people looking for information on how to get data out of the SERPs. Exporting search results is a simple but powerful way to get data from google for link building or keyword research. If you are not great with code and don’t want to deal with importXml you don’t need to look any further than the SEOmoz MozBar. You probably already have it installed on your browser. If you don’t, you can grab it for Chrome or Firefox at this link.
The biggest problem with the MozBar is that it is so full of features that you are probably missing out on most of them.
Once the MozBar is installed, simply follow the easy steps below.
Exporting Google Search Results into an Excel CSV
1) Perform a search in google in the browser with the MozBar installed
2) Click ‘Export to CSV’ in the SERP Control Panel on the top right
That’s it. It’s that freaking easy. Be sure to change your advanced search settings to show up to 100 results if you want to export the top 100 results in the SERPs.
7 Responses to Export Search Results or Scrape SERPs to Excel CSV
Leave a Reply
Featured on
I did not know about this functionality. Which is probably because most of the time at the office I don’t use MozBar as much due to some of the security set in place on our network. All the HTTP requests from MozBar to SEOmoz makes the firewall and software used go crazy!
Also thought this was a little funny as I was just playing with a new SERP’s scraper from SEER Interactive. I think the blog just got posted today as well.
Hope you don’t mind me sharing the link.
http://www.seerinteractive.com/blog/google-scraper-in-google-docs-update
This was a simple feature that I overlooked for way too long. I appreciate you posting the link to SEER’s post. I haven’t had a chance to look at it yet, but definitely will. SEER is one of the better blogs in the industry IMO.
This is exactly what I needed today. You’ve saved me many hours of work! Thanks!
This feature appears to no longer exist.
Hi Miguel-
You can still export search results with the Firefox version of the Mozbar. It does not work with Chrome.
In Firefox, Google doesn’t support the &num=100 string, meaning that it only shows you ten results at one time.
Hi Johnny-
You can still export 100 by simply changing your Google Search settings to display 100 results. No need to bother with the query string.
Once 100 results are display, simply use the export to csv option provided by the MozBar.