Excel Customer Data Cleanup
Budget: ₹12,500 – ₹37,500 INR
I have one Excel worksheet packed with customer data that now needs a tidy-up. Your job is to comb through the sheet, remove every duplicate record, and apply clear, consistent formatting to the remaining cells so the information is instantly readable and ready for reporting.
The file is already in a single sheet, so there’s no consolidation work—just precision cleaning. Once finished, return the updated .xlsx and a short summary of what you changed so I can trace the steps later.
Acceptance criteria:
• Zero duplicate rows remaining
• Uniform formats for names, phone numbers, e-mails, dates, and currency fields
• Row count and key totals match my post-cleaning spot checks
• Clean file delivered in .xlsx with a brief change log
The file is already in a single sheet, so there’s no consolidation work—just precision cleaning. Once finished, return the updated .xlsx and a short summary of what you changed so I can trace the steps later.
Acceptance criteria:
• Zero duplicate rows remaining
• Uniform formats for names, phone numbers, e-mails, dates, and currency fields
• Row count and key totals match my post-cleaning spot checks
• Clean file delivered in .xlsx with a brief change log
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Excel Macros
Data Cleansing
Data Analysis
Data Management