Features of !SEMTools

!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

Надстройка !SEMTools содержит множество функций и макросов

Ниже основные действия, доступные в надстройке.

FIND

These tools help find specific objects on multiple criteria. They are generally very fast, finding is usually faster than changing or deleting data

DELETE

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

CHANGE

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

EXTRACT

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

Join/Combine

  • Permutation generator
  • Line combinations generator
  • Join ranges (several ways)

SEO & PPC tools

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

For whom

!SEMTools addin for excel is becoming more and more popular among very different office workers — financers, HR specialists, layers, marketers, sales teams, logistics etc.

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!