Excel Product Data Cleanup

₹750-1250 INR / hour

Posted 1 minute ago

•

Ends in 6 days

₹750-1250 INR / hour

I have a product-inventory spreadsheet that needs a careful round of data entry and cleanup in Excel. The file contains several hundred rows that currently suffer from gaps, typos, and inconsistent column placement. Your task is to transform this into a tidy, reliable dataset I can import straight into my system. Please focus on: • Fixing any missing or incorrect product details (descriptions, SKUs, prices, quantities). • Re-structuring the sheet so every field sits in a clear, consistently named column and category. Feel free to lean on Excel tools such as Power Query, advanced filtering, or formulas—whatever speeds up accurate results. The final deliverable is a well-formatted .xlsx file plus a short note summarising the main fixes you applied.

Project ID: 40820425

About the project

1 proposal

Open for bidding

Remote project

Active 29 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

1 freelancer is bidding on average ₹800 INR/hour for this job

User Avatar
Flag of GERMANY

Your inventory sheet has gaps, typos and columns that drift between rows, so it can't go straight into your system yet. I would first load the file into Power Query and map every field to one fixed, clearly named column: SKU, description, category, price, quantity. Then I would fix typos and formats, check prices and quantities for impossible values, flag duplicate or missing SKUs, and fill in missing details wherever the sheet itself gives the answer. You get a clean .xlsx with one consistent table plus a short note that lists the main fixes and any rows I could not resolve without your input. I have worked with data cleaning and text processing since 2014, during my PhD research in Frankfurt, Germany. Before you award the project, I can clean the first 20 rows for free so you can check the result. One question: does your import system need a specific column order or template, or should I define the structure myself? Wahed

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

阅读原文 ↗

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

打开我的订阅