!SEMTools for Excel
ENRU
Menu
Features of !SEMTools
!SEMTools / !SEMTools Version History

!SEMTools Version History

This page tracks the version history for !SEMTools.

Development is active and ongoing. This is driven by my desire to improve the tool and by user feedback.

Want to participate in the product’s development? You can discuss new features in the Telegram chat. Or contact me personally.

5.11.2025

  • Pro Version: Updated search procedures in the context menu for better placement.

26.10.2025

  • New feature: Find characters by type (Latin, Cyrillic, numbers) now has two search options. Added a color-highlighting method for better visibility.

29.09.2025

  • Arithmetic and rounding procedures now skip text cells.
  • All procedures requiring user input in a dialog will now cancel properly if the user clicks “Cancel”.

24.09.2025

  • Pro Version: Added QR Code generator (menu PPC & SEO -> Change).

12.09.2025

  • Added support for LM Studio for working with local neural networks. Connects to localhost:1234.

14.08.2025

  • Improved the “Detect” -> “Sheets” -> “Display in window” procedure. The window is now more interactive with substring filtering.
  • Most buttons now have pop-up tooltips explaining their function.

28.07.2025

  • New free procedure in the “About !SEMTools” group: outputs a list of Excel keyboard shortcuts to a new sheet.

25.06.2025

  • New free procedure in the “Detect” group: Create links to all workbook sheets (Table of Contents).
  • Added extraction of date attributes (day of month, month, year, day of week, etc.).

16.04.2025

  • Added OpenRouter AI API to the list of neural network APIs. Provides access to dozens of LLMs.

1.04.2025

  • In the “Merge Ranges” menu, you can now merge several separately selected columns, both horizontally and vertically.
  • Fixed errors with Deepseek and ChatGPT APIs.
  • For “Insert at end/beginning” procedures, the value to insert can now be a cell reference.

10.03.2025

  • Added a procedure for clustering keywords by search engine top results.
  • Improved the large CSV parsing procedure (now can select by two criteria with AND/OR logic).
  • Added a procedure for removing duplicate phrases in an entire column.

3.02.2025

  • Fixed a bug in the “sum in words” and “number in words” procedures.
  • Added a “sum in words with cents in words” procedure.
  • Added the NumToWords function for flexible number-to-text conversion.

29.01.2025

  • Added ABC-analysis tool (in the “Extract -> Count” section). Available in the free version.

15.01.2025

  • Pro Version: Added Deepseek neural network API.
  • Sentiment analysis procedure enhanced with min/max value calculation (was only average).

9.10.2024

  • Fixed the “Merge CSV in folder” procedure.
  • Added the latest ChatGPT models.
  • New “neural” API: Google Gemini API.
  • Fixed the phone number extraction procedure.

10.06.2024

  • Added 3 new tools for working with CSV files: merge CSVs in a folder, sample from CSV, and recode CSV.
  • Added the latest ChatGPT 4o model to the list.
  • Expanded the list of available languages in the Google Translate procedure from 12 to 34.

16.05.2024

  • Fixed an issue where ChatGPT requests could fail if they contained quotes.
  • Added fetching currency exchange rates for a specific date.
  • Fixed the Google Ads search query processing procedure.
  • Renamed the Join/Combine menu to Split/Concatenate.
  • Added a procedure to split a sheet into multiple sheets based on a column’s value.
  • Added a procedure for creating a pivot table with concatenated row values.

8.03.2024

  • Added a procedure for MD5 encryption of specified strings.
  • Added procedures to get current currency rates and convert currencies. Data is taken from the Central Bank’s website.

16.01.2024

  • Added the gpt-3.5-turbo-16k model to ChatGPT settings for larger queries.
  • Added mandatory manual setting of timeout between requests.

25.12.2023

  • Fixed a bug in the functions and procedures for writing sums and numbers in words.

25.11.2023

  • Improved and significantly sped up the “Remove Phrases” and “Mass Replace List of Phrases” procedures.

17.11.2023

  • Updated the prompt processing procedure in line with the latest OpenAI API updates.
  • Added settings for this API to choose from four popular latest models.

