Easily turn SERPs into CSV files (100 SERP results at a time)

When prospecting for link building outreach targets, it is useful to turn a Search Engine Result Page (SERP) into a CSV file, so the CSV file can be used as input to various software programs that help you determine if the target URLs and websites are worth pursuing.

This tool does just that, with Google Custom Search Operators, and a browser extension named SEOquake. We hope you find this tool useful.

The Google Custom Search Operators make it easy to generate very focused SERPs, and SEOquake makes it easy to download the SERPs to CSV files.

IMPORTANT: If your custom search operators define a search that is too narrow, you may see very few, or even zero results.

↓↓↓     Scroll down to see the setup and use instructions     ↓↓↓ 

Instructions: Generating focused Search Engine Result Pages

If you have not done the setup yet, do that first. See below.
Use the form above to build Google Custom Search Queries with which to conduct very focused Google searches.
   You specify the search operator you wish to use (no more than three) and the search string for the operator.
   This tool then ANDs them together into a Google search which is launched in a new browser tab.
   Bear in mind, if your search is too narrow, no results will be returned.
A new browser tab will open containing your SERP, with the SEOquake browser extension (provided you've done the setup, described below).
Use SEOquake to save the SERP to a CSV file.

This is important:

The SEOquake details for each URL are fetched after the SERP is generated.
It takes a LONG TIME  to fetch all the details.
If you export to a CSV file before this data collection has finished,  details will be missing from your CSV file.
To know SEOquake has completed, scroll to the last result in the SERP, and ensure none of the values displayed under the SERP result still say "wait...".

Do the prerequisite setup first

Install the SEOquake browser extension

What is the SEOquake browser extension?
SEOquake is a browser plugin provided by SEMRush.
It makes it VERY easy to save a Google SEP (Search Engine Result Page) as a CSV file.


Install the SEOquake browser extension
Scroll to the very bottom of the page.
Find and install the appropriate extension for your browser.
The image shows where on the SEOquake.com website you find the links to the browser extensions.
Optional: Set a parameter in SEOquake to show the SERP positions

This is optional. I just happen to like it.

The image below shows both what it does, and where you find it. It shows the position of each SERP result within the SERP. And the way you get to it, is by selecting Parameters.

The image shows where you set the SEOquake parameter to show the SERP position within the SERP, and what it does after you've set it.

Once you select Parameters, you then to select MORE SETTINGS, to get to this setting.

The image shows how to turn on the SEOquake setting to show the SERP position of the search results within the SERP.

The setting to show position numbers of the SERP results is the first setting in the list.

The image shows what to select to turn on showing SERP positions within SEOquake.

Configure your Google Search settings

Did you know you even CAN set Google search settings?

Go to Google.com and look at the bottom right corner of the browser. You'll see three links, one of which is "Settings".

Image of the Settings link at the bottom of Google.com

When you select it, you see a menu, from which you select Search Settings.

Image showing how to set Google search settings.

Set Results per page to 100 (which is the highest setting), and set "Do not use private results".

Image shows how to set Google search settings to show 100 results per Search Engine Result Page, and to NOT use private search results.

Now you've set your Google search settings as needed to make use of this Search Operator Queries tool.