Excel and CSV Cleaning with Exception Reports

I built a Python workflow that turns an inconsistent sales CSV into a cleaned Excel workbook and a separate summary report. It standardises dates, currency and status labels, recalculates totals, removes duplicate order IDs and keeps uncertain values visible in review notes.

The documented demonstration checks 15 records, outputs 14 cleaned records, removes one duplicate and flags six records for review. These are synthetic demonstration results, not customer data or measured business savings.

Deliverables include the cleaned workbook, summary report, exception notes, Python script and instructions for repeating the process. Input and output checks make the changes easier to inspect before the cleaned data is used.