26.10.2023

  • Improved procedures for translating text in Excel: Google Translate, Deepl. Cells without letters are now skipped.
  • The lemmatization procedure now automatically converts text to lowercase.
  • Replacement procedures now follow the general logic (you can select an entire column).

1.10.2023

  • Fixed a bug with the phrase extraction procedure. Multiple phrases from one string are now joined with a backslash.

17.06.2023

  • Implemented mass sending of requests to ChatGPT.
  • The ChatGPT API token is now saved in the add-in via a separate procedure.

26.05.2023

  • Fixed and improved the adjective extraction procedure.
  • Added an option to delete empty cells with shift – up and left.

11.05.2023

  • Expanded the dictionary of question markers.
  • Improved the logic for identifying informational queries.

28.04.2023

  • Added procedures for adjusting word order in keywords. Turns uncoordinated word order into a natural one.

24.04.2023

  • Updated the English version of !SEMTools – added English lemmatization and procedures for finding and extracting English question markers.

Version 10.24.04 (4.03.2023)

  • Added support for ChatGPT API – completions and queries.

Version 10.23.17 (17.02.2023)

  • Added support for translation using Deepl API.

Version 10.23.14 (14.02.2023)

  • Added support for translation using the paid Google Translate API.
  • The !SEMTools tab name now contains the interface language.

Version 10.19.25 (25.10.2022)

  • Improved the “Modify-Characters-Case” menu with a clearer hierarchy.
  • Restored the accidentally “disappeared” macro for changing the case of the first letters of sentences to lowercase.

Version 10.17.20 (20.08.2022)

  • Added free functions: =LonLat(city) and =DistanceBetweenCities(City1, City2).

Version 10.15.20 (20.06.2022)

  • New tool for sentiment analysis (Sentiment Analysis).
  • Improved macro for moving words to the beginning and end of a string.

Version 10.13.1 (1.04.2022)

  • Fixed punctuation removal. Now removes everything except letters, numbers, and spaces.

Version 10.11.21 (21.02.22)

  • Fixed procedures related to verbs – many more are now extracted.

Version 10.9.03 (3.12.21)

  • New procedures: Delete words depending on where they are located – at the beginning and end of the string.

Version 10.6.17 (17.09.21)

  • Added a “link traversal” procedure.

Version 10.5.31 (31.08.21)

  • New tool: Search for phrases beginning with prepositions.

Version 10.4.07 (7.07.21)

  • Improved and finalized the reverse transliteration tool.

Version 10.2.05 (5.05.21)

  • Added procedures: Separate text from numbers, Extract domains from text, Change quotes to “curly” quotes.

Version 10.0.23 (23.03.21)

  • Global update, 10th version of !SEMTools, now includes context menu for cells.

Version 9.27.10 (10.03.21)

  • Added a procedure for merging cells – you can specify a separator from a cell or manually.
  • Added the ClosestByLevenshtein function.

Version 9.25.04 (4.01.21)

  • Added procedures for deleting text from cells by substring.

Version 9.24.16 (16.12.20)

  • Added parsing of content by links using regular expressions.

Version 9.23.19 (19.11.20)

  • 3 new free tools: Delete sheets in all open books by text conditions, Collect sheets of all books into the current one, Mass deletion of first and last rows in all sheets of the current workbook.

Version 9.22.14 (14.10.20)

  • Sentence Case now capitalizes the first letter of sentences.
  • New math operation: multiply by a random number from a range.

Version 9.20.08 (4.08.20)

  • New tool: Insert N rows with a step. Allows splitting the current data array with empty rows.

Version 9.18.18 (18.06.20)

  • Fixed the macro for replacing a list of words with another list.

Version 9.18.14 (14.06.20)

  • Added undo last action.

Version 9.18.06 (8.06.20)

  • Checkbox option for ignoring punctuation.
  • Checkbox values are now saved and don’t reset when closing Excel.

1.06.20

  • Global UX improvement. Now you can select and process an unlimited number of ranges and cells simultaneously.

Version 9.17.17 (17.05.20)

  • New tool: Parsing large text and CSV files.

