In this article you will learn how how to use any text model from Excel.

In this articule we use Excel online but you can follow the same process using a desktop version of Excel on Mac or Windows.

First create a new blank book, go to Insert and click on Add-ins:

Add Add-in

Then go to the Office store and search for the Script Lab Add-in and click Add:

Install Script Lab add-in

Before importing the snippet to use it from the Scrip Lab, we need to copy Cogniflow YAML file from here

Click on Copy raw contents like this:

Copy YAML content

Then go back to Excel:

Click Import
Paste the content we just copied by right clicking and then Paste or using the shortcut Cmd + V or Control + V, and finally click the Import button.

Import YAML

Click Trust and then Run to start the Cogniflow Add-in.

Trust and Run snippet

Now you should see the login screen to access Cogniflow:

Excel Add-in login

Once authenticated you will see your Text Experiments. Please change to see the public experiments and then select the Sentiment Analysis model:

Select public experiments

Click Sentiment Analysis

Now please change the option to Replace values:

Select Replace values

Finally, add some texts to the sheet to classify them using the model and press Run model:

Well done! Now you can try some other text models like Emotion Detection or any of your custom text models. To learn how to create your own text models please check this tutorial
Was this article helpful?
Thank you!