I will clean, deduplicate and standardise your messy excel or CSV data
AI Chatbot and Automation Expert
About this Gig
I will take your messy spreadsheet and give it back usable: duplicates gone, names and addresses standardised, dates in one format, phone numbers consistent - plus a report of exactly what I changed.
WHAT "MESSY" USUALLY MEANS (and what I fix)
- Duplicate rows and near-duplicates ("John Smith" vs "john smith " vs "J. Smith")
- Names split wrong or crammed into one cell
- Mixed date formats (03/04/2025 - is that March or April?)
- Phone numbers with brackets, dashes, country codes, stray spaces
- Amounts stored as text with currency symbols and commas
- Invisible characters (trailing/non-breaking spaces) that break your VLOOKUP
- Inconsistent categories ("USA", "U.S.A", "United States", "us")
WHAT YOU GET BACK
- Your file, cleaned, in the same format you sent it
- A one-page change log: how many rows removed, which rules were applied, what was ambiguous
- Optional: a reusable Python/Excel script so next month's export cleans itself
WHAT I DON'T DO
- Guess missing data - anything ambiguous gets flagged, not filled in
- Merge two datasets by fuzzy matching without your approval on the match rules
TURNAROUND
10,000 rows: 2 days Send a 200-row sample for a same-day check
