Microsoft Excel seoClarity Add-in (Plugin)

Microsoft Excel seoClarity Add-in (Plugin)

Overview
The seoClarity Excel Add-in allows you to import seoClarity data from three of the most popular sources in our platform directly into an Excel workbook.

Background & Requirements

Download the seoClarity Excel plugin from the Microsoft Office Add-ins store and use your personal seoClarity API key available via the Integrations tab on the Settings page.

Installation and Setup

1) Open a new or existing Excel Workbook. On  the Insert tab, click Add-ins and then Get Add-ins. (NOTE: 
the Add-ins button may be in a different location on Insert ribbon than shown below.)




2) In the Office Ad-ins store, search for "seoClarity" and then click Add next to our add-in. Review our license terms and privacy policy, the click Continue to install the add-on.



3) The seoClarity for Excel add-on will now appear on the Home ribbon of Excel. (You can also access it via Insert > My Add-ins.) Click the button to load the add-on into a sidebar of your workbook.



4) Log in to the seoClarity app, and in Settings go to the Integrations tab and find the API Access section. Click there and copy your personal API key. (If you do not have access to an API key, talk to your account's administrator.)

5) Back in Excel, paste your API key where indicated in the Add-in. You can also add your API Key any time via the setup (gear) icon in the Add-in.

Using the seoClarity Excel 

Open the seoClarity Excel Add-in by clicking on its button on the Home ribbon (see third screenshot above). Under "Data Sources" choose from one of these available sources:
  1. Tag Ranking Summary
  2. Keyword Ranking
  3. Site Health Summary
Click "Create New Query" to setup parameters for your data download.



Tag Ranking Summary Query Setup
The Tag Ranking Summary data source allows you to import ranking data for any keyword tag or group of tags, with results summarized at the tag level.



  1. Give your query a name that will help you identify it later. Query setups can be saved and accessed again.
  2. In the Choose Keyword Tags window, select the tag or tags you want to include in the query. Select multiple tags using CTRL-click (or choose a range by selecting the first tag, then Shift-clicking on the final tag).
  3. Choose the search engine to use for this query.
 
  1. Choose between fixed and relative dates. Fixed creates a query that will always draw from the start and end dates entered. Relative allows you to select from between two and seven days before the date the query is run.
  2. Enter the domain for this query.
  3. Choose whether you want to use Average Rank (default) or True Rank (toggle the switch to  On). 
  4. Choose from available Geo locations.
  5. Choose which data fields to include in your data import. Use CTRL-click to select multiple fields.
  6. Click Create to save and initialize your query.
Imported data will be inserted into the current worksheet at the currently highlighted cell.

Keyword Ranking Query Setup
The Keyword Ranking data source allows you to import ranking data for any set of keywords.


  1. Give your query a name that will help you identify it later. Query setups can be saved and accessed again.
  2. In the Choose Keyword Tags window, select the tag or tags you want to include in the query. Select multiple tags using CTRL-click (or choose a range by selecting the first tag, then Shift-clicking on the final tag).
  3. Choose the search engine to use for this query.
  4. Choose the ranking frequency you want (day, week or month).


  1. Choose between fixed and relative dates. Fixed creates a query that will always draw from the start and end dates entered. Relative allows you to select from between two and seven days before the date the query is run.
  2. Enter the domain for this query.
  3. Choose whether to include 101 (i.e. non-ranking keywords, those in positions 101 or lower)
  4. Choose whether you want to use Average Rank (default) or True Rank (toggle the switch to  On). 
  5. Choose which data fields to include in your data import. Use CTRL-click to select multiple fields.
  6. Click Create to save and initialize your query.
Imported data will be inserted into the current worksheet at the currently highlighted cell.

Site Health Summary Query Setup
The Site Health Summary data source allows you to import site audit data from any crawl project you've run on seoClarity.



  1. Give your query a name that will help you identify it later. Query setups can be saved and accessed again.
  2. Choose a crawl project. 
  3. Choose the data fields you want included in your import. 
  4. Click Create to save and initialize your query.
    5. Imported data will be inserted into the current worksheet at the currently highlighted cell.

Accessing Saved Queries

Any queries you've saved can be accessed and run again and/or edited in the same Workbook in which they were created. To access saved queries, first select the Data Source. Then any queries you've previously created and saved for that source in that Workbook will appear.


Each listed saved query has three options:
  1. Refresh data (rotation icon): rerun this query with fresh data according to the parameters previously set. 
  2. Delete: Delete this saved query from the list.
  3. Edit: Change any of the previously saved parameters.


    • Related Articles

    • Microsoft Word Content Fusion Plugin

      Microsoft Word Content Fusion Plugin Overview Our Content Fusion plugin for Microsoft Word is available at Microsoft Appsource. It enables everyone on your team to write authoritative, high quality content that ranks, from right inside Word. ...

    • How to Install & Use the seoClarity Google Sheets Add-on (Plugin)

      How to Install & Use the seoClarity Google Sheets Add-on (Plugin) <br>

    • Why can't I add a tag to a keyword?

      When adding keywords in the platform, a keyword and tag are linked when separated by a tab. If your keyword already has a tab, the system sees it as having an existing tag association. Because of this, the platform won’t let you add another tag to ...

    • What Should I Do If I Can't Add Keywords for Rank Tracking?

      If you're unable to add keywords, it's likely because your current access is set to read-only. Here’s how you can update your permissions: Contact an Admin User: Reach out to someone in your organization with admin access. They can update your ...

    • Microsoft PowerBI Integration

      Overview This integration enables the embedding of Microsoft PowerBI widgets into seoClarity dashboards Background & Requirements A Microsoft PowerBI account is required. Intended viewers of a PowerBI report embedded in an seoClarity Dashboard must ...