Traceable Excel Data Cleaning & Validation — Independent Demo

A Python-based workflow combines and validates two Excel files, producing a reviewable workbook with a traceable change log.

Independent demonstration using fictional data; no client commissioned or paid for this project. Created by NorthForgeLabs in October 2026.

Goal

Combine two flat XLSX files into a clean, reviewable workbook while preserving the source files and a traceable record of changes. The source files contain 12 non-empty records across five data columns.

Work demonstrated

• Standardising agreed text, date and number formats
• Consolidating the two source files
• Removing one confirmed exact duplicate and retaining 11 records
• Preserving six issues for review, including conflicting IDs, an invalid date, an ambiguous number and a missing ID
• Providing separate Master, Issues and Changes tabs

Checks and handover

The change log records 23 entries, including the separate exclusion of one fully empty physical row. Source references and file hashes support reconciliation. Original files remain unchanged.

The workbook was checked with automated reconciliation and cell/type validation, then opened and reviewed in Microsoft Excel. Ambiguous values were flagged rather than guessed. This example does not claim a customer endorsement or commercial result.

Discuss a similar project

Send a sample file, approximate row/file count, required output format and deadline. Fixed project pricing can be agreed after reviewing the source files and validation rules.