“How do I import survey data into Excel,” you ask? With Semantria for Excel, you login to your Survey Monkey account directly in Excel, and import your data for analysis. You also choose which data columns to import, so you only analyze what you want. It’s a huge timesaver, especially if you have multiple open-endeds or tons of responses.
"What about company or product reviews?” You login to your Socialgist account, also in Excel, and import your data for analysis. Does it sound easy? That’s because it IS.
Semantria for Excel 5.1 also has connectors to SPSS and Triple-S, which are industry standards for survey information. Don’t worry about dealing with pesky formats, we take care of that for you.
This means we’ll also be able to connect to other services in the future. Just saying.
For the first time, users can now analyze both text and NPS scores, and combine the two in output charts. By combining quantitative NPS data, with qualitative text data, you’ll be able to create reports that outclass anything your competition has. Numbers and letters traditionally don’t mix, but we make sure they do.
If you have disparate data sources, many analysts, multiple projects and file types, you’d normally be looking at a budget overload and project meltdown. Don’t worry though, we’ve got you covered.
Our Excel subscriptions are sold in multi-seat packages, so you can get access to as many Semantria for Excel seats as you need. Just talk to us and we’ll get a custom package going for you.
Sentiment analysis identifies the positive, negative or neutral tones embedded in your content to better understand your market position. By attaching sentiment scores to each theme, entity, and category, our sentiment analysis tools uncover how people feel about your brand, products, and services, and why they feel that way.
It's easy to perform text analysis in Excel as Semantria for Excel provides fast and accurate categorization of your input content. With just a quick glance, you'll know the subjects of discussion — whether that's general topics like “politics” or “banking”, search queries searching for specific items, or your own machine-learning based classification.
Every feature in Semantria for Excel is customizable: categorization, context determination, entity extraction, and sentiment analysis all respond to user feedback and tweaking. We even include a “short-form content” mode, specifically optimized for social media and other small sentences (like Twitter content).
Semantria for Excel is uniquely applicable to all industries around the globe. We support 22 languages, including English, Italian, Japanese, and German. No matter your industry and your demographics, you'll benefit from applying Lexalytics text mining tools.
Automatically extract people, places, companies, brands, @mentions, #hashtags, job titles from your content to see who's hot and who's not. You can create custom entities as well, tailored to your specific market or interests. Each extracted entity comes with a sentiment score to provide deeper insight into the tone of discussion. Tuning is a snap – just tell us who you want us to track, we'll also automatically show you what we discover so that you can tell when a company or person has made a move, even when you didn't know to look for it.
Use the Excel visualization tools you're already familiar with to create rich charts and graphs: all of our results are displayed in simple visual terms, while retaining the deep insights Lexalytics is known for. If you're using a BI tool like Tableau™ or Qlik™ - then it's super easy to import the results of the text analysis in Excel into the tool you're using and look at it alongside all your structured data analysis. Want to know why that store isn't performing well? Now you can actually analyze the conversations alongside the numbers.
Pretty amazing. Once I had my data in Excel, I could run queries and had results back in seconds. What is particularly convenient for me is that the analytics are produced directly within Excel.Dr. Andrew Lumpe, Seattle Pacific University's School of Education