I will clean, deduplicate and standardise your messy excel or CSV data

China

I speak English

AI Chatbot and Automation Expert

I run a 24/7 AI customer-service operation on a major e-commerce platform. My system classifies every incoming message, answers product and pricing questions from a structured knowledge base, negotiat...
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