Access Watson Natural Language in Excel

Data results output in Excel

Take your understanding of unstructured data to a whole new level with a full suite of advanced text analytics features to extract entities, relationships, keywords, semantic roles and more.


Returns important keywords in the content. Available metrics:

  • Keyword
  • Relevance Score
  • Count (occurances of keyword)
  • Sentiment label (Positive, neutral or negative)
  • Sentiment Score
  • Emotion Scores (Sadness, Joy, Fear, Disgust and Anger)


Returns high-level concepts in the content.For example, a research paper about deep learning might return the concept, "Artificial Intelligence" although the term is not mentioned.


Detects anger, disgust, fear, joy, or sadness that is conveyed in the content or by the context around target phrases specified in the targets parameter. Available options:

  • Targets - Emotion results are returned for each target string found in the document. Enter one target per newline. Leave empty to return emotions for the entire text. Remember to select the Target Field when including Targets: Field Selection


Analyzes the general sentiment of your content or the sentiment toward specific target phrases. Available options: Targets (see above)


Identifies people, cities, organizations, and other other entities in the content. Available metrics:

  • Keyword
  • Type
  • SubTypes (comma-separated list)
  • Relevance Score
  • Count (occurances of keyword)
  • Sentiment label (Positive, neutral or negative)
  • Sentiment Score
  • Emotion Scores (Sadness, Joy, Fear, Disgust and Anger)


Returns a five-level taxonomy of the content. The top three categories are returned.


Recognizes when two entities are related and identifies the type of relation. See this page for a list of relations. Available metrics:

  • Sentence
  • Type
  • Score (comma-separated list)
  • First Argument
  • Second Argument


Add from Manager

The IBM Watson Connector is available in the Connectors Manager in the top ribbon:
Manager position in main ribbon

Head over to the AI Category and install IBM Watson:
Connector category in Manager window

API Credentials

To use the IBM Watson Connector you need an API Key and specify a valid Base URL.

  1. If you don't have an existing IBM Cloud account, Sign-up here.

  2. Go to the Natural Language Understanding page, chose a region and click the Create button in the bottom right corner.

  3. Next, go to the Resources page, expand the Services row and click on the Service you just created in step 2.

  4. Click "Show Credentials" and copy the API key.

  5. Paste the key in the Settings form in the IBM Watson task-pane inside Seotools. Also select the Location you've used when creating the Resource:
    Paste credentials in Excel


This connector suite is open-sourced on GitHub.


Official Documentation

Related Functions


Get help with this function in the community →