Semantria for Excel / Quickstart

Setup

1 First, you'll need a Semantria account

If you're already a Semantria user, you can proceed to the second step. If not click the button below to start registration.

Get a FREE trial

During the registration process, you will be asked to provide a username and a password. Make sure you note them down as you will need them to complete the setup of Semantria for Excel on your computer.

2 Download Semantria for Excel

System requirements:
1) Microsoft Windows XP, Vista, 7, 8, 10
2) Microsoft Excel 2010, 2013 or 365

 32-bit Office  64-bit Office

Is my Excel 32 or 64 bit?

Note: Check this as it is possible to have 32 bit Excel running on 64 bit Windows

Excel 2010 File > Help > About Microsoft Excel
Excel 2013 & 365 File > Account > About Excel

3 Run the setup file on your computer

  1. Close Microsoft Excel if it is running
  2. Double-click on the installation file (Semantria.Excel.Setup.xXX.exe) and follow the on-screen instructions
  3. Complete the whole setup process

4 Enter your credentials in Excel

  1. Open Microsoft Excel
  2. A Semantria sign-in window will open
  3. Enter the username and password you provided during the signup process. You can also enter them after setup under [Settings > Sign-in] in the Lexalytics ribbon tab.

Running Your First Sentiment Analysis

  1. Import your text to analyze. If you want, use one of our sample data sets below.

    Bellagio Reviews Dataset (.xls file)

    Trip Advisor Dataset (.xls file)

  2. In the Lexalytics tab in Microsoft Excel, click on "Show panel" in the top left corner.
    Show panel button
  3. Click on Start to open the New Analysis wizard.
    Start button
  4. Name your project "FirstSentiment" and select your source text(these are the table cells that hold the text you want to be analyzed eg. all of the reviews in our sample dataset).
    Start analysis wizard
  5. Click Analyze
  6. Check that the Detail Report and Summary Report buttons are both highlighted
    Select Reports
  7. Open up your project by double clicking on the green highlighted name of the project in the Semantria for Excel panel on the right.
    Quickstart analysis results
    You may want to click "Hide panel" at this point in order to review the reports.
  8. The Detail Report Tabs include*:
    • Document Detail
    • Phrase Detail
    • Entity Detail
    • Entity Theme Detail
    • Theme Detail
    • Wikipedia Category Detail
    • User Category Detail
    • Query Category Detail
    • Intention Detail

    The Summary Report Tabs include*:
    • Phrases
    • Themes
    • Entities
    • Queries
    • User Categories
    • Auto Categories

    * available tabs depend on the licensed features

You've completed your first sentiment analysis! For more help see our step-by-step tutorials, customization tips, and fine-tuning

Get a FREE trial Schedule a demo

Or call us at 1-800-377-8036