Inventory Excel Data Cleanup
Budget / Salary₹12,500–37,500
TypeFreelance project
LocationRemote
Posted2 hours ago
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.
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.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.