Over a million developers have joined DZone.

How to Perform Sentiment Analysis in Excel Without Writing Code

DZone's Guide to

How to Perform Sentiment Analysis in Excel Without Writing Code

Sentiment analysis is a quick and effective way to gauge the mood of your users. Learn how to use sentiment analysis function with Excel add to do text analytics.

· AI Zone ·
Free Resource

Insight for I&O leaders on deploying AIOps platforms to enhance performance monitoring today. Read the Guide.

We recently announced a new version of our 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.

Image title

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 chatter around their product/service, or to analyze product reviews from e-commerce sites.

In this post, we will discuss how to use the sentiment analysis function in the 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 sentiment engine.

Our sentiment analysis model uses long short-term memory (LSTM) algorithms to classify a text blob’s sentiment into positive and negative. 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. We have also trained this algorithm on custom datasets for different clients as part of our enterprise offering.

Using Sentiment Analysis in the 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. Log into your ParallelDots Excel add-in account: Enter your login credentials to activate the add-in’s functions.

sentiment analysis in excel

  1. 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 “Team performed well overall.” is being analyzed using paralleldots_sentiment, as shown in the GIF below:

If you need to know the probability of the sentiment label returned by the paralleldots_sentiment function discussed above, you can do so by invoking function paralleldots_sentiment_<sentiment_label>_probability where sentiment_labelcan be neutral, positive, or negative.

Sentiment analysis is a quick and effective way to gauge 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 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 the Excel add-in here.

TrueSight is an AIOps platform, powered by machine learning and analytics, that elevates IT operations to address multi-cloud complexity and the speed of digital transformation.

text analysis ,sentiment analysis ,ai ,data analytics ,excel ,tutorial

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}