!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
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
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.
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.
!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.
How can you manipulate data in excel without formulas and adding helper columns? Easy!
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 generally very fast, finding is usually faster than changing or deleting data
These tools will help delete objects from symbols to ranges on different conditions
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
These tools are designed for SEO and PPC specialists to help optimize ad campaigns, analyse search queries, scrape web data etc.
!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!