Features of !SEMTools


!SEMTools is an add-in for Microsoft Excel that can greatly speed up your work with text data.

Over 500 small instruments, put together in a tidy intuitive hierarchy interface, lots of custom formulas, not initially available in Excel, powerful industry-oriented instruments for PPC and SEO specialists

!SEMTools is an add-in for Microsoft Excel that can greatly speed up your work with text data.

SEM here stands for semantics, as this add-in was firstly created for manipulating semantic data. But today it is way more than just that

New objects to interact with

Help your Excel understand what a “word” and “phrase” is . You can easily find words and phrases in the text, either singly or in huge lists on a variety of conditions. Delete, change words and their order in cells, change the case, search for abbreviations and toponyms with 1 click.

Magic-level speed

And this is not just some pretty words. The addin code is optimized to the maximum and processes hundreds of thousands of rows with the most complex procedures in mere seconds — even if it is working with tables of tens of thousands of words or phrases and deleting, replacing, or changing them along the way.

Does not require administrative rights

!SEMTools does not require any installation. All you need is show your Excel where the addin file is. You can do it right now! SEMTools download/install instruction.

Simple interface

How can you manipulate data in excel without formulas and adding helper columns? Easy!

  • Select cell or column;
  • Select desired action and execute it with !SEMTools

The !SEMTools add-in contains lots of functions and macros

Look below for some stuff that can be executed faster and easier with it.


These tools help find specific objects on multiple criteria. They are built to be the fastest, finding is faster than changing or deleting data


These tools will help delete objects from symbols to ranges on different conditions


  • Change characters
  • Change words
  • Change cells
  • Math tools
  • Change ranges
  • Bulk replacement

These tools help to change objects,  — characters, words, cells or ranges.


These tools help extract specific data on different conditions, which is in fact the same as deleting all data not meeting them


  • Join csv files
  • Join workbooks and worksheets
  • Join ranges (several ways)
  • Line combinations generator
  • Permutation generator

SEO & PPC tools

  • N-gram analysis
  • Lemmatization
  • Sentiment analysis
  • Regex web scraping tool
  • Google Ads keywords and search queries analysis
  • Getting Google search suggests
  • Getting ChatGPT responses for multiple queries in cells

These tools are designed for SEO and PPC specialists to help optimize ad campaigns, analyse search queries, scrape web data etc.

Who it is for

!SEMTools add-in for Excel is becoming more and more popular among very different office workers — financers, HR specialists, layers, marketers, sales teams, logistics etc. No matter what you do, if your job requires manipulating dozens of text fields at once, !SEMTools is the right solution for you.

Even having a trial version of !SEMTools can help you execute tedious tasks much faster than you would all by yourself.

The thing is, it has a lot of free functions, too!