EGTools++ Function Manual (English)¶
EGTools++ is a single-file .xll add-in that brings modern Microsoft 365 functions to legacy Excel (2010 and later; Windows only, no installer or admin rights). It provides XLOOKUP, FILTER, TEXTSPLIT, GROUPBY, REGEX functions and more, identically on every version — registered under the original name as a drop-in where the host lacks the native function, or with an EG. prefix where it exists. A ribbon of practical utilities (visible-cells copy, mail merge, calendar builder) is included.
Download: GitHub Releases · Source & support: GitHub repository
Per-function reference. Clicking a function name in the IntelliSense tooltip opens the matching page.
MS Excel compatibility functions (69)¶
Excel 2013 (28)¶
- ARABIC
- BASE
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
- CEILING.MATH
- COMBINA
- DAYS
- DECIMAL
- ENCODEURL
- FILTERXML
- FLOOR.MATH
- FORMULATEXT
- IFNA
- ISFORMULA
- ISOWEEKNUM
- NUMBERVALUE
- PDURATION
- PERMUTATIONA
- RRI
- SHEET
- SHEETS
- UNICHAR
- UNICODE
- WEBSERVICE
- XOR
Excel 2016/2019 (6)¶
Excel 2021 (9)¶
Excel 2024 (17)¶
- ARRAYTOTEXT
- CHOOSECOLS
- CHOOSEROWS
- DROP
- EXPAND
- HSTACK
- IMAGE
- TAKE
- TEXTAFTER
- TEXTBEFORE
- TEXTSPLIT
- TOCOL
- TOROW
- VALUETOTEXT
- VSTACK
- WRAPCOLS
- WRAPROWS
Microsoft 365 (9)¶
- GROUPBY
- IMPORTCSV — Microsoft 365 (new in 2026)
- IMPORTTEXT — Microsoft 365 (new in 2026)
- PERCENTOF
- PIVOTBY
- REGEXEXTRACT
- REGEXREPLACE
- REGEXTEST
- TRIMRANGE
Google Sheets compatibility functions (7)¶
EGTools-only functions (52)¶
Lookup & Reference (3)¶
Data & Arrays (4)¶
Text (4)¶
Date & Time (4)¶
Information & Formulas (4)¶
Color & Visible Cells (5)¶
Images & Barcodes (6)¶
Web & API (3)¶
Korean Data (11)¶
- ADDRESSMAP
- BRNSTATUS
- EXRATE
- GEOADDRESS
- GEOCODER
- GEOSEARCH
- HANTONUMBER
- KOREANHOLIDAYS
- SEARCHADDRESS
- TOLUNAR
- TOSOLAR
Quality & Manufacturing (8)¶
Ribbon Menu¶
Features on the EGTools ribbon tab. See the ribbon overview for the full layout.