A clear record of every change
Clean data.
Keep the evidence.
Review the output of a local Excel cleanup. Every row stays linked to its original worksheet.
RUN SUMMARY
Supplier catalogue
Select a row to inspect its changes.
Row numbers refer to the original Excel worksheet. “After rules” includes proposed values, even on removed rows.
THE LOCAL TOOL
Review first.
Write a separate file.
The companion Python tool reads a selected sheet in an XLSX workbook, trims only selected text columns, and reports exact duplicate rows. Removing duplicates is an explicit option. Dates, numbers and text identifiers keep their types.
Apply mode creates a new plain-data workbook from the selected sheet. It does not preserve workbook layouts, charts or other sheets. Formula-containing sheets are blocked from apply; their formulas can still be inspected in preview.
Download runnable source + instructions