Excel Data Cleanup Assistance
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
My Microsoft Excel workbook needs a proper scrub so the information inside can be trusted and reused without manual fixes each time. The sheet contains several hundred rows gathered from different sources, so duplicates, mismatched date and number formats, stray blanks, and the occasional typo are all present.
Your task is to inspect the file, clean every inconsistency you find, and return a single, polished .xlsx ready for immediate reuse.
Deliverables
• Cleaned Excel file with consistent formats, no duplicates, and any missing-value handling clearly indicated
• Brief change log on a separate tab (or Word/Notepad file) summarising what was fixed and any outstanding data issues you spotted
Acceptance criteria
• Column order remains logical and intact
• Dates, currencies, and percentages follow one uniform style throughout
• No duplicate records when tested with standard Excel “Remove Duplicates” settings
• All formulas (where present) recalculate correctly after the cleanup
Feel free to outline your approach—Power Query, VBA scripts, formulas, or any other Excel tools are welcome—as long as the final workbook opens error-free on Excel 2019 and later. I’m ready to share the file as soon as we agree on the timeline.
Your task is to inspect the file, clean every inconsistency you find, and return a single, polished .xlsx ready for immediate reuse.
Deliverables
• Cleaned Excel file with consistent formats, no duplicates, and any missing-value handling clearly indicated
• Brief change log on a separate tab (or Word/Notepad file) summarising what was fixed and any outstanding data issues you spotted
Acceptance criteria
• Column order remains logical and intact
• Dates, currencies, and percentages follow one uniform style throughout
• No duplicate records when tested with standard Excel “Remove Duplicates” settings
• All formulas (where present) recalculate correctly after the cleanup
Feel free to outline your approach—Power Query, VBA scripts, formulas, or any other Excel tools are welcome—as long as the final workbook opens error-free on Excel 2019 and later. I’m ready to share the file as soon as we agree on the timeline.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.