How to bulk convert product weights in excel from kilograms to pounds
- Step 1Export your product catalogue — Download the .xlsx or .csv product feed with the weight column in kilograms.
- Step 2Set the conversion rule — Enter the weight column name, choose Multiply, enter 2.20462, and name the output column (e.g. 'Weight_lbs').
- Step 3Download and re-import — The converted weight column is ready to map to your e-commerce platform's weight field.
Frequently asked questions
Can I also convert cm to inches in the same run?+
Yes. Add a second rule: column 'Length_cm', Multiply, 0.393701. Multiple rules are applied in one pass.
Does it work with Shopify's weight_unit column?+
The tool converts numeric values only. You would still need to update the weight_unit column from 'kg' to 'lb' separately.
My weights have commas as thousands separators — will it fail?+
The tool strips commas before parsing. Values like '1,234.5' are parsed correctly as 1234.5.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.