Parts Spreadsheet Cleanup — Fictional Sample

Automotive parts spreadsheet cleanup

Self-created demonstration — fictional data.

This fictional 14-record parts list contains repeated records, extra spaces, mixed date formats, and unclear entries. I prepared a cleaned spreadsheet, preserving the untouched source and a record of each change.

Only two exact duplicate records were removed, leaving twelve retained records. Unambiguous dates were standardized. Ambiguous dates, missing data, text quantities, and records that became similar after trimming were retained and flagged for confirmation.

The deliverables include an editable Excel workbook with source, cleaned, and audit sheets, plus original and cleaned CSV files. The preview shows the actual rendered cleaned sheet. All three sheets were inspected, record counts were reconciled, and the workbook had no formula errors.