I will do excel data cleaning and cleanup, remove duplicates, format CSV files
About this Gig
Data cleaning for Excel and CSV files. I clean, deduplicate and format them, and show what changed.
Every package: cleaned file, change log, before-and-after summary.
Clean means: trim whitespace, fix case, dates to YYYY-MM-DD, prices to 2 decimals, quantities as integers, dedupe on your unique key. Duplicates removed, first kept, rest listed. Blank-key rows listed for your decision. Max 20 columns. No research, enrichment, or formula/macro repair.
I never overwrite your original. Check the change log before using the file.
Process:
1. Send file + unique key (SKU, email, product code, or name+email/phone).
2. I clean it: 2 days (Basic), 3 days (Standard/Premium).
3. Check the report, request fixes. A revision is changes within the agreed rules, not new rules.
Your data: mask NRIC/FIN, cards, passwords before sending. Names/emails/phones are used only to match and dedupe. These fields stay on my computer, never sent to AI tools. AI review sees only the change log and a masked sample. Prefer no AI at all? Tell me before ordering - scripts only. I delete my copies 30 days after delivery.
Sample: 31 rows became 29 clean rows - 1 duplicate removed, 1 blank-key row removed.
FAQ
What file types do you accept?
Excel (.xlsx, .xls) and CSV.
What is the unique key?
The column that should be unique for each row, like SKU, email, order number, or product code.
Will you delete my original data?
No, you keep your original file, I send a cleaned copy plus a change log.
Do you use AI?
Yes, AI tools are part of my workflow. I check the change log and a sample on every delivery.
Can you clean more than 10,000 rows?
Yes — message me first for a quote.

