Russian | English
Navferty's Excel Add-In
A free Excel add-in that enhances productivity with tools for data manipulation, formatting, and validation.
Features
Installation
Download, unpack and run the installation file to install the add-in for Excel.
After installation, restart Excel if it was open. You should see the new Navferty's Tools tab in the ribbon.
Note: If you encounter a security warning about the certificate, see detailed installation instructions below.
Parse Numerics
Convert numbers stored as text to proper numeric format, making them usable in calculations.
Replace
Replace Russian characters using different transformation methods.
With Transliteration
Complete transliteration of Russian alphabet to English. For example: "Ж" → "Zh", "Щ" → "Shch". Based on ICAO Doc 9303.
Replace Chars
Replace only visually similar letters: А↔A, В↔B, Е↔E, К↔K, М↔M, Н↔H, О↔O, Р↔P, С↔C, Т↔T, У↔Y, Х↔X.
Stringify Numerics
Convert numbers to their word representation in multiple languages:
Up
Toggle Case
Cycle through text case transformations: Abcde → abcde → ABCDE
Trim Spaces
Remove extra spaces, line breaks, and leading/trailing whitespace from text cells.
Up
Unprotect Workbook
Remove protection from all worksheets, workbook structure, and VBA projects without needing passwords.
Note: Does not work with encrypted workbooks.
Worksheets Protection
Set or remove protection on multiple worksheets at once.
Highlight Duplications
Automatically color-code duplicate values in the selected range. Different colors indicate different duplicate groups.
Unmerge Cells
Unmerge cells while filling each cell with the original merged value.
Find All Cells Containing Errors
Locate all formula errors in the selected range: #N/A, #NAME?, #DIV/0!, #REF!, #VALUE!, #NUM!, #NULL!
Copy as Markdown
Copy selected cells to clipboard as a markdown-formatted table.
Validate Values
Check cell values against specific formats:
- Number
- Date
- TIN of an individual (12 digits with verification)
- TIN of a legal entity (10 digits with verification)
- Text for XML (no invalid characters)
Note: Valid TIN format doesn't guarantee the organization or individual exists.
Up
Export to SQLite
Export the entire workbook to a SQLite database file. Each worksheet becomes a separate table with automatic column type detection.
Up
Create Sample XML based on XSD
Generate a sample XML file from an XSD schema to visualize the structure.
Input XSD Schema:
This is the beginning of the README. Read the rest at the original. Read the full README ↗
