Packing List Template (Excel)
A free Excel packing list for export and domestic shipments. Enter carton numbers, items, weights and carton sizes: the template works out the number of cartons, total quantities, net and gross weight, and the volume in cubic metres (CBM) and cubic feet, and checks every line.
Download
Download the packing list template (.xlsx)
Free, no sign-up. Version 1.3.0, Excel workbook (.xlsx), about 50 KB. No macros. Built for Excel 2010 or later; also opens in LibreOffice Calc.
Simple packing list in pieces and kg, with stickers
For goods counted and weighed one by one, such as rolls, coils, bags or drums: an internal list where each numbered line (SN) holds the quantity and the net weight in kg. Ninety lines print on one A4 page with the totals and the average weight per piece. A Stickers sheet prints eight labels per A4 page from the same list, each with the item code and name, SN, quantity and kg, and the production and expiry dates when you fill them in.
Download the pieces and weight packing list (.xlsx)
Free, no sign-up. Version 1.3.0, Excel workbook (.xlsx), about 17 KB. No macros. For internal use in the warehouse; for export shipments use the carton packing list above.
Who it is for
Shippers, exporters, warehouse dispatch teams and small businesses that send cartons by sea, air, road or courier and need a clear list of what is in each carton, with totals that add up.
What a packing list is for
A packing list tells everyone who handles a shipment what is in each package: the carton numbers, the items and quantities in them, and their weights and sizes. The shipper packs to it, the carrier or forwarder uses its weights and volume to book space, customs may check cartons against it, and the receiver uses it to check the delivery carton by carton.
It is not a commercial invoice. A packing list has no prices or payment terms; the commercial invoice shows the value of the goods for payment and customs duty. Most export shipments need both, with matching quantities.
What is in the file
- Packing List: shipper, consignee, notify party, packing list, invoice and order numbers, date, ship by (sea FCL or LCL, air, road, rail, courier), container or truck and seal number, places of loading and discharge, marks and numbers, and 100 lines (18 shown; click + to show the rest).
- Worked out for you: cartons from the carton number range, total quantity, total net and gross weight, CBM per carton and in total, cubic feet, the carton numbers used, any gaps in the numbering, and a Check column on every line.
- Line checks: carton numbers missing or overlapping another line, “to” below “from”, gross weight below net weight, missing item code, quantity, gross weight or carton size.
- Units: sizes in cm or inches, weights in kg or lb. The column headings change with your choice.
- Example sheet with made-up data, and an Instructions sheet.
- Printing: landscape, a list of up to 18 lines on one page with the totals and signature boxes; longer lists continue on more pages with the column headings repeated.
How the totals are worked out
Cartons = carton no. to − carton no. from + 1. Cartons 1 to 20 are 20 cartons; a single carton has the same number in both columns.
CBM per carton = length × width × height ÷ 1,000,000 (cm), or × 0.000016387064 (inches).
Totals = cartons × the figure per carton. Cubic feet = CBM × 35.3146667.
Example from the file: 20 cartons of 40 × 30 × 25 cm are 0.030 m³ each, 0.600 m³ in total, and at 10.8 kg gross each they weigh 216 kg. The four example lines come to 61 cartons, 705 kg gross and 2.497 m³ (88.19 ft³).
Tips
- Weigh and measure a packed carton rather than using the catalogue size: carriers may re-weigh and re-measure.
- Mark the same carton numbers on the boxes as on the list, so a receiver can check a delivery carton by carton.
- To see how the cartons fit in a 20 ft or 40 ft container, enter the carton sizes in the CBM Calculator. For pallets, use the Pallet Calculator.