Text Classification in Excel without writing code

text classification


Text Classification can be useful in understanding customer behavior by categorizing conversations on social networks, feedback, and other web sources. Search engines, newspapers, or e-commerce portals categorize their content or products to facilitate the search and navigation.

In this blog post, we will discuss how to use Text Classification 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 Text Classification engine.

We utilize a comprehensive list of taxonomy to categorize the text content or web page contents into definitive tags. Text Classification might involve different types of datasets and we have solutions for all the variations. A client might have datasets that are:

1. Untagged datasets, to be classified into generic categories. We have our API for classifying sentences/articles into standard IAB categories.

2. Tagged Datasets with multiple categories. This type of classifier can classify text into 10s and 100s of user-defined categories like E-commerce product categories.

3. Partially tagged datasets, where only some of the data is tagged with categories and a lot of untagged data is available. Such classifiers are used to do intent analysis.

4. Chat Lingo and shorthand text classification – For such classification, where words are shortened and are not grammatically accurate, we use character level embeddings and hence can get around users’ tendency to shorthand text.

We have also trained this algorithm on custom datasets for different clients as part of our enterprise offering.

Using Text Classification in 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 Text Classification in Excel:

  1. Login to your ParallelDots Excel add-in account: Enter your login credentials to activate the add-in’s functions.text classification
  2. Use the function Text Classification in Excel:

Using the function paralleldots_taxonomy you can analyze any textual content and in return get the categories to a text.

Consider the following example where text input “Under the Uruguay Round, the national governments of all the member countries have negotiated improved access to the markets of the member countries so as to enable business enterprises to convert trade concessions into new business opportunities.” are assigned the relevant categories using the Text Classification API as shown in the GIF below:

Text Classification API is a very important tool for categorization of data sets on a large scale. Text Classification assigns one or more categories to a text, allowing to structure data for better insights. We utilize a comprehensive list of taxonomy to categorize the text content or web page contents into definitive tags.

Read here how to use Named Entity Recognition API in Excel without writing code.

We hope this post will help you to use Text Classification in excel using ParallelDots Excel add-in and start your text analytics journey. Please write to us at support@paralleldots.com in case of any queries or feedback.

Click here to know more about ParallelDots Excel add-in functions.

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

If you use an operating system other then Windows then please try our Google Sheets add-on which works the same way as our Excel add-in. You can read more about it here.

We hope you liked the article. Please Sign Up for a free ParallelDots account to start your AI journey. You can also check demo’s of PrallelDots AI APIs here.

Leave a Reply