Excel Raw Material Inventory Cleanup
Budget: €12 – €18 EUR
I have a single-sheet Excel file that tracks our raw material inventory. Before we load it into our ERP, I need the data professionally cleaned. The two priorities are:
• Error correction – spot and fix typos, mis-keyed numbers or dates, misaligned columns, and any logical inconsistencies that would break formulas once the sheet is imported.
• Standardization of formats – every SKU, unit of measure, date, and currency entry must follow one consistent format so downstream reports read them correctly.
The file is straightforward—no hidden links or complex formulas—so the task is mainly careful auditing and reformatting. You may use Excel’s built-in tools, VBA macros, or Power Query; I only care that the finished workbook is accurate, uniformly formatted, and ready for bulk upload.
Deliverables
• The cleaned Excel workbook.
• A brief change log summarizing the main issues you corrected and the rules you applied for standardization.
If you can turn this around quickly and double-check your work for accuracy, let’s talk.
• Error correction – spot and fix typos, mis-keyed numbers or dates, misaligned columns, and any logical inconsistencies that would break formulas once the sheet is imported.
• Standardization of formats – every SKU, unit of measure, date, and currency entry must follow one consistent format so downstream reports read them correctly.
The file is straightforward—no hidden links or complex formulas—so the task is mainly careful auditing and reformatting. You may use Excel’s built-in tools, VBA macros, or Power Query; I only care that the finished workbook is accurate, uniformly formatted, and ready for bulk upload.
Deliverables
• The cleaned Excel workbook.
• A brief change log summarizing the main issues you corrected and the rules you applied for standardization.
If you can turn this around quickly and double-check your work for accuracy, let’s talk.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Inventory Management
Excel Macros
Data Analysis
Data Management