About WorkPilot

Spreadsheet analysis

Analyse individual worksheets or entire workbooks. WorkPilot can check for:

• Duplicate records and duplicate values in user-selected unique columns.
• Inconsistent data types, suspicious gaps and blank rows within data regions.
• Leading or trailing whitespace, inconsistent capitalisation and invalid email patterns.
• Formula errors, unusual formula patterns, suspicious SUM ranges and calculations stored as text.
• Hidden rows and columns, merged cells and differences between worksheet structures.

Checks are context-dependent and may not apply to every spreadsheet.

Clear findings and reports

WorkPilot presents findings with a severity level, worksheet and cell reference, original value, suggested action and an explanation when available.

Users can review and ignore findings they determine are not relevant. Excel and PDF analysis reports are available for documentation and sharing.

The reports support internal quality checks; they are not certifications, audits or guarantees that a workbook is error-free.

VBA and macro inspection

For macro-enabled workbooks, WorkPilot can identify the presence of a VBA project and indicators of automatic execution, command launching, network access, file operations, registry access and hard-coded paths.

Macro indicators call for investigation; they do not establish malicious intent. WorkPilot does not execute macros as part of inspection.

This is preliminary indicator-based inspection, not a full VBA security audit or malware scan.

Optional improvements

WorkPilot offers selected, user-controlled corrections in a separate workbook copy, and a Formula Modernisation feature for supported lookup patterns.

VLOOKUP-to-XLOOKUP conversion is supported for certain exact-match formulas. HLOOKUP-to-XLOOKUP conversion is being tested. Other modernisation types remain review-only until implemented and verified.

Formula replacements can change behaviour and should always be checked against the original results.