CSV Cleanup for Real-World Data (24h)
Need clean data you can trust? I specialize in quick, reliable CSV/Sheet cleanup.
What I do:
• Remove duplicates based on YOUR columns
• Normalize casing/spaces, standardize emails/phones
• Return a clean CSV/XLSX in 24 hours
Proof included:
• Notes.txt with the exact rules used (PROPER, LOWER, TRIM, Regex)
• Before/after row counts so you can verify the result
How we work:
1) You share the file + which columns define duplicates + 2–3 edge cases.
2) I run a tiny sample and confirm the package (Starter/Plus/Pro).
3) I clean the data and deliver with Notes.txt so you can repeat the steps.
Trust & privacy:
• NDA-friendly on request
• Files deleted within 7 days of final delivery
• One minor revision included (typos/formatting)
Tools: Google Sheets, Microsoft Excel, Regex, Google Apps Script.
Work Terms
Availability
• Response within 24h, delivery within 24h for Starter/Plus/Pro packages.
Process
• Intake: file (CSV/XLSX or Google Sheet), columns that define duplicates, 2–3 edge cases.
• Sample: I’ll clean 5–10 rows to confirm rules and package.
• Delivery: cleaned.csv (+ .xlsx if requested) + Notes.txt (rules + before/after counts).
Payments
• SafePay (escrow) only for fixed packages: $5 / $10 / $15.
• One minor revision included within 3 days of delivery.
Scope
• Standardization: PROPER(names), LOWER(emails), TRIM, phone digits via REGEXREPLACE.
• Out-of-scope examples: complex fuzzy matching, entity resolution across multiple sources, custom parsers for highly inconsistent free text (can be quoted separately).
Confidentiality
• NDA-friendly. I delete working files within 7 days of final delivery.
Communication
• Guru messages preferred. Share a Google Sheet link with view or edit access as needed.