← Portfolio

Excel Tools Add-in

Simulated taskpane — sample data Scenario: this export just came out of the ordering system. The ERP will reject every row — item numbers must be zero-padded to 6 digits. Fix the whole column in one click.
Excel item-import.xlsx
A — Item #B — DescriptionC — BinD — Qty

Excel Tools

Data-prep utilities for ERP import

The ERP system this team imports into requires fixed-width, zero-padded item and bin numbers. Before the add-in, staff padded thousands of cells by hand or with fragile formulas. The deployed version is a packaged Office.js add-in: select a range in Excel, click once, done.