Inventory Excel Data Cleanup
₹12500-37500 INR
Posted 1 minute ago
•
Ends in 6 days
₹12500-37500 INR
Paid on delivery
I have an inventory spreadsheet that has become cluttered over time and now needs a thorough clean-up. My priority is to organise the file so every item record is complete and easy to read. The biggest headache is duplicate or missing item details. Rather than deleting anything outright, I want every suspected duplicate clearly marked so I can review and approve removals myself. Alongside flagging duplicates, please standardise column headings, tidy inconsistent text (SKU, description, category, unit, etc.), and make sure each row follows the same structure. Quantities and prices are largely correct, so they only need attention if an error is obvious. Deliverables: • A reformatted Excel workbook with consistent columns and cleaned data • All potential duplicates highlighted or collected on a separate “Duplicates Flagged” sheet for my review • A brief note or embedded steps (Power Query, formulas, or simple VBA) so I can rerun the process in future Accuracy is more important than speed, and the finished file should be something I can maintain easily going forward.
Project ID: 40814653
About the project
6 proposals
Open for bidding
Remote project
Active 8 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
6 freelancers are bidding on average ₹19,017 INR for this job


Your inventory spreadsheet duplicate-flagging and column cleanup job is exactly the kind of work I do best. I understand your core requirement: nothing gets deleted until you have personally reviewed and approved it. Every suspected duplicate surfaces on a dedicated 'Duplicates Flagged' sheet, never buried in conditional formatting alone. Here is my exact execution plan: Duplicate Detection: I will use COUNTIFS across SKU, description, and category columns combined to catch both exact matches and near-matches where someone entered the same item under a slightly different SKU. Flagged rows get a high-contrast fill and are copied to the review sheet automatically. Column Standardisation: Power Query transformations will normalise every heading and tidy inconsistent text across SKU, description, category, and unit fields so every row follows the same predictable structure you asked for. Data Integrity Pass: Quantities and prices get a quick outlier scan only — no touching values that look correct. Repeatable Handoff: I will embed a documented Power Query refresh sequence so you can rerun the entire process yourself with one click, no developer needed. One problem worth flagging that your description does not cover: merged cells in inventory files frequently break Power Query refresh silently. I will unmerge and restructure any merged header rows before building the query so future refreshes do not fail on you.


1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction


Hi, the hard part is telling true duplicates from near-matches, since a SKU typed two ways or a blank description can make two real items look alike. I would first list every heading, category and unit so the rules follow your data. Then I would set one heading and format per column, tidy the text, and leave quantities and prices alone unless an error is obvious. Each suspected duplicate goes to a Duplicates Flagged sheet with its match and reason, so nothing is deleted until you approve it. A steps sheet in the workbook lets you rerun the clean-up on the next export. You would have the cleaned file and flagged sheet within 2 days of award.


Duplicate and incomplete item records make an inventory file hard to trust, and you want them flagged for your review, with nothing deleted. I would first standardise the headings and fix the text in SKU, description, category and unit (trimming, consistent case, unified unit names), then give every row the same column structure. Suspected duplicates, both exact SKU matches and near matches on the description, go to a "Duplicates Flagged" sheet with the row reference and the reason. Rows with missing details get highlighted. Quantities and prices stay as they are unless an error is obvious, and I list every such change. The cleanup runs as a Power Query, with a short instruction sheet in the workbook, so you can refresh it on new data. Based in Frankfurt, Germany, I have worked on data processing since 2014 (PhD in computer science, 30+ publications). Before you award the project, I can clean the first 20 rows for free so you can check my approach. Which column should count as the unique item key, the SKU or a combination such as SKU plus unit? Wahed
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