Buy !SEMTools
Version difference
By purchasing the add-in, you get a time-unlimited license. All updates to !SEMTools work without any re-activation.
Free version (both Lite and Pro)
In the free version, about 2/3 of all cells are processed. In the remaining ~1/3 of the cells (random), the result is replaced with the message “!SEMTools – Available in full version”. It is strongly recommended not to work with valuable data in the free version: there’s only a 1-step undo for add-in procedures.
The add-in also has many free functions and procedures that work without limits:
- Regular expression functions: REGEXMATCH, REGEXEXTRACT, REGEXREPLACE
- Delete empty rows
- Delete empty columns
- Delete rows by conditions
- Remove formulas from a range, sheet or workbook
- Extract URLs from hyperlinks
- Create hyperlinks in bulk
- Open all links at once
- Collect Google and YouTube search suggestions
- All Join/Split procedures:
Lite
- Find data:
- characters
- words and phrases
- cells (incl. duplicates)
- Delete data:
- Extract:
- Change:
Pro
- All Lite procedures
- Search in Google and Yandex from the cell and range context menu
- Web services and APIs:
- Online translation (Google, DeepL)
- Search suggestions (Google, Bing, Amazon, YouTube, Yandex)
- AI APIs (ChatGPT, DeepSeek, Gemini, Claude, OpenRouter AI, Ollama)
- Yandex APIs: Metrica, Direct, Webmaster
- Website page parsing (with regular expressions)
- Built-in dictionaries in search, extraction and other procedures (sales, rent, reviews, place names, questions, prepositions)
- Morphology: lemmatization
- Procedures for PPC specialists: search query analysis, synonyms, irrelevant words, match types and more
- N-gram analysis of text (word frequency)
- URL slug generator
- Sentiment analysis (scoring text by word tone)
- Sampling data from huge CSV files
- QR code generator
!SEMTools activation
The activation mechanism is not typical – there are no serial numbers that can be entered in any fields. Activation does not require an Internet connection and does not crash when reinstalling. The add-in file itself is attached to your computer and user on it.
When paying for a license, you provide a code that identifies the current user of your computer. You can only get it if you download and install the trial version of the add-in.
To get the code, you need to click “Check Status” in the “License” menu on !SEMTools panel (see picture below).
Input given code into a relevant form field, your email address, and make payment. The license is activated by me after the payment is accepted.
An email will be sent to the email address you specified about successful activation and an invitation to download the updated file linked to your device – in the same “Download” section.
After downloading, you need to replace the original add-on file with the downloaded one and all procedures will work. When you click on “Check status” it will say “License is activated!”.
Important: activation process may take several hours, (usually not more than 4!) as it’s manual. You can contact me to expedite the process. If you didn’t receive it within 4 hours, try to check your Spam folder (happens sometimes, I’m working on it)
F.A.Q.
Under what conditions does the license code can change?
- when changing the name of the current user;
- when changing the user of the same computer;
- when changing the computer name;
- (sometimes) when changing the version of MS Excel;
- When changing hardware (except for non-system hard drives)
I bought one license, but it was lost for some reason (changed computer/user/lost when reinstalling Windows/Office). Is it possible to rebind?
No, unfortunately, the licensing mechanism does not allow you to disable the old license and enable the new one. But this is offset by a modest license price.
Can I get a discount?
Yes, if you purchase the add-in for multiple users at the same time.
- from 6 to10 licenses — 10%;
- from 11 to 20 licenses — 20%;
- 21 and more licenses — 30%.
For more info you can connect with me.