Cargo-Planner Docs

Importing cargoes

Importing cargoes

To speed up the process of entering data, cargoes can be imported to your load list directly via Excel or via the Cargo Library.

Import via Excel

Cargo-Planner supports importing cargoes from xlsx files. To import your cargoes, click on the import button and select "Import from Excel file" from the 1. Data view.

Import from Excel file option

Select the Excel file that you want to import and press "Open".

Excel file selection

A dialog will be shown where you can choose between letting the software try to read the Excel file automatically or if you want to setup the mappings of columns manually. You can control if the previous data in the load list should be replaced by the parsed data. If this option is disabled, the new data will be added after the last item in your load list.

Excel reader dialog

When selecting "Try to read file automatically", the software tries to find a map the column names in the Excel file to the matching cargo properties. If the Excel file was successfully parsed, the parsed cargoes with its corresponding properties will be shown in the preview table shown below.

Excel parser preview with successful mappings

If the software fails to parse your Excel file or are not extracting all cargo properties, you can either download and use our Excel template or set your own custom mappings by pressing the "Change column mappings" button.

When you are happy with the cargoes shown in the preview table, click on "Import" to add these cargoes to your load list.

Excel parser preview import button highlighted

Cargo properties

The following cargo properties can be imported via Excel files. You can see more details regarding cargo properties here.

  • Item - text
  • Length - number
  • Width - number
  • Height - number
  • Weight - number
  • Quantity - number
  • Stackable - "Yes" or "No"
  • Bottom Only - "Yes" or "No"
  • Tiltable - "Yes" or "No"
  • Longship - "Yes" or "No"
  • Layers - number
  • Consignment - text
  • Priority - number
  • Geometry - "Box", "Drum" or "Pipe"
  • Palletize - "Yes" or "No"
  • Unit Quantity - number
  • Class - name of class in segregation table
  • Load in - comma-separated list of container names (e.g. 20ft DV,40ft DV)

Use our Excel template

Feel free to use our Excel template that can be downloaded by clicking on the import button and select "Download Excel template" from the 1. Data view.

Download Excel template

When using the Excel template, select the correct weight and length dimensions and enter your cargo items.

Excel template with highlighted dimensions

Custom mappings

Under "Change column mappings", you can specify how you want to import your Excel file:

  • Sheet No. - select sheet to import.
  • Header Row No. - specify row number of header row. Header row should contain column names.
  • Columns - specify the column designation for each cargo property that you want to parse. For example, setting Description to "A" will make sure that values in column A will be parsed as the description cargo property.
  • Filter - specify if some rows should not be parsed by combining the column mapping with a value that needs to be present. For example, setting Column to "A" and the must contain field to "123" will only parse cargoes where column A includes value "123".

Excel parser custom mappings

After you have changed your mappings, click "Proceed" to parse the file.

Import via Cargo Library

Add cargoes to a load list from your Cargo Library by clicking on the import button and select "Import from Cargo library" from the 1. Data view.

Import from Cargo Library option

A dialog is shown with all cargoes in the Cargo Library. Select the cargoes that you want to import by clicking the checkboxes. Close the dialog to add the selected cargoes to the load list.

Import from Cargo Library

Cargo-Planner © 2023
Törnblom Software AB
Made in Sweden