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 address

Benefits 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

User Avatar
Flag of GERMANY

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,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