ARTICLE AD BOX
Extracting the hunt results into a spreadsheet is simply a seemingly straightforward thing.
However, due to the fact that of limitations connected automated queries placed by Google and other hunt engines, it tin go prohibitive to scrape the SERPs.
Compounding this contented is the information that determination aren’t galore tools that tin bash this successful an casual mode that results successful a spreadsheet with the sought-after data.
The pursuing is an overview of however to export Google hunt results to a spreadsheet, including applicable keyword information arsenic well.
Extract SERPs To Spreadsheet With A Chrome Extension
First connected the database is (arguably) the champion Chrome hold for extracting the hunt results consecutive into a spreadsheet.
There are galore different extensions that scrape the SERPs, but they don’t really extract the information into a spreadsheet.
For example, Surfer SEO has an astonishing Chrome hold that tin extract a important quantity of utile accusation astir the sites that fertile successful the apical 10, arsenic good arsenic supply keyword information that tin assistance successful crafting an article.
But, it doesn’t really export the SERPs into a spreadsheet.
There is 1 that does this truly well, and it’s from SEOquake.
SEOquake Chrome Extension
Screenshot by author, May 2022
SEOquake offers a escaped SEO Chrome hold that provides aggregate SEO information points layered close implicit the hunt results, including numbers that correspond to the hunt presumption of each website listed successful the SERPs.
The SEOquake privateness argumentation states that it volition not cod oregon usage your data.
The hold volition number each People Also Ask question arsenic a hunt result, truthful a SERP with 10 results positive 4 People Also Ask volition frankincense beryllium listed arsenic having 14 hunt results.
In bid to export conscionable a plain database of the hunt results, it’s indispensable to archetypal region each of the parameters from the report.
Otherwise, the study volition incorporate a batch much accusation than what whitethorn beryllium needed.
Step 1: The Parameters Button
The archetypal measurement is to click the Parameters paper button:
Screenshot by author, May 2022
Step 2: Deselect Parameters
What happens adjacent is that a flyout paper pops retired implicit the hunt results.
The flyout paper contains a multitude of parameters.
Un-tick each of the parameters.
Screenshot by author, May 2022
Step 3: Export To CSV
Now, you’re acceptable to download the hunt results consecutive into a spreadsheet.
On the left-hand menu, there’s an point labeled, Export to CSV. Just click it and the spreadsheet volition commencement downloading.
SEOquake is simply a useful mode to download the apical 10 of the hunt results consecutive into a spreadsheet.
Export Search Features To A Spreadsheet
Another utile instrumentality is the SERP Keyword Scraper by searchanalyzer Chrome extension.
SERP Keyword Scraper by searchanalyzer
Screenshot by author, May 2022
This instrumentality is focused connected extracting the keyword phrases that are successful Google’s hunt features.
SERP Keyword Scraper produces utile accusation astir the keywords that are related to your keyword phrase, arsenic displayed successful Google’s hunt features.
The Chrome hold exports the pursuing hunt features:
- Search suggestions.
- Related searches.
- Search refinements.
- FAQ affluent results.
- Image entities.
The Chrome hold extracts keyword information from:
- Google Search.
- Google Shopping.
- Google Image Search.
- Bing Search.
Using the instrumentality is ace easy.
Just instal the plugin and pin it to the browser truthful that it’s easy accessible.
The adjacent measurement is to behaviour a hunt connected Google (or Bing) and click the SERP Keyword Scraper icon, and the keywords are instantly copied to a clipboard.
Lastly, unfastened up a spreadsheet programme and paste. It’s arsenic casual arsenic that. Voila, right?
The spreadsheet that the hold produces is cleanable and orderly truthful that it’s casual to find what each the features are.
The instrumentality archetypal lists each the keyword phrases extracted from the disposable information of the hunt features (like People Also Ask, etc).
There’s a small instrumentality to utilizing this hold to beryllium alert of.
Before clicking the Chrome hold icon to make the report, beryllium definite to click successful the hunt container to make the Google Suggest keywords.
For example, for the keyword phrase, What is Structured Data:
- The archetypal acceptable of keywords successful the spreadsheet is scraped from Google Suggest.
- The 2nd acceptable of keywords successful the spreadsheet is scraped from the People Also Ask hunt feature.
- The 3rd acceptable of keyword phrases is scraped from the Related Searches hunt feature.
- The 4th radical of keywords was extracted from the FAQ Rich Results.
- The 5th radical of keyword phrases was extracted from the People Also Search For hunt feature.
That’s beauteous utile data, and it’s casual to extract.
Just click the icon button, and the information is saved successful the transcript clipboard. All you person to bash adjacent is paste it into a spreadsheet.
Something that I particularly admit astir the SERP Keyword Scraper Chrome hold is that it respects your privacy.
The instrumentality does not cod immoderate of your surfing information nor does it merchantability it.
According to the Privacy Practices:
“How does SERP Keyword scraper work?
Everything happens connected your machine! We entree the root codification of the hunt effect and extract the information for you. The plugin isn’t utilizing immoderate 3rd enactment data.
The steadfast has disclosed that it volition not cod oregon usage your data
This steadfast declares that your information is:
Not being sold to 3rd parties, extracurricular of the approved usage cases.
Not being utilized oregon transferred for purposes that are unrelated to the item’s halfway functionality.
Not being utilized oregon transferred to find creditworthiness oregon for lending purposes.”
Scrape Google’s SERPs With Screaming Frog
It’s imaginable to usage Screaming Frog to scrape the hunt results and search features.
In fact, determination are galore different scraping tools that tin bash this, too. But, it’s imaginable that Google mightiness prohibition your IP address.
If that happens, past you volition beryllium blocked from utilizing Google.
It should besides beryllium noted that Google strictly prohibits automated hunt queries.
Google’s presumption of service person a conception that is unambiguously titled “No Automated Querying.”
Google’s prohibition connection says:
“You whitethorn not nonstop automated queries of immoderate benignant to Google’s strategy without explicit support successful beforehand from Google.
Note that “sending automated queries” includes, among different things:
using immoderate bundle which sends queries to Google to find however a website oregon webpage “ranks” connected Google for assorted queries;”
Scraping Google with automated queries tin effect successful having your IP code banned.
SerpsBot
SerpsBot is an API that allows you to extract Google’s hunt results, including each hunt features similar People Also Ask and featured snippets.
The hunt results are exported into a JSON file, which tin past beryllium converted into a spreadsheet if that’s what you want.
This is an API, truthful 1 would person to beryllium susceptible of programming languages.
Many Ways To Extract SERPs
If you hunt online, you’ll find websites, workarounds, and tools for exporting Google’s hunt results.
I person recovered that immoderate of the online tools whitethorn show the archetypal leafage of Google’s SERPs and supply a mode to export them to a spreadsheet.
One specified tract is SERPs to Excel. It does a decent occupation of extracting the 10 hunt results.
However, the tract doesn’t number hunt results successful the featured snippets nor does it number video results. It provides results based connected the aged 10 bluish links paradigm.
For example, a hunt for [what is google palm?] results successful 7 hunt results minus the featured snippets and videos and includes 1 hunt effect from leafage 2 of the SERPs.
Results for thing much than the 2nd leafage of the SERPs costs $2 for 100+ hunt results.
One bully happening astir this website is that it’s not pursuing you astir connected your browser arsenic a Chrome extension.
But, if you similar the convenience of downloading the information straight from the hunt results, past a Chrome hold is much suitable for that benignant of workflow.
Keyword Tool Workarounds
There are galore tools that connection fertile tracking and keyword research. But surprisingly, determination aren’t galore escaped tools that supply this functionality without having to bash a small workaround to get what you need.
Semrush Keyword Overview Tool
For example, the escaped mentation of Semrush offers the Keyword Overview instrumentality which tin springiness you the SERPs successful a convenient manner.
Step 1: Select Keyword Overview Tool
On the left-side navigation menu, prime the Keyword Overview nexus that’s located successful the Keyword Research section.
Screenshot by author, May 2022
Step 2: Search For Keywords
Next, look to the apical right-hand broadside of the page, wherever there’s a hunt box.
Enter the keyword operation and click the Search button.
Screenshot by author, May 2022
Step 3: SERP Analysis
Once the instrumentality has extracted the hunt results, scroll down to the conception labeled SERP Analysis.
Here, it is imaginable to transcript the database of URLs that are ranked successful the apical 10 for the chosen keyword phrase.
Screenshot by author, May 2022
Step 4: Paste Into A Spreadsheet
Lastly, transcript the database of hunt effect URLs and paste it into a spreadsheet.
Screenshot by author, May 2022
As you tin see, it’s imaginable to make a spreadsheet of the apical 10 for assorted hunt results utilizing escaped keyword probe tools, but it’s an imperfect solution.
Extracting Search Results To A Spreadsheet
At first, it whitethorn look that extracting the hunt results into a spreadsheet is an casual thing, but it is not.
There are aggregate solutions available, but they each travel with their ain pros and cons.
Ultimately, it is up to you to observe which instrumentality works champion for your workflow.
More Resources:
- Mastering SEO Within Google’s SERPs [Podcast]
- How To Dominate SERPs By Focusing On Topics Instead Of Keywords
- SEO For Beginners: An Introduction To SEO Basics
Featured Image: Gorodenkoff/Shutterstock
English (US)