Wondering how to download search results to an excel CSV or Google sheets? Here is a simple step by step tutorial to export search results quickly on your computer.
This method can help you download Bing, Yahoo, Google, and Yandex search results.
There are two different ways to download search results.
- You can manually copy each result from the search results to a spreadsheet. This process could take ages, especially if you want to download the results quickly and get done with it.
- Use third-party tools to automate search results downloads. In this post, we will apply this method.
Table of Contents
Download Search Results to Excel Spreadsheet in Google Chrome
Step 1: Download the SEOQuake extension in your Chrome browser. After successful installation, you will see the SEOquake extension at the top right corner of your browser.
Right-click on the SEOQuake extension button and select options from the drop-down menu.
Now select SERP Overlay.
Step 2: If you only want to download URLs of the search results, then uncheck all the boxes next to active parameters. You can customize any option you wish to include in your downloaded CSV file from active parameters.
Now you need to change the settings of the search results. It depends on how many search results you want to download. By default, Google and other search engines show ten results per page. Here’s how to change those settings:
Change results per page settings
Step 1: Search for anything on Google. Find the settings option below the top search bar.
Step 2: Click on settings. Now select the option search settings. It will load a Google search settings page.
Step 3: Find results per page option. Scroll this icon to as many search results as you want to display and download.
Step 4: Now go back to your search result page. Search anything that you want to download from the search results. Wait for at least 5 seconds to completely load the search results page. Now click on this option from the left-hand corner Export CSV.
That’s it! It should download a CSV file to your computer.
Download Search Results to Excel Spreadsheet in Mozilla Firefox
Step 1: Install the SEOquake firefox extension in your Firefox browser. After the installation, follow these steps: Look for the SQ icon in your browser’s top right corner.
Step 2: Click on the SQ extension shortcut. It will open a new window in your browser. On that window, look closely at the top right corner, and you will find a settings gear icon.
Step 3: Click the settings icon and select preferences. It will open a new tab in your browser. Now select SERP Overlay. If you only want to download the search results URLs, uncheck all the boxes.
Step 4: Please see the part above configuring search results per page. After configuration, you can download your search results directly. Search anything that you want to download from the search results. Find this option in the left corner of your search results page “Export CSV.” Now click on the Export CSV button.
After that, it will download a list of 100 search results into an excel spreadsheet on your computer.
You can upload this CSV file to Google Drive, Google Sheets, or any other cloud storage capable of processing CSV files.
How to Download Search Results to Google Sheets or Google Drive?
First of all, you would require a Google account. By creating an account on Google, you can access many useful tools such as Google Search Console, Google Drive, Google Sheets, Google Docs, and many more.
You can upload your CSV file to Google Drive after creating an account.
Go to your Google Drive account and look for the ‘New’ Button at the top left corner. You will find the option ‘File Upload’ by clicking on this button.
Upload your CSV file, and you can share this file with anyone who has an Internet connection. No need to save that file on your USB drive, etc…
Export Google Maps Search Results to Excel CSV
A user asked in the comments how to export Google Maps search results into a CSV file. I wasn’t aware of the tool to export Google maps search results then.
However, recently I found a tool to extract Google Maps search into a CSV file which you can open in Google Sheets or Microsoft Excel. Here’s how to export Google Maps search results:
Step 1: Install this Google Chrome extension to your browser.
Step 2: Click on the icon from the extensions bar. It will open up a new window.
Step 3: In the ‘Enter Keywords’ area, enter the keywords you want to search and export.
Step 4: Click the Start Process button. It will extract all the Google map information for you.
Step 5: Click ‘Stop & Download CSV’. Save this file to your computer.
Note: You can also upload a .txt file with your keywords list if you want to extract multiple search results.
If you're interested in working with me, get in touch.