Turn messy, inconsistent spreadsheets into clean, structured datasets ready for analysis or reporting.
What I Do
- Remove duplicates and strip unwanted characters
- Fix formatting issues (dates, phone numbers, text casing)
- Handle missing values and correct syntax/data errors
- Split merged data into clean, separate columns (e.g., full names, combined addresses)
- Standardize columns for easy importing into databases or CRM tools
Tools Used
- Excel / Google Sheets
- Python (Pandas) / OpenRefine