Manual Inventory Update in Sheets
Budget: $10 – $30 CAD
I need my current product inventory figures transferred from a set of Excel workbooks into a Google Sheets file that I will share with you. The numbers must be keyed in manually—no scripts or bulk imports—because I want each line double-checked for accuracy, naming consistency, and any anomalies that might have crept into the source files.
You will receive:
• A folder containing the latest Excel sheets, clearly named by date.
• Access to the Google Sheets template with pre-defined columns.
Deliverable:
• The Google Sheet fully populated and spot-checked, ready for me to run summaries as soon as you finish. All quantities, SKUs, and descriptions must match what appears in the original Excel files.
Acceptance criteria: every row from the source sheets is present, numeric columns total correctly, and any discrepancies are flagged in the comments column.
If you are detail-oriented and comfortable working inside both Excel and Google Sheets, this should be a straightforward task.
You will receive:
• A folder containing the latest Excel sheets, clearly named by date.
• Access to the Google Sheets template with pre-defined columns.
Deliverable:
• The Google Sheet fully populated and spot-checked, ready for me to run summaries as soon as you finish. All quantities, SKUs, and descriptions must match what appears in the original Excel files.
Acceptance criteria: every row from the source sheets is present, numeric columns total correctly, and any discrepancies are flagged in the comments column.
If you are detail-oriented and comfortable working inside both Excel and Google Sheets, this should be a straightforward task.
Related categories:
Visual Basic
Data Processing
Excel
Inventory Management
Data Analysis
Google Sheets
Data Management