Version 9.17.14 (14.05.20)

  • Added functions sumprop and numprop for sum and number in words.
  • Added a tool to merge data from all sheets of the current workbook.
  • Improved stability of the meta tag parsing procedure.

Update 9.17.05 (6.05.20)

  • New morphology tool: declining an entire phrase.

Version 9.17.02 (2.05.20)

  • Over 20 new data extraction tools.
  • Extract font attributes: name, size, style, color, and coordinates in RGB format.
  • Extract cell attributes: height, width, fill color, borders.
  • Find and extract characters from cells by style – ITALIC and UNDERLINED (BOLD was already there).

Version 9.16.30 (30.04.20)

  • Added checkbox output option.

Version 9.16.24 (24.04.20)

  • Global update of all procedures – now you can select and process multiple columns.
  • Added a link builder tool to the Join/Combine group.

Version 9.16.20 (20.04.20)

  • New tool: Import data onto a sheet from all CSV files in a folder.

Version 9.16.04 (4.04.20)

  • Added translator tool in Excel.

Version 9.15.31 (31.03.20)

  • The procedure for replacing words with words is now case-insensitive.
  • Added a procedure for replacing whole cells (like VLOOKUP, but more convenient).

19.03.20

  • Added functionality for replacing by regular expression for the first occurrence.

Version 9.15.16 (16.03.20)

  • New math operations in place: round, round up, round down.
  • Added regular expression functions: regexMatch, regexExtract, regexReplace.

Version 9.13.24 (24.1.20)

  • Added mathematical procedures (Change group).

Version 9.13.11 (11.1.20)

  • Improved the algorithm for declining regular words by case.
  • Added declining of full names (First, Middle, Last) in all cases.
  • Help started working in the add-in – all links now lead to relevant sections of the site.
  • Added a procedure to delete all cell contents if they match a given regular expression.

Update 9.12.27 (27.12.19)

  • Macros for finding, deleting, and extracting words from a list no longer return an error if the list has duplicates.
  • Added deletion of formulas only in visible cells of the selected range.

13.12.19

  • More possibilities for working with regular expressions.
  • Fixed the “remove punctuation” macro.
  • Added a macro for extracting letters of any alphabets.
  • Added macros for deleting and extracting 1 word from cells.

Version 9.11.14 (14.11.19)

  • 8 new macros. Instantly find, delete, extract, and replace cells based on “repeatability” – unique or repeating.

5.11.19

  • Added a procedure for removing duplicate words inside a cell.

24.10.19

  • Added: Sort list by length in characters, Sort list by number of words, Delete rows by content length.

6.10.19

  • Added procedures: Sum and number in words, Convert numbers written as text to numeric format, Count the number of characters in a cell.

23.09.19

  • Now you can find, delete, extract from text various parts of speech: nouns, adjectives, verbs, adverbs.

2.09.19

  • Added the ability to check the current version of the add-in.

26.08.19

  • Now you can delete entire rows at once based on several popular conditions.
  • Added extraction of phone numbers from text.

10.08.19

  • Added the ability to extract substrings from strings by REGEX pattern.
  • Added several popular presets – extracting emails and dates in different formats.

7.08.19

  • UX update. When selecting an entire column, procedures process only the main range, not all 1,048,576 rows.

5.08.19

  • Now you can work with whole cells: Find, delete, and extract cells based on universal conditions (contains any from list, starts with any from list, ends with any from list).
  • Also added macros for extracting cells by conditions: Contains Latin, Contains numbers, Contains words from numbers, Contains capital letters, Contains a word.

2.08.19

  • New possibilities for Excel for marketers – quick extraction of UTM tags from a URL.

25.06.19

  • New procedures – search, delete, and extract phrases.

20.06.19

  • Added a procedure for detecting cells containing phrases.

16.06.19

  • Improved word declension macros – added thousands of exceptions for nouns.

10.06.19

  • Release of the first version of word declension in Excel.

4.06.19

  • Added a series of procedures for combining and generating combinations.
  • Added a macro for replacing a list with a list by occurrence.

This post is also available in RU.