I will clean and standardize your messy excel or CSV data

China

I speak English
I clean messy spreadsheets and turn them into data you can actually use. My clients are sales teams whose files have passed through too many hands — duplicate rows, five phone formats, one city spell...
About this Gig

 turn messy spreadsheets into data you can actually use.


If your file has duplicate rows, five different phone formats, "New York"

spelled six ways, or ZIP codes with letters in them that's what I fix.


WHAT I DO

Remove duplicates (by ID, or by name + address)

Standardise names, addresses, phone numbers, dates and categories

Fix and validate postal codes

Map inconsistent values to one standard

Flag what can't be verified instead of silently deleting it


WHAT YOU GET

Your file back in Excel, CSV or Google Sheets

A short report: what was broken, what I changed, what I flagged

Premium: the documented script, so you can re-run it next month


WHY ME

I work on English-language data daily and know the difference between

 "looks fine" and "is correct"

GMT+8 send a brief in your evening, have the file when your day starts

I don't pad files to look complete


SAMPLE

Message me and I'll send a before/after breakdown of a real 50,000-row

public dataset I cleaned: 46 phone formats reduced to 1, 1,770 city

spellings reduced to 7, and 31,699 records made contact-ready.



My Portfolio