Access Microsoft Text Analytics in Excel

Data results output in Excel


Returns a numeric score between 0 and 1.


Returns a list of recognized entities in a given document. English only.

Key Phrases

Returns a list of strings denoting the key talking points in the input text.

Detect Language

Returns the detected language and a numeric score between 0 and 1.


Add from Manager

The Microsoft Text Analytics Connector is available in the Connectors Manager in the top ribbon:
Manager position in main ribbon

Head over to the AI Category and install Microsoft Text Analytics:
Connector category in Manager window

Get Access key

To use the Microsoft Text Analytics Connector you need an Access Key. Remember to select the same Location as the one you chose during the registration process: Paste credentials in Excel


This connector suite is open-sourced on GitHub.


Official Documentation

Related Functions


Get help with this function in the community →