Excel Data Cleanup Expert

₹750-1250 INR / hour

Posted 1 minute ago

•

Ends in 6 days

₹750-1250 INR / hour

I have several existing Excel workbooks that need a meticulous once-over. Your primary mission is to hunt down every duplicate row, typo, inconsistent name, and any date or numeric value that’s in the wrong format, then correct or remove it so the files are 100 % error-free. Nothing is being imported from PDFs or CSVs on this job—everything is already in .xlsx form. Beyond the cleanup itself, I’d like the sheets laid out so a colleague can skim them without wondering what each column means. That means tidy column widths, filtered header rows, and light but professional formatting. If a quick formula or two (e.g., conditional counts to confirm no lingering blanks) helps validate accuracy, please weave it in. Deliverable: • The original workbooks returned as polished, fully validated Excel files, ready for immediate use. When you reply, briefly outline similar Excel data-cleaning projects you’ve completed and your estimated turnaround time and price. I’m looking to award quickly to someone who can demonstrate both speed and precision.

Project ID: 40821862

About the project

2 proposals

Open for bidding

Remote project

Active 21 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 ₹775 INR/hour for this job

User Avatar
Flag of GERMANY

Duplicate rows, typos, name variants and dates stored as text are what make shared workbooks hard to trust, so I would go through each file sheet by sheet. I start by flagging duplicates and finding the inconsistent spellings of each name in a lookup column. Then I convert text dates and numbers to real Excel formats and fix or remove each problem in a copy, so nothing is lost by accident. Each sheet gets filtered headers, frozen top rows, fitted column widths and light formatting, plus a small check block with COUNTBLANK and COUNTIF formulas so your colleague can see there are no blanks or duplicates left. You get your original .xlsx files back cleaned, with a short change log sheet in each. I have done data cleaning and validation in my research work since 2014 (PhD, Frankfurt, 30+ publications) and have 2 completed projects on Freelancer with 5 stars. Turnaround is up to 3 days. I can clean one sheet for free first so you can check the result. How many workbooks are there, and roughly how many rows does the largest one have? Wahed

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

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

打开我的订阅