How to Do Sentiment Analysis in Excel Without Writing Code?

sentiment analysis

ParallelDots Excel Add-in provides 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 our users working across different industry verticals like Market Research, Software, Consumer Goods, Education, etc. solving a variety of use-cases.

Sentiment Analysis has been the most used function of our Excel add-in closely followed by Emotion detection. Many of our users use sentiment analysis in Excel to quickly and accurately analyze the responses of their open-ended surveys, online feedback on their product/service, or to analyze product reviews from e-commerce sites.

In this blog post, we will discuss how to use ParallelDots Sentiment Analysis in Excel Add-in to do text analytics for any type of content without writing any code.

But firstly, a brief introduction to the underlying technology driving our Sentiment Analysis API.

Our Sentiment Analysis ‘model’ uses Long Short-Term Memory (LSTM) algorithms to classify open-ended texts’ sentiment into positive, negative, or neutral. LSTMs model sentences as a chain of forget-remember decisions based on context. It is trained on user-generated content taken from different social media websites and news articles both to handle casual and formal language.

Using Sentiment Analysis in ParallelDots Excel Add-in

To get started, you need to first sign-up for a 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 Sentiment Analysis in Excel:

  1. Login to your ParallelDots Excel Add-in account: Enter your login credentials to activate the add-in’s functions.
  2. Use the excel add-in sentiment analysis function:

Using the function paralleldots_sentiment you can analyze any textual content and in return get the sentiment attached to the text. Consider the following example where the text sentence “This is a delicious cake.” is analyzed using paralleldots_sentiment, as shown in the image below.

sentiment analysis

Once you press enter, the function gives the sentiment of the text.

sentiment analysis

Our APIs can be used in 15 different languages using the Excel add-in function paralleldots_sentiment(Cell_Number, “lang_code”).

Sentiment Analysis is a quick and effective way to determine the mood of your users and take appropriate action based on it. Often, it is the first step in the journey to make data-driven decisions to improve your product or services. You should use it in combination with the keyword extraction function to find the key factors contributing to the overall sentiment of your data.

You can read more about the use-cases of Excel Add-in here.

We hope this post will help you to use sentiment analysis in excel using ParallelDots add-in and start your text analytics journey.

If you haven’t downloaded the add-in yet, then please download it now for free from here

Please Sign Up for a free ParallelDots account to start your AI journey. You can also check demo’s of ParallelDots AI APIs here.

Please write to us at support@paralleldots.com in case of any queries or feedback.

One Reply to “How to Do Sentiment Analysis in Excel Without Writing Code?”

Leave a Reply