Russian | English

Navferty's Excel Add-In

A free Excel add-in that enhances productivity with tools for data manipulation, formatting, and validation.

Features

• Parse Numerics
• Replace (Transliteration or Analogues)
• Stringify Numerics
• Toggle Case
• Trim Spaces
• Unprotect Workbook
• Worksheets Protection
• Highlight Duplications
• Unmerge Cells
• Find All Cells Containing Errors
• Copy as Markdown
• Validate Values
• Export to SQLite
• Create Sample XML based on XSD
• Validate XML with XSD
• Conditional Formatting
• Sheet Tabs
• Reference Style (A1/R1C1)
• Exchange Rates
• Undo Last Action

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:

• Russian
• English
• French

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 ↗