Features of !SEMTools

Download the latest version of !SEMTools here:

After download:

  1. Don’t open the file
  2. Find it on your computer (usually in ‘Downloads’ folder)
  3. {Optional} Copy the add-in file or move it to a folder on your computer where it won’t get lost or won’t be accidentally deleted, i.e. C://!semtools/ folder
  4. If the file is locked, unlock the file after opening its properties with the right mouse button. Make sure checkbox is filled and press “Apply”.

Why unlock the file? Windows blocks files downloaded from the Internet by default, and !SEMTools tab may not appear in Excel if the file stays locked. This is universal for all .xlam add-ins.

How to connect Excel add-in to your Excel

Further steps are performed in Excel, see the quick text and gif instructions:

  1. Open your Excel
  2. Go to File -> Options -> Add-ins
  3. Click the «Go…» button at the bottom
  4. Find the file on your computer, double-click or select and click the OK button
  5. The add-in should appear in the addins list with a checkbox marked. Press «ОК» to save your settings.

Compatible Excel versions

The add-in is supported and works correctly with the following Excel versions:

Excel 2010
Excel 2013
Excel 2016
Excel 2019
Excel 365
On all Windows versions from XP to Windows 10

IMPORTANT: there is no version for Mac yet.
Excel addin from this page can be connected to Excel for Mac, but most functions wont work. For Mac users, it is recommended to use virtual machine with Windows (and Excel for Windows on it).