Excel & CSV Data Cleanup Automation

The goal

Create a clear, repeatable workflow for turning messy spreadsheet or CSV data into a clean file ready for reporting or import.

What I did

• Standardized dates, text values, and column formats
• Removed duplicates and checked missing or invalid values
• Added validation rules and a concise results summary
• Prepared a Python-based option for repeatable processing
• Produced clean Excel and CSV exports with clear documentation

Result: a transparent cleanup process that can be reviewed step by step and adapted to a client's real dataset. This is a demonstration project using sample data; no confidential client information is shown.