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
• 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.

View screenshots

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.

View screenshots

Replace Chars

Replace only visually similar letters: А↔A, В↔B, Е↔E, К↔K, М↔M, Н↔H, О↔O, Р↔P, С↔C, Т↔T, У↔Y, Х↔X.

View screenshots

Stringify Numerics

Convert numbers to their word representation in multiple languages:

• Russian
• English
• French

View screenshots

Up

---

Toggle Case

Cycle through text case transformations: Abcde → abcde → ABCDE

View screenshots

Trim Spaces

Remove extra spaces, line breaks, and leading/trailing whitespace from text cells.

View screenshots

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.

View screenshot

Unmerge Cells

Unmerge cells while filling each cell with the original merged value.

View screenshots

Find All Cells Containing Errors

Locate all formula errors in the selected range: #N/A, #NAME?, #DIV/0!, #REF!, #VALUE!, #NUM!, #NULL!

View screenshot

Copy as Markdown

Copy selected cells to clipboard as a markdown-formatted table.

View screenshot

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.

View screenshot

Up

---

Export to SQLite

Export the entire workbook to a SQLite database file. Each worksheet becomes a separate table with automatic column type detection.

View screenshots

Up

---

Create Sample XML based on XSD

Generate a sample XML file from an XSD schema to visualize the structure.

View example

Input XSD Schema:

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
           xmlns:tns="http://tempuri.org/PurchaseOrderSchema.xsd"
           targetNamespace="http://tempuri.org/PurchaseOrderSchema.xsd"
           elementFormDefault="qualified">
 <xsd:element name="PurchaseOrder" type="tns:PurchaseOrderType"/>
 <xsd:complexType name="PurchaseOrderType">
  <xsd:sequence>
   <xsd:element name="ShipTo" type="tns:USAddress" maxOccurs="2"/>
   <xsd:element name="BillTo" type="tns:USAddress"/>
  </xsd:sequence>
  <xsd:attribute name="OrderDate" type="xsd:date"/>
 </xsd:complexType>

 <xsd:complexType name="USAddress">
  <xsd:sequence>
   <xsd:element name="name"   type="xsd:string"/>
   <xsd:element name="street" type="xsd:string"/>
   <xsd:element name="city"   type="xsd:string"/>
   <xsd:element name="state"  type="xsd:string"/>
   <xsd:element name="zip"    type="xsd:integer"/>
  </xsd:sequence>
  <xsd:attribute name="country" type="xsd:NMTOKEN" fixed="US"/>
 </xsd:complexType>
</xsd:schema>

Generated XML Output:

<PurchaseOrder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" OrderDate="1900-01-01" xmlns="http://tempuri.org/PurchaseOrderSchema.xsd">
  <ShipTo country="US">
    <name>name1</name>
    <street>street1</street>
    <city>city1</city>
    <state>state1</state>
    <zip>1</zip>
  </ShipTo>
  <ShipTo country="US">
    <name>name2</name>
    <street>street2</street>
    <city>city2</city>
    <state>state2</state>
    <zip>-79228162514264337593543950335</zip>
  </ShipTo>
  <BillTo country="US">
    <name>name1</name>
    <street>street1</street>
    <city>city1</city>
    <state>state1</state>
    <zip>1</zip>
  </BillTo>
</PurchaseOrder>

Validate XML with XSD

Validate an XML file against an XSD schema. A detailed error report will be created in a new workbook.

View sample error report

Sample error report:

Severity	Element	Message
Error	city	The element 'shipto' has invalid child element 'city'. List of possible elements expected: 'address'.
Error	quantity	The 'quantity' element is invalid - The value '-5' is invalid according to its datatype 'http://www.w3.org/2001/XMLSchema:positiveInteger' - Value '-5' was either too large or too small for PositiveInteger.
Error	price	The 'price' element is invalid - The value 'asdasd' is invalid according to its datatype 'http://www.w3.org/2001/XMLSchema:decimal' - The string 'не число' is not a valid Decimal value.

Up

---

Undo Last Action

Undo the last action performed with this add-in. Available for some functions in the 'Converting values' and 'Formatting values' sections, only if cells haven't been edited since.

Up

---

How to Install the Add-In

Quick Install (Recommended)

1. Download and unpack setup.exe
2. Run the installer and follow the wizard
3. Restart Excel if it was open during installation
4. You'll see the new Navferty's Tools tab in the ribbon

Certificate Installation (if needed)

If you encounter a security warning about the certificate:

1. Right-click on setup.exe and select Properties
2. Go to the Digital Signatures tab
3. Select the signature and click Details
4. Click View Certificate → Install Certificate
5. Choose Local Machine and place it in Trusted Root Certification Authorities

Note: You can remove the certificate after installation, but it will be required for future updates.

Advanced: Offline Install

The solution is built in Azure. You can download the full archive with installation files:

1. Visit https://navferty.visualstudio.com/NavfertyExcelAddIn/_build?definitionId=3
2. Select the latest build of 'NavfertyExcelAddIn - Publish' pipeline
3. Download published installation files
4. Extract files to a folder and run the '.vsto' file

Important: Using the desktop folder is recommended - updates are only permitted from the same folder where the add-in was first installed.

After installation, restart Excel and you'll see the new Navferty's Tools tab.

Up