Our Excel Add-in provides state-of-the-art text analysis capabilities without writing a single line of code. The add-in also comes in handy when you need to run text analysis in batches on a large corpus of text and discover insights in them (such as user-generated content from social media campaigns, earnings call transcripts, open-ended user feedback etc.). You can export all your data from any BI tool you use in xlsx (or CSV format) and install our plugin to annotate the data with sentiment, emotions, intent etc. and analyze them from the comfort of your spreadsheet. In this post, we will show you how to use our Excel Add-in to add an important tool to your text analytics and text mining capabilities. Installing and using the Add-in Before starting with the Excel add-in you need to for a free ParallelDots AI APIs account. Upon filling the form on our website and verifying your email, you will receive an API key in your inbox. Please store the API key in a secure location as unauthorized access to your API keys will result in early exhaustion of your quota. In case you feel you have lost your API key or someone else might have access to it, please drop an email to and we will immediately invalidate your old API key and generate a new one for you. sign up support@paralleldots.com Upon receiving the API key, the Excel add-in and follow the on-screen instructions to install the add-in. Upon successful installation of the add-in, your excel screen should have a ParallelDots button in the top navigation bar as shown below: download Upon clicking the Show/Hide Pane, you can toggle the settings screen to activate your add-in account. Enter the API key generated in the previous step in the Task Pane, and click submit to start analyzing your data. That’s it, now you can bring any type of unstructured textual content and analyze with our add-in. In the next section, we will explain the different functions available in the add-in to perform different types of text analytics. Text Analytics Functions Our excel add-in lets you access the following APIs: Sentiment Analysis Sentiment Analysis using Excel can be accessed by invoking function as shown in the screenshot below: paralledots_sentiment In case, you need to know the probability of sentiment label returned by function above, you can do so by invoking function where sentiment_label can be neutral, positive or negative. paralleldots_sentiment paralleldots_sentiment_<sentiment_label>_probability Details of Sentiment Analysis API can be found . here Multilingual Sentiment Analysis Our Sentiment Analysis algorithm also supports three other languages apart from English, namely Spanish, Portuguese and Chinese. Analysis for these languages can be invoked by calling the functions respectively. Their confidence scores can be also be retrieved by appending “_confidence” at the end of each language’s function as shown in the screenshot below: paralleldots_multilang_es, paralleldots_multilang_pt and paralleldots_multilang_cn Keywords Extraction Can be invoked by calling function. Returns a list of important keywords in the input text. Details of this function can be found . paralleldots_keywords here Text Classification Can be invoked by calling function. Returns a list of probable categories that the text can belong to. More details on this function can be found . paralleldots_taxonomy here Entity Extraction Can be invoked by calling or to extract organization name or person or place respectively. paralleldots_ner_organization, paralleldots_ner_person paralleldots_ner_place More details on this function are available . here Semantic Analysis Can be invoked by calling . The output is a score between 0–5 where score close to 5 indicates the two sentences are very close in meaning (semantically similar) while scores closer to 0 indicate the two sentences are very disparate in meaning. paralleldots_similarity Note that in order to use this function, you need to run it on two sentences, more details and use-cases can be found . here Emotion Analysis Can be invoked by calling paralleldots_emotion to get the emotion label and to find the probability score for different emotions as shown in the screenshot below: paralleldots_emotion_<label>_probability More details on emotion function is available . here Intent Analysis Can be invoked by calling paralleldots_intent to find the intent of the input text and paralleldots_intent_<label>_probability to find the probability scores of the different intent labels available. More details on Intent function is available . here Abusive Content Classifier Can be invoked by calling to classify input texts as abusive or not. Confidence score (probability score) can be found by calling . paralledots_abuse paralleldots_abuse_confidence More details are available . here Security and Privacy Excel add-in is built on our APIs which means that your data is processed on our servers to get the final output. We take user privacy very seriously at ParallelDots and our privacy policy can be accessed . All the user data is stored according to our privacy policy ensuring high standards of security. here However, in some cases due to contractual obligations or otherwise, the user may want to keep the data in-house in which case we can deploy these algorithms on-premise and build the plugin accordingly. Please to deploy these APIs on-premise and any custom function that you want us to build. send us a request Excel add-in can be a powerful and cost-effective way to start adding cutting-edge intelligence to your analytics. Our excel add-in lets you analyze 100 sentences for each function every day for free without giving your credit card details. We hope this will allow you to understand the different functions provided in the add-in and understand the use-case before upgrading to one of our paid plans for large-scale usage. Please write to us at apis@paralleldots.com in case of any queries or feedback. , is a Deep Learning powered web service by , that can comprehend a huge amount of unstructured text and visual content to empower your products. You can check out some of our and reach out to us by filling this form or write to us at apis@paralleldots.com. ParallelDots AI APIs ParallelDots Inc text analysis APIs here
