• Help Center
enEnglish
  • enEnglish
  • ruРусский
  • jpJapan
  • esEspañol
  • frFrançais
  • Why SE Ranking
    • column
      • Scalable solution
        • for Enterprises
        • for Agencies
        • for SMBs
        • for Enterpreneurs
    • column
      • Trusted by users
        • Case Studies
        • Testimonials
        • Our Data
    • All-in-one SEO platform
  • Features
    • column
      • Featured tools
        • Keyword Rank Tracker
        • On-Page SEO Checker
        • Website Audit
        • Competitor Analysis Tool
        • Backlink Checker
        • Local Marketing Tool
    • column
      • Keyword research
        • Keyword Suggestion Tool
        • Keyword Grouper
      • Content Marketing
        • Content Marketing Tool
        • Content Editor
    • column
      • Other seo tools
        • Backlink Tracking Tool
        • SERP Checker
      • Tools for agencies
        • SEO Reporting Tools
        • Lead Generator
        • API
    • All features
  • Plans & pricing
  • Resources
    • column
      • Blog

        Read our comprehensive guides, case studies, interviews with experts and more

      • Webinars

        Discover a collection of videos on burning SEO topics featuring industry experts

      • Academy

        Broaden your SEO expertise by joining online courses created by seasoned SEO specialists

    • column
      • What’s New?

        New features, improvements and updates all in one place so you can make the most out of SE Ranking

      • On-Page Seo Guide

        Everything you need to know about on-page SEO in 2023 and beyond

      • two link in one
        • US Agencies

          Check out our list of top-performing SEO agencies by organic traffic and analyze their digital performance

        • UK Agencies
    • column
      • Backlink Monitoring guide

        Boost your link building strategy by putting this guide's best practices to work Get your free ebook

Sign inFree trial
Log out Projects

SeoTools for Excel Integration Guide

  • Bitrix24 Integration Guide
  • Zapier Integration Guide
  • SeoTools for Excel Integration Guide
  • Reportz Integration Guide
Home / Knowledge Base / Integrations / SeoTools for Excel Integration Guide

SeoTools for Excel Integration Guide

SeoTools for Excel is a plugin that adds a bunch of useful SEO-related functions and other web metrics directly to Excel.

We’ve paired SE Ranking up with SeoTools for Excel to help you closer analyze your sites, competitors and keyword statistics in Excel. Data is transferred through the SE Ranking API. The API is available in the free trial account and the Enterprise plan.

Note that SeoTools works with Excel & Windows only. It doesn’t function on Mac or Linux, Google Docs or OpenOffice.

Integration process

1. Download the latest version of SeoTools for Excel here and set it up. You can find more details on how to install the plugin here. Once SeoTools is installed, a new tab will appear in the Excel layout. Don’t worry if your Excel spreadsheet doesn’t look like the provided example.

2. Go to the Connectors Manager in the top bar where the SE Ranking Connector is located.

3. Head over to the SEO category and install SE Ranking.

4. To connect SeoTools with your SE Ranking account, click “Setting” in the task panel and enter your login credentials.

5. Select the type of data to extract.

The SE Ranking Connector, located in the SEO category, consists of several views that are adjusted for the type of data you want to extract. Let’s say you need statistics on keywords for one domain. Selecting the “Keywords Positions” view presents you with additional parameters and sorting alternatives:

The inputs marked in red represent 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 data in columns A and onwards.

6. 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 the option to save and load “Configurations”:

Next time, just load a previous configuration and you will get statistics based on the same settings as last time.

As you can see, Id numbers represent most inputs. You don’t need to write down or remember these, simply use the “Select” buttons to choose from a list of all available items:

7. Use the Formula Mode.
The beauty of combining SE Ranking with Excel lies is the ability to create large numbers of requests automatically. Instead of populating the cells with values, select “Formula” before adding the results by clicking “Insert”:

Next, you can change the formula to reference a cell and SeoTools will generate results based on the value or text in that cell. In the following example, we’ve chosen to extract the search volume for the list of keywords in column A:

Just drag the formula down and SeoTools will generate the statistics for all keywords. As you can see in the example above, the “180” parameter represents the Search Engine Id. This can also be changed to cell references which means you can extract the volume based on combined lists of keywords and locations. The formulas can be combined with other native Excel functions, as well as SeoTools functions, such as Regex and Dump.

Complete documentation of the SE Ranking Connector features can be found here.

    Integrations
  • Google Data Studio Integration Guide
    • How to connect SE Ranking data sources to view data in Google Data Studio
    • Bitrix24 Integration Guide
    • Zapier Integration Guide
    • SeoTools for Excel Integration Guide
    • Reportz Integration Guide
SE Ranking logo
enEnglish
  • enEnglish
  • ruРусский
  • jpJapan
  • esEspañol
  • frFrançais
Mobile Apps:
Awards:
Capterra Best Value 2022 Leader Spring 2023
© 2023 SE Ranking Limited. All rights reserved
SE RANKING
  • About
  • What’s new
  • Contact
  • Help
  • Ask a question
  • Webinars
  • Academy
  • Schedule live demo
  • Competitors
  • Blog
  • Affiliates
  • Partners’ bonuses
  • Terms of use
  • Privacy policy
FEATURES
  • Keyword Rank Tracker
  • Website Audit
  • Backlink Monitor
  • On-Page Checker
  • SERP Checker
  • Marketing plan
  • Keyword Grouper
  • Keyword Research & Suggestions Tool
  • Competitive Research
  • Backlink checker
  • Local Marketing Tool
  • Lead Generator
  • SEO Reporting Tools
  • Page Changes Monitoring
  • White Label
  • API
  • Social media tool
  • Free SEO tools
GET IN TOUCH

228 Hamilton Avenue, Palo Alto, California, 94301

+1 415 704 4387

15 Ingestre Place,
London, UK W1F 0DU

+44 20 3868 1173
© 2019 SE Ranking Limited. All rights reserved