Release Notes – Kutools for Excel 36.00

We are pleased to announce the release of Kutools for Excel 36.00, introducing powerful new tools for data standardization, formatting, data analysis, and formula building. This version also enhances email compatibility, improves filtering performance, and includes various UI refinements and stability improvements.

Download or upgrade now to try Kutools for Excel 36.00 free!
Tip: full function & feature, free trial in 30 days! If your 2-year free upgrade support period hasn’t expired, you are entitled to a free upgrade.

New Features

1. Convert State Names and Abbreviations
   The Convert State Names and Abbreviations feature helps quickly standardize U.S. states and Canadian provinces by converting between their full names and official abbreviations.
   
2. Convert Country/Region Name and ISO Codes
   The Convert Country/Region Names and ISO Codes feature helps convert country and region names to internationally recognized ISO codes, or convert ISO codes back to country and region names, making international data standardization faster and more consistent.
   
3. Standardize Contact Information
   The Standardize Contact Information feature helps standardize common types of contact information across multiple countries and regions, improving data consistency and readability for international datasets.
   • Phone Numbers
   • Postal / ZIP Codes
   • Addresses
   • Email Addresses
   Perfect for preparing international customer lists, CRM systems, mailing databases, and imported records.
   
4. Workday Calculator
   The Workday Calculator feature calculates the number of business days between two dates by excluding weekends and country-specific public holidays.
   • Supports multiple countries and built-in holiday calendars.
   • Calculates business days for single dates or batch ranges.
   • Automatically excludes weekends and country-specific public holidays.
   
5. Mask Sensitive Information
   The Mask Sensitive Information feature helps protect confidential data by masking sensitive information while preserving enough detail for easy recognition. It supports country-specific data formats across multiple countries and regions.
   • ID Numbers
   • Payment Card Numbers
   • Phone Numbers
   • Home Addresses
   • Email Addresses
   • Personal Names
   Ideal for data sharing, demonstrations, and privacy protection.
   
6. Number Format Helper
   The Number Format Helper feature makes it easy to apply professional number formats without memorizing or writing complex custom format codes. It provides a rich library of 99 predefined number formats organized into 14 categories, along with live preview and custom format management.
   • 99 predefined number formats organized into 14 categories for quick browsing.
   • Covers common scenarios including currency, percentages, dates, and more.
   • Instantly search and preview formats before applying them.
   • Create, organize, and manage your own custom format categories and formats.
   
7. Highlight Data Types
   The Highlight Data Types feature helps quickly identify different data types in the current view of a worksheet by highlighting them with customizable colors, making data inspection and cleanup easier.
   • Numbers
   • Text
   • Dates
   • Logical values (TRUE/FALSE)
   • Blank cells
   • Error values
   Highlights:
   • Automatically detects data types in the current worksheet view.
   • Customize highlight colors for each data type.
   • Click a data type to instantly select all matching visible cells.
   • Easily apply formatting or perform other bulk operations on the selected cells.
   
8. Formula Helper Plus
   Built upon the original Formula Helper, the Formula Helper Plus provides a more powerful and flexible formula-building experience. It combines Local and Online formula libraries, allowing you to quickly find formulas, understand their usage through detailed explanations and examples, and generate formulas by simply filling in the required arguments.
   • Upgraded from the original Formula Helper with a larger collection of more powerful and practical formulas.
   • No need to memorize complex formulas or syntax—simply select the required arguments to automatically generate the formula and result.
   • Browse formulas by category or quickly search by keyword.
   • Displays formula syntax, parameter descriptions, and practical examples.
   • Supports custom formula categories and lets you save your own formulas for future reuse.
   

Improvements

1. Send Emails
   The Send Emails feature now supports Microsoft account authentication, making it easier to send emails through Microsoft 365, Outlook.com, and other Microsoft mailboxes without manual SMTP configuration.
   
2. Super Filter
   The Super Filter has been enhanced with three new options to simplify creating, importing, and managing filter criteria.
   • Create Example Plan from Current Sheet – Automatically generate an example filtering plan based on the current worksheet data.
   • Import Current Filter Criteria – Import the filter criteria currently applied by Excel's built-in Filter feature into Super Filter.
   • Create Sample Document and Scenario – Create a sample worksheet with predefined filter scenarios for quick learning and testing.
   
3. User Interface
   Improved various dialog messages and UI details for a clearer and more consistent user experience.

Fixed

• Fixed various minor bugs.