Excel Data Cleanup & Structuring
₹750-1250 INR / hour
Posted 1 minute ago
•
Ends in 6 days
₹750-1250 INR / hour
I have a single Excel workbook filled with customer and other contact-related details that now needs thorough, professional cleanup. You will start by removing every repeated record except the very first instance, then clear out blank rows and any obvious data-entry errors. Once the sheet is duplicate-free, I need the content fully standardized—dates in a consistent format, currency values aligned to one style, text properly capitalized, and phone numbers brought to a uniform pattern. Where columns have been lumped together (for example, full names or combined address lines) you’ll separate them, and where data is unnecessarily split you’ll merge it, so the final layout sits in well-defined Excel tables that make future filtering and analysis effortless. To wrap up, document what you changed so I can trace your logic or quickly roll back if needed. Deliverables • A clean, ready-to-use Excel file • A brief summary outlining the transformations performed
Project ID: 40811482
About the project
2 proposals
Open for bidding
Remote project
Active 20 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
2 freelancers are bidding on average ₹800 INR/hour for this job


A single Excel workbook with your contact data deduplicated (first record kept), standardized and set up as proper Excel tables, plus a short change summary you can use to trace or roll back any step. I remove repeat records and blank rows, then unify dates, currency, capitalization and phone patterns. Combined fields like full names or address lines get split, and fragmented ones get merged. Every change goes into a log sheet with the original value next to the new one, so rolling back is easy. Doubtful entries are marked instead of guessed. I also re-check row counts before and after, so nothing disappears without a record. My banking background means I'm used to working carefully with customer data, and I work under GDPR. My portfolio has a "Messy list → clean data" sample. Which date and phone formats do you want as the final standard, and roughly how many rows are in the file? I can also clean a small sample first. Moritz
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