Spreadsheet Cleanup: Before and After

3 files in the raw/ folder → output/cleaned_20261030.xlsx

Before

Order no.DateItemAmount
A-10012026.4.3Pen set$12.00
A-10022026-04-03 Lunch box $8.50
A-10034/3/2026Laundry detergent$15.90
A-10034/3/2026Laundry detergent$15.90
A-10042026.4.12Notebook 
A-10052026-04-15 Bottled water 2L $6.20
A-10065/2/2026Towels$23.00
A-10065/2/2026Towels$23.00
Red cells: duplicates, empty cells, extra spaces / dates and amounts are formatted inconsistently

After

Order no.DateItemAmountCategory
A-10012026-04-03Pen set12.00Stationery
A-10022026-04-03Lunch box8.50Groceries
A-10032026-04-03Laundry detergent15.90Household
A-10042026-04-12Notebook0Stationery
A-10052026-04-15Bottled water 2L6.20Groceries
A-10062026-05-02Towels23.00Household
Green cells: values that changed · 2 duplicates removed · empty amounts shown as 0

Pivot sheet (monthly totals by category, USD)

MonthGroceriesHouseholdStationery
2026-0414.7015.9012.00
2026-05023.000

What was done

Example data. Real results are generated locally from your own spreadsheet.