13510
Serpstat updates 4 min read October 23, 2018

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

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

Victor Sandberg
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.
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

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:
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":
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:
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:
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:
3. Next, go to your Serpstat Profile page and copy your API token:
4. Finally, paste your API-key in the "Options" menu:

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 3 people on average 4 out of 5
Found an error? Select it and press Ctrl + Enter to tell us

Share this article with your friends

Are you sure?

Introducing Serpstat

Find out about the main features of the service in a convenient way for you!

Please send a request, and our specialist will offer you education options: a personal demonstration, a trial period, or materials for self-study and increasing expertise — everything for a comfortable start to work with Serpstat.

Name

Email

Phone

We are glad of your comment
I agree to Serpstat`s Privacy Policy.

Thank you, we have saved your new mailing settings.

Report a bug

Cancel
Open support chat
mail pocket flipboard Messenger telegramm