Excel Customer Data Cleanup -- 2
Budget: $15 – $25 USD
I’m handing over a raw Excel file containing roughly 1,000–5,000 rows of customer information and need it returned within 3–5 days in a condition that my team can immediately use.
Please clean up obvious errors and duplicates, standardise column formats (dates, phone numbers, names), convert the sheet into a proper Excel Table, and insert a few basic formulas so we can instantly see simple totals and averages. The source file will be supplied as soon as the project starts, and I’m happy to answer any clarifying questions along the way.
Deliverables:
• A single, well-structured .xlsx workbook with the data fully cleaned and organised
• Basic summary formulas in appropriate columns or a separate summary sheet
• A brief changelog highlighting any major assumptions or transformations applied
Let me know your availability so we can keep the turnaround tight and smooth.
Please clean up obvious errors and duplicates, standardise column formats (dates, phone numbers, names), convert the sheet into a proper Excel Table, and insert a few basic formulas so we can instantly see simple totals and averages. The source file will be supplied as soon as the project starts, and I’m happy to answer any clarifying questions along the way.
Deliverables:
• A single, well-structured .xlsx workbook with the data fully cleaned and organised
• Basic summary formulas in appropriate columns or a separate summary sheet
• A brief changelog highlighting any major assumptions or transformations applied
Let me know your availability so we can keep the turnaround tight and smooth.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Excel VBA
Excel Macros
Data Analysis
Data Management