Data Cleaning Portal

Normalize product units & export with standardized columns

1 Upload source file

Accepted formats: .xlsx, .xls, .csv

Drag & drop a file here, or

Master units

These are the valid units source data is matched against. Add aliases (comma separated) so messy inputs like millilitre still match ML. Stored in your browser.

CodeFull nameNames / aliasesTypeBase factor

Packaging map

Maps the packaging / product-code suffix (supplier code) to the Order Unit. e.g. CTN → CT, EA → ST, KEG → FA. Seeded from your Unit List; edit as suppliers add codes. Stored in your browser.

Supplier codeOrder Unit