The challenge
Thousands of rows had 'Company Name (Contact Name)' fused into a single Referral From cell.
The solution
A single Python script (migrate_cleaner.py) that reads every sheet from the uncleaned workbook, applies four deterministic rules (FREE JOB exclusion, negative-amount exclusion, company/contact parentheses split, multi-job-number row explosion), casts currency-like strings to real numbers, and writes output against the exact column order of the provided template.
Results
4
Cleaning rules
All sheets
Sheets handled
Template-matched
Output shape