I will clean, dedupe and merge your excel or CSV data
Data Cleaning, Excel Automation and Web Data Specialist
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.
