Wondering how to download search results to an excel spreadsheet or save them on the cloud such as Google docs? Here is a simple step by step tutorial to download search results quickly on your computer.
Whether you need to download search results for link building or any other purpose. You can use this method to download any results from Bing, Yahoo, Google, Yandex, and more. It is the easiest way to track your website’s search rankings.
There are 2 different ways to download search results.
- You can copy each result manually from the search results to a spreadsheet. This process could take ages especially if you just want to quickly download the results and get done with it.
- Using third-party tools (we are going to use this method)
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 SEOquake extension at the top right corner of your browser.
Right-click on 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 that you want to include in your downloaded CSV file from active parameters.
Now you need to change settings of the search results. It depends on how many search results do you want to download. By default, Google and other search engines show 10 results per page. Here’s how to change those settings:
Change results per page settings
Step 1: Search anything on Google. Find the settings option, which is located at the top middle bar, right below the search box.
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 that you want to be displayed and download.
Step 4: Now go back to your search result page. Search anything that you want to download from search results. Wait for at least 5 seconds to completely load the search results page. Now click on this option from left-hand corner Export CSV.
That’s it! Your CSV file will be downloaded on your computer.
Download Search Results to Excel Spreadsheet in Mozilla Firefox
Step 1: You need to first install the SEOquake firefox extension in your Firefox browser. After the successful extension install, follow these steps: Look for the SQ icon at the top right corner of your browser.
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, 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 URLs of the search results, then uncheck all the boxes.
Step 4: Please see this part above how to configure search results per page. After configuring search results per page, you can download your results now. Search anything that you want to download from search results. Find this option in the left corner of your search results page “Export CSV”. Now click on the Export CSV button.
After doing that, your list of 100 search results will be downloaded in an excel spreadsheet on your computer.
You can upload this CSV file to Google Drive, Google Sheets, or any other cloud storage which is 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 lots of useful tools such as Google Search Console, Google Drive, Google Sheets, Google Docs, and many more.
When you have created an account, you can upload your CSV file to Google Drive.
Go to your Google Drive account and look for the ‘New’ Button at the top left corner. By clicking on this button you will find an option ‘File Upload’.
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
Someone asked in the comments how they can export Google Maps search results into a CSV file. At that time, I wasn’t aware of the tool to extract that information.
However, recently I found out 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 keywords that you would like to search and download.
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.