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

MozBar SERP Screenshot - Export CSV

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.

 

9 Responses to Export Search Results or Scrape SERPs to Excel CSV

  1. 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.

  2. Rita says:

    This is exactly what I needed today. You’ve saved me many hours of work! Thanks!

  3. This feature appears to no longer exist.

  4. Johnny Smithe says:

    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.

  5. I don’t see any option for “export to .csv” option on the SERP control panel in Firefox 22.0 – I’m very disappointed. This was the reason that I installed the add on. However there are some other cool features that I like better than the Webrank bar that I was using… so it may not have been a total loss.

Leave a Reply

Fargo-Moorhead SEO Company

Drop us a line if you want to talk about what we can do to help your business. We are open to working with other Fargo marketing firms as well.

Are You Our Ideal Client?

Our ideal client is someone who is looking for a consulting team that will become a part of their business and work together long term. We are looking for clients who already understand the value of SEO and inbound marketing and are seeking strategic advice and technical help.