Extracting the search outcomes right into a spreadsheet is a seemingly easy factor.

Nevertheless, due to limitations on automated queries positioned by Google and different serps, it will probably turn out to be prohibitive to scrape the SERPs.

Compounding this problem is the truth that there aren’t many instruments that may do that in a straightforward method that leads to a spreadsheet with the sought-after information.

The next is an outline of methods to export Google search outcomes to a spreadsheet, together with related key phrase information as nicely.

Extract SERPs To Spreadsheet With A Chrome Extension

First on the checklist is (arguably) the very best Chrome extension for extracting the search outcomes straight right into a spreadsheet.

There are numerous different extensions that scrape the SERPs, however they don’t really extract the info right into a spreadsheet.

For instance, Surfer search engine marketing has an incredible Chrome extension that may extract a major amount of helpful details about the websites that rank within the prime 10, in addition to present key phrase information that may assist in crafting an article.

However, it doesn’t really export the SERPs right into a spreadsheet.

There’s one which does this very well, and it’s from SEOquake.

SEOquake Chrome Extension

Screenshot of SEOquake Chrome Extension Web PageScreenshot by creator, Might 2022

SEOquake presents a free search engine marketing Chrome extension that gives a number of search engine marketing information factors layered proper over the search outcomes, together with numbers that correspond to the search place of every web site listed within the SERPs.

The SEOquake privateness coverage states that it won’t acquire or use your information.

The extension will depend every Folks Additionally Ask query as a search end result, so a SERP with 10 outcomes plus 4 Folks Additionally Ask will thus be listed as having 14 search outcomes.

With a view to export only a plain checklist of the search outcomes, it’s essential to first take away all the parameters from the report.

In any other case, the report will comprise much more info than what could also be wanted.

Step 1: The Parameters Button

Step one is to click on the Parameters menu button:

SEOquake ParametersScreenshot by creator, Might 2022

Step 2: Deselect Parameters

What occurs subsequent is {that a} flyout menu pops out over the search outcomes.

The flyout menu comprises a large number of parameters.

Un-tick all the parameters.

SEOquake Chrome Extension Parameters MenuScreenshot by creator, Might 2022

Step 3: Export To CSV

Now, you’re able to obtain the search outcomes straight right into a spreadsheet.

On the left-hand menu, there’s an merchandise labeled, Export to CSV. Simply click on it and the spreadsheet will begin downloading.

SEOquake is a helpful method to obtain the highest 10 of the search outcomes straight right into a spreadsheet.

Export Search Options To A Spreadsheet

One other great tool is the SERP Key phrase Scraper by searchanalyzer Chrome extension.

SERP Key phrase Scraper by searchanalyzer

Screenshot of SERP Keyword Scraper Chrome Extension PageScreenshot by creator, Might 2022

This device is concentrated on extracting the key phrase phrases which can be in Google’s search options.

SERP Key phrase Scraper produces helpful details about the key phrases which can be associated to your key phrase phrase, as displayed in Google’s search options.

The Chrome extension exports the next search options:

  • Search ideas.
  • Associated searches.
  • Search refinements.
  • FAQ wealthy outcomes.
  • Picture entities.

The Chrome extension extracts key phrase information from:

  • Google Search.
  • Google Buying.
  • Google Picture Search.
  • Bing Search.

Utilizing the device is tremendous straightforward.

Simply set up the plugin and pin it to the browser in order that it’s simply accessible.

The subsequent step is to conduct a search on Google (or Bing) and click on the SERP Key phrase Scraper icon, and the key phrases are immediately copied to a clipboard.

Lastly, open up a spreadsheet program and paste. It’s as straightforward as that. Voila, proper?

The spreadsheet that the extension produces is clear and orderly in order that it’s straightforward to find out what all of the options are.

The device first lists all of the key phrase phrases extracted from the seen portion of the search options (like Folks Additionally Ask, and many others).

There’s somewhat trick to utilizing this extension to pay attention to.

Earlier than clicking the Chrome extension icon to generate the report, make sure you click on within the search field to generate the Google Counsel key phrases.

For instance, for the key phrase phrase, What’s Structured Knowledge:

  1. The primary set of key phrases within the spreadsheet is scraped from Google Counsel.
  2. The second set of key phrases within the spreadsheet is scraped from the Folks Additionally Ask search function.
  3. The third set of key phrase phrases is scraped from the Associated Searches search function.
  4. The fourth group of key phrases was extracted from the FAQ Wealthy Outcomes.
  5. The fifth group of key phrase phrases was extracted from the Folks Additionally Search For search function.

That’s fairly helpful information, and it’s straightforward to extract.

Simply click on the icon button, and the info is saved within the copy clipboard. All you must do subsequent is paste it right into a spreadsheet.

One thing that I particularly respect concerning the SERP Key phrase Scraper Chrome extension is that it respects your privateness.

