Semantria for Excel / Quickstart


1 First, if you haven't already, activate your Semantria account

During signup we sent you a confirmation email (check your Spam and Junk folders if it's not showing up)

If you're already a confirmed Semantria user, you can proceed to the second step running an analysis.

2 Download Semantria for Excel

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

Mac Users: We have no native support for Mac, but you can run it through a Windows virtual machine setup

System recommendations:
1) 64bit Microsoft Excel
2) >4GB RAM
3) Dual core or better CPU

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 & 2016 File > Account > About Excel

 32-bit Office  64-bit Office

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 Analysis

  1. In the Lexalytics tab in Microsoft Excel, click on Start to open the New Analysis wizard.
    Start button
  2. Import your text to analyze. If you want, use our sample data set below.

    Bellagio Reviews Dataset (.xlsx file)

    Analysis wizard step 1 Select Data Source
  3. Categorize your data by ID, metadata, and the text to analyze. (If you don't see column names, click on "First row has column headings")
    Analysis wizard step 2 Categorize Data
    Analysis wizard step 3 Categorize Data
  4. Select the rows to analyze.
    Analysis wizard step 6 Rows to Analyze
  5. Name your project, select the appropriate language and configuration, in this case English, and click Next.
    Analysis wizard step 7 Analysis Settings
  6. Select the desired reports under Summary Reports and Detail Reports and they will generate. Clicking on the top half of the report buttons will auto-generate all of the reports in that category. Clicking on the bottom of the button will allow you to select individual reports. Then you may want to click "Analytics panel" up next to the Start button in order to review the reports at full width.
    Quickstart analysis results
  • The Summary Reports include*:
    • Sentiment Phrases
    • Themes
    • Entities
    • Queries
    • Concept Topics
    • Autocategories
    • Query Co-Occurence
  • The Detail Reports include*:
    • Document Overview
    • Words
    • Sentiment Phrases
    • Themes
    • Entity Themes
    • Entities
    • Queries
    • Concept Topics
    • Autocategories
    • Intentions
    • Machine Learning Models
  • The Tuning Reports include*:
    • Uncategorized Documents
    • Possible Sentiment Phrases
    • Query Comparison
    • Sentiment Phrases for Queries

    * available tabs depend on the licensed features

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

Or call us at 1-800-377-8036