I will clean, dedupe and merge your excel or CSV data

China

I speak English, Chinese

Data Cleaning, Excel Automation and Web Data Specialist

I help with Excel data cleaning and Python automation. I turn messy exports into clean, usable reports: merging and de-duplicating multi-store order files, reconciling statements against order records...
About this Gig

Messy files in, clean sheet out.


Duplicate rows, dates in three formats, phone numbers with stray spaces, amounts mixing text and numbers, and two exports that should match but do not - I fix all of it and tell you exactly what changed.


What you get:

- Duplicate rows removed using the rule we agree on

- Dates, emails and phone numbers standardised to one format

- Amounts turned into real numbers with two decimals

- Two files merged on a key, plus a list of every row that did not match

- Headers fixed, blank rows removed, hidden characters cleared

- A conflict report so you decide which value wins


How it works: send a 20 row sample. I confirm the rules in writing, you approve, then I process the full file and send the cleaned file plus the change log and conflict list.


FAQ

Formulas? Your structure stays and formulas are kept.

Original file? Never touched, you get a new file.

Unusual rules? Describe it in one sentence; if repeatable I script it in Python or Power Query.