The device doesn’t acquire any of your browsing information nor does it promote it.

In accordance with the Privateness Practices:

“How does SERP Key phrase scraper work?

All the pieces occurs in your machine! We entry the supply code of the search end result and extract the info for you. The plugin isn’t utilizing any third celebration information.

The writer has disclosed that it’ll not acquire or use your information

This writer declares that your information is:

Not being bought to 3rd events, exterior of the permitted use instances.

Not getting used or transferred for functions which can be unrelated to the merchandise’s core performance.

Not getting used or transferred to find out creditworthiness or for lending functions.”

Scrape Google’s SERPs With Screaming Frog

It’s potential to make use of Screaming Frog to scrape the search outcomes and search options.

The truth is, there are numerous different scraping instruments that may do that, too. However, it’s potential that Google may ban your IP deal with.

If that occurs, then you can be blocked from utilizing Google.

It must also be famous that Google strictly prohibits automated search queries.

Google’s phrases of service have a piece that’s unambiguously titled “No Automated Querying.”

Google’s prohibition assertion says:

“You could not ship automated queries of any type to Google’s system with out categorical permission upfront from Google.

Notice that “sending automated queries” contains, amongst different issues:

utilizing any software program which sends queries to Google to find out how an internet site or webpage “ranks” on Google for varied queries;”

Scraping Google with automated queries may end up in having your IP deal with banned.

SerpsBot

SerpsBot is an API that lets you extract Google’s search outcomes, together with all search options like Folks Additionally Ask and featured snippets.

The search outcomes are exported right into a JSON file, which might then be transformed right into a spreadsheet if that’s what you need.

That is an API, so one must be able to programming languages.

Many Methods To Extract SERPs

When you search on-line, you’ll discover web sites, workarounds, and instruments for exporting Google’s search outcomes.

I’ve discovered that among the on-line instruments could show the primary web page of Google’s SERPs and supply a method to export them to a spreadsheet.

One such web site is SERPs to Excel. It does a good job of extracting the ten search outcomes.

Nevertheless, the positioning doesn’t depend search leads to the featured snippets nor does it depend video outcomes. It gives outcomes primarily based on the outdated 10 blue hyperlinks paradigm.

For instance, a seek for [what is google palm?] leads to seven search outcomes minus the featured snippets and movies and contains one search end result from web page two of the SERPs.

Outcomes for something greater than the second web page of the SERPs prices $2 for 100+ search outcomes.

One benefit of this web site is that it’s not following you round in your browser as a Chrome extension.

However, should you choose the comfort of downloading the info instantly from the search outcomes, then a Chrome extension is extra appropriate for that type of workflow.

Key phrase Instrument Workarounds

There are numerous instruments that supply rank monitoring and key phrase analysis. However surprisingly, there aren’t many free instruments that present this performance with out having to do some workaround to get what you want.

Semrush Key phrase Overview Instrument

For instance, the free model of Semrush presents the Key phrase Overview device which might provide the SERPs in a handy method.

Step 1: Choose Key phrase Overview Instrument

On the left-side navigation menu,  choose the Key phrase Overview hyperlink that’s situated within the Key phrase Analysis part.

Screenshot of Semrush Left Side Navigation MenuScreenshot by creator, Might 2022

Step 2: Search For Key phrases

Subsequent, look to the highest right-hand aspect of the web page, the place there’s a search field.

Enter the key phrase phrase and click on the Search button.

Screenshot of Semrush Keyword Overview Search BoxScreenshot by creator, Might 2022

Step 3: SERP Evaluation

As soon as the device has extracted the search outcomes, scroll right down to the part labeled SERP Evaluation.

Right here, it’s potential to repeat the checklist of URLs which can be ranked within the prime 10 for the chosen key phrase phrase.

Semrush SERP AnalysisScreenshot by creator, Might 2022

Step 4: Paste Into A Spreadsheet

Lastly, copy the checklist of search end result URLs and paste it right into a spreadsheet.

Screenshot of a spreadsheet listing URLs and domain names of top 10 search resultsScreenshot by creator, Might 2022

As you’ll be able to see, it’s potential to create a spreadsheet of the highest 10 for varied search outcomes utilizing free key phrase analysis instruments, but it surely’s an imperfect resolution.

Extracting Search Outcomes To A Spreadsheet

At first, it might appear that extracting the search outcomes right into a spreadsheet is a straightforward factor, however it isn’t.

There are a number of options accessible, however they every include their very own execs and cons.

In the end, it’s as much as you to find which device works greatest to your workflow.

Extra Sources:


Featured Picture: Gorodenkoff/Shutterstock



Previous articleGoogle’s Most well-liked Structured Knowledge: JSON-LD vs. Microdata
Next articleFixing Google Search Console’s Protection Report ‘Excluded Pages’

LEAVE A REPLY

Please enter your comment!
Please enter your name here