Report a bug

Cancel
3391   30  
News 4 min read December 29, 2016
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.
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.
Learn how to get the most out of Serpstat
Want to get a personal demo, trial period or bunch of successful use cases?
Send a request and our expert will contact you ;)
Found an error? Select it and press Ctrl + Enter to tell us

Recommended articles

Subscribe to our newsletter
Keep up to date with our latest news, events and blog posts!

Comments

Sign In Free Sign Up

You’ve reached your query limit.

Or email
Forgot password?
Or email
By clicking 'Sign Up Free' I agree to Serptat's
Terms of Service and Privacy Policy
Back To Login

Don’t worry! Just fill in your email and we’ll send over your password.

Are you sure?
Please pick the project to work on

Personal demonstration

Serpstat is all about saving time, and we want to save yours! One of our specialists will contact you and discuss options going forward. These may include a personal demonstration, a trial period, comprehensive training articles & webinar recordings, and custom adivce from a Serpstat specialist. It is our goal to make you feel comfortable while using Serpstat.

Name
Email
Phone
Skype or Google Hangouts
Comment

Upgrade your plan

Sign Up Free

Спасибо, мы с вами свяжемся в ближайшее время

Invite
E-mail
Role
Message
Optional

You have run out of limits

You have reached the limit for the number of created projects. You cannot create new projects unless you increase the limits or delete existing projects.

I want more limits

Christmas is a time for miracles.

You are almost on the finish line of our Christmas quest. The last brick of your lego-promocode is left on the way up 55% discount.

Did not find previous lego-bricks? Fill the form anyway.

Name
Email
Phone
Skype or Google Hangouts
Write your discount code