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 addressBenefits 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


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