Spreadsheet Data Cleanup Assistant
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
I have several Excel and Google Sheets files that hold data originally pulled from various documents. They need more than a simple copy-paste: the information must be cleaned, standardized, and logically organised so the sheets are ready for day-to-day use.
Here’s what I need you to handle:
• Review each worksheet, locate inconsistent formats, and apply one clear structure for dates, phone numbers, and other key fields.
• Remove duplicates, merge partial records where appropriate, and flag any obviously incorrect or blank entries for my quick review.
• Re-order columns into a sensible, intuitive layout and add basic filters or data-validation rules so future edits stay tidy.
• Deliver the final, polished spreadsheet in both its native format and as a downloadable CSV backup.
Accuracy and discretion are vital because the sheets contain live operational data. If you’re comfortable working directly in Google Sheets as well as in local Excel files—and you have a keen eye for detail—I’d love to see how you can streamline this dataset.
Here’s what I need you to handle:
• Review each worksheet, locate inconsistent formats, and apply one clear structure for dates, phone numbers, and other key fields.
• Remove duplicates, merge partial records where appropriate, and flag any obviously incorrect or blank entries for my quick review.
• Re-order columns into a sensible, intuitive layout and add basic filters or data-validation rules so future edits stay tidy.
• Deliver the final, polished spreadsheet in both its native format and as a downloadable CSV backup.
Accuracy and discretion are vital because the sheets contain live operational data. If you’re comfortable working directly in Google Sheets as well as in local Excel files—and you have a keen eye for detail—I’d love to see how you can streamline this dataset.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.