We recently announced a new version of Excel add-in which lets you perform state-of-the-art text analysis capabilities from the comforts of your spreadsheets without writing a single line of code. The add-in has been received very well by users working across different industry verticals like Market Research, Software, Consumer Goods, Education, etc. solving a variety of use-cases.
Emotion Detection has been the second most used function of our Excel add-in preceded by Sentiment Analysis. Many of our users use Emotion Detection to optimize their marketing and customer feedback efforts by reading an online conversation about their products/services.
In this blog post, we will discuss how to use Emotion Detection function in Excel add-in to do text analytics for any type of content.
First, we will give you a brief introduction to the underlying technology driving our emotion detection engine.
Our emotion detection system uses Deep Learning powered algorithms to extract features from the textual data. These features are used to classify the emotion attached to the data. We have trained our classifier using Convolutional Neural Networks (Convnets) on a tagged dataset created by our team. We have also trained this algorithm on custom datasets for different clients as part of our enterprise offering.
Using Emotion Detection in Excel add-in
To get started, you need to first sign-up for a free ParallelDots account (if you haven’t already) and download and install the Excel add-in on your computer. Once you install it, follow the steps below to use Emotion Detection in Excel:
- Login to your ParallelDots Excel add-in account: Enter your login credentials to activate the add-in’s functions.
- Use the ParallelDots Excel add-in Emotion Detection function:
Using the function paralleldots_emotion you can analyze any textual content and in return get the emotion’s attached to the text. Consider the following example where the text sentence “I am trying to imagine you with a personality.” is being analyzed using paralleldots_emotion. as shown in the GIF below:
In case, you need to know the probability of emotion label returned by paralleldots_emotion function discussed above, you can do so by invoking function paralleldots_emotion_<emotion_label>_probability where emotion_label can be sad, fear, angry, bored, happy, excited, and sarcasm.
Emotion Detection API can accurately detect the emotion from any textual data. People voice their opinion, feedback, and reviews on social media, blogs and forums. Marketers and customer support can leverage the power of Emotion Detection to read and analyze emotions attached with the textual data.
Emotion Detection API can also be used in 15 different languages using the Excel add-in function paralleldots_emotion(Cell_Number, “lang_code”) as shown in the example below:
We hope this post will help you to use Emotion Detection in excel using ParallelDots Excel add-in and start your text analytics journey. Please write to us at [email protected] in case of any queries or feedback.
Click here to know more about ParallelDots Excel add-in function.
If you haven’t downloaded the add-in yet, then please download it now for free from here.