We use cookies to make Serpstat better. By clicking "Accept cookies", you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Learn more

Report a bug

Cancel
7287 4
Serpstat updates 4 min read
Victor Sandberg

Do You Like Spreadsheets? Because We've Integrated Serpstat into SeoTools for Excel and Made Them Both Better

Partner & Developer, SeoTools for Excel
Did you know there's a way to get up to speed with the latest Serpstat statistics without having to leave Excel? We have paired up with SeoTools for Excel, a Swiss army knife Excel-plugin, which offers a tailored "Connector" for all Serpstat users.

In this blog post, we will show how SeoTools allows you to extract keywords, domains, and URL statistics of your choice, filtering and sorting the results, and having it ready for analysis in Excel in a matter of seconds.
Do You Like Spreadsheets? Because We've Integrated Serpstat into SeoTools for Excel and Made Them Both Better 16261788071164
Don't be worried if your Excel spreadsheet doesn't look as the example above. The extra ribbon tab "SeoTools" is added when SeoTools for Excel is installed. At the end of this post you find all the links necessary to setup your Serpstat account.

Selecting the data to extract

Do You Like Spreadsheets? Because We've Integrated Serpstat into SeoTools for Excel and Made Them Both Better 16261788071165
The Serpstat Connector consists of several sub categories that are adjusted for the type of data you want to extract. Let's say you need statistics of keywords for a domain. Selecting the "Domain Keywords" category presents you with additional filters and sorting alternatives:
Do You Like Spreadsheets? Because We've Integrated Serpstat into SeoTools for Excel and Made Them Both Better 16261788071165
It is necessary to choose a visual aid that is appropriate for the material and audience.






The inputs marked in red represents filtering options to limit the data according to your preferences.








The checkboxes marked in blue are the values you want to extract based on the filters. When you are satisfied with your settings, click "Insert", and SeoTools will generate the data in columns A and onwards.

Save time and automate the process

Exporting and filtering Excel data from web based platforms takes time, especially if it's required on a daily or weekly basis. The filtering part of standardized files is also associated with human error. SeoTools solves this with saving and loading of "Configurations":
Do You Like Spreadsheets? Because We've Integrated Serpstat into SeoTools for Excel and Made Them Both Better 16261788071166
Next time, just load a previous configuration and you will get statistics based on the same settings as last time.

Use Formula Mode to super charge your analysis

The beauty of combining Serpstat with Excel is the ability to create large numbers of requests automatically. Instead of populating the cells with values, select "Formula" before Inserting the results:
Do You Like Spreadsheets? Because We've Integrated Serpstat into SeoTools for Excel and Made Them Both Better 16261788071166
Next, you can change the formula to reference a cell and the Serpstat Connector will generate results based on the value or text in that cell. In the following example, we've chosen to extract keyword metrics for the list of keywords in column A:
Do You Like Spreadsheets? Because We've Integrated Serpstat into SeoTools for Excel and Made Them Both Better 16261788071167
Just drag the formula down and SeoTools will generate statistics for all keywords.

Do you want to try it on with your Serpstat account?

1. Sign up for a 14-day Trial and follow the instructions to download and install the latest version of SeoTools.

2. Register your access key under "Upgrade to Pro" and access Serpstat in the Connectors menu:
Do You Like Spreadsheets? Because We've Integrated Serpstat into SeoTools for Excel and Made Them Both Better 16261788071167
3. Next, go to your Serpstat Profile page and copy your API token:
Do You Like Spreadsheets? Because We've Integrated Serpstat into SeoTools for Excel and Made Them Both Better 16261788071168
4. Finally, paste your API-key in the "Options" menu:

Do You Like Spreadsheets? Because We've Integrated Serpstat into SeoTools for Excel and Made Them Both Better 16261788071169
The complete documentation of the Serpstat Connector features can be found here.

If you have any questions, feedback, or suggestions about ways to improve the Connector, please contact victor@seotoolsforexcel.com.

Rate the article on a five-point scale

The article has already been rated by 2 people on average 5 out of 5
Found an error? Select it and press Ctrl + Enter to tell us