Start with a container loading Excel template, add your packages and bring the packlist into CargoSNX. Check the data, then turn the rows into a visible container plan.
A practical guide with inspectable inputs and a calculated example.Use one row per package type: a clear description, quantity, external length, width, height and weight per piece. Add handling rules such as stackability and allowed rotation. A spreadsheet stores the inputs; the planner calculates their arrangement.
Millimetres for dimensions. Kilograms per piece. A blank template and the filled example used on this page.
Enter the outer dimensions of a carton, crate or loaded pallet, not the product inside it. The downloadable files use millimetres and kilograms. For a pallet, include its base and any overhang in the final external dimensions. Use a separate row when dimensions or handling rules differ.
Quantity is the number of shipping units with that row’s dimensions. Weight is gross kilograms for one of those units. For example, 20 cartons at 8 kg each means a quantity of 20 and a weight per piece of 8 kg. Entering 160 kg as the unit weight would multiply the shipment weight again.
Open the planner, choose the Excel/CSV import and select your file. Check the column mapping, units and preview. Resolve missing values or skipped rows before accepting the import. With a supplier’s own spreadsheet, pay particular attention to whether a weight column refers to one piece or the whole row.
Set whether each package may rotate, tip or carry another package. Where relevant, enter the permitted top load and unloading group. Then select the container, calculate and review the remaining pieces. The template does not calculate a load plan inside Excel; it prepares your inputs for CargoSNX.
The filled workbook contains the packlist shown below. Its dimensions and quantities are also the inputs for this container comparison, so you can follow the data from the spreadsheet into the planner.
| Package | L × W × H (mm) | Quantity | kg / piece | Total m³ |
|---|---|---|---|---|
| Large cartons | 1,000 × 750 × 650 | 80 | 18 | 39 |
| Medium cartons | 800 × 600 × 650 | 40 | 13 | 12.48 |
| Small cartons | 600 × 400 × 650 | 30 | 9 | 4.68 |
| Shipment total | 2,230 kg | 150 | — | 56.16 |
| Container preset | Inside L × W × H (mm) | Placed | Remaining | Volume use |
|---|---|---|---|---|
| 20ft standard | 5,898 × 2,352 × 2,393 | 51 | 99 | 74.9% |
| 40ft standard | 12,032 × 2,352 × 2,393 | 128 | 22 | 76.5% |
| 40ft high cube | 12,032 × 2,352 × 2,697 | 150 | 0 | 73.6% |
More volume use does not mean more of the order loaded. The standard 40ft uses a larger percentage of its interior in this example, but the high cube places all 150 cartons. Read the placed and remaining counts together with the volume percentage.
Preview the example, then choose to load it in the planner.
The tables use the CargoSNX container presets. Equipment varies by manufacturer and unit: Hapag-Lloyd’s container specifications describe that variability, and its 40ft high cube reference provides a carrier example. Check the booked container’s internal dimensions, door opening and payload before using a plan.
This example uses rectangular packages and the stated handling rules. It does not simulate cargo securing, packaging strength, equipment access or the full physical loading path, and it does not prove that the calculated arrangement is optimal. Include the relevant operational checks before loading.
The download is a packlist template for Excel. The loading calculation runs in CargoSNX after import. The workbook itself does not solve or display a 3D packing arrangement.
Yes. CargoSNX supports spreadsheet and CSV packlists. A CSV version of this example is available below. Check its units and mapped columns in the import preview just as you would for an Excel file.
The supplied template uses millimetres. The importer also supports other selectable units, including centimetres, metres and inches. Confirm the chosen unit in the preview; a unit mismatch changes every package dimension.
You can try importing an existing packlist and review the detected columns. If it mixes units, contains ambiguous weights or uses complex merged headings, the template provides a simpler structure to copy the relevant data into.
Ladeplan wird geöffnet…