I will remove duplicate rows and clean up excel and google sheets
About this Gig
Duplicates in your spreadsheet are quietly wrecking your numbers.
Two rows for the same customer, the same email typed three ways, one phone number with and without spaces your totals, your mailouts and your reporting are all off.
I clean that up.
WHAT I DO
· Exact duplicates identical rows removed
· Fuzzy duplicates "Jon Smith" and "John Smith", same address, different capitalisation
· Variant matching phone numbers, emails and postcodes written in different formats
· Cross-file comparison the same customer appearing in two or three exports
· Merge instead of delete keeping the most complete record
WHAT YOU GET
· A cleaned .xlsx or .csv
· A separate sheet listing every row I removed or merged, so you can check my work
· Row counts before and after
· Anything borderline is flagged for you to decide, never deleted silently
HOW I WORK
I never delete anything without leaving a trace. You always get the removed rows back in a separate sheet. If two records are genuinely ambiguous, I flag them rather than guess.
Send me your file and I will tell you honestly what can and cannot be cleaned.
Technology:
Excel
•
Google Sheets
•
Python
Expertise:
Data manipulation
•
Normalization
My Portfolio
FAQ
How do you decide what counts as a duplicate?
Exact matches first — identical rows. Then fuzzy matches: the same name with different spelling, spacing or capitalisation, and matching phone, email or postcode. Anything borderline I flag and send to you instead of deleting.
Will you delete data I still need?
No. Nothing is deleted permanently. You get the cleaned file plus a separate sheet listing every row I removed or merged, so you can check my work and restore anything you want back.
My files are messy — emails in caps, phone numbers with spaces. Can you handle that?
Yes. I normalise emails to lowercase, strip spaces and symbols from phone numbers, and standardise postcodes before comparing. That is usually where most duplicates are hiding.
Do you keep my data after delivery?
No. Your files are deleted once the order is delivered.
