> For the complete documentation index, see [llms.txt](https://doc.loadmaster.biz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.loadmaster.biz/4-ui-and-terminologies/4.3-cargo/4.3.1-methods-of-adding-cargoes/4.3.1.1-import-in-bulk-through-excel.md).

# 4.3.1.1 Import in Bulk through Excel

If the cargo data is not maintained in database and the quantity is large, you can import the cargo data in batches through the excel template.

Let's use an example to explain more: add following 12 kinds of goods to the task.

| Name | quantity | length（mm） | width（mm） | height（mm） | weight（kg） |
| ---- | -------- | ---------- | --------- | ---------- | ---------- |
| A    | 20       | 860        | 950       | 2020       | 10         |
| B    | 15       | 860        | 980       | 2020       | 8          |
| C    | 18       | 980        | 980       | 1120       | 7          |
| D    | 42       | 680        | 600       | 640        | 5          |
| E    | 40       | 610        | 600       | 600        | 3          |
| F    | 20       | 820        | 710       | 790        | 8          |
| G    | 25       | 590        | 520       | 560        | 2          |
| H    | 40       | 670        | 550       | 610        | 5          |
| I    | 54       | 870        | 855       | 270        | 17.7       |
| K    | 65       | 890        | 690       | 450        | 21.5       |
| L    | 60       | 1500       | 690       | 470        | 24.6       |
| M    | 40       | 820        | 560       | 340        | 18.9       |

Specific steps:

1\)Click \[Cargo] on the left to enter the cargo interface. First, you should get the import template, click \[Get Excel Template] under \[Add Cargo] to download the template, open and fill in it.

![](/files/-MDn1Yluh_iI5hHWS9Qq)

2\)Read the “template description” firstly, and then fill in the template. ①First copy the name, quantity, length, width, height and weight of the goods into the template, which are required items in red. Pay attention to the matching of the units. Note: The size units in the order is mm, therefore we also need to change the units in the template to mm. “Weight” refers to the gross weight of a single carton or box of goods. If the cargo is too light, the “Weight” can be ignored and not filled in, and the system will default to "1".

![](/files/-MDn1aMcDB6llUK8udlv)

②Then define the load orientations of the goods. There are six load orientations: stand, stand & rotate, side, side & rotate, lay and lay & rotate. Leave it blank or “1” means allowed such placement method, “0” means not allowed. For example, only stand and stand & rotate are allowed.

![](/files/-MDn1dgOUCkzNsb7YCaL)

"Support others" is to define whether goods can only be stacked by themselves not other goods. Blank or “1” is allowed, “0” is not allowed. "Max stack" refers to the maximum number of layers allowed to be stacked on the goods themselves. No need to fill in if there is no such requirement.

"max overhang ratio" is not required to fill in if there is no such requirement. For detailed explanation, please refer to the help document.

③ Fill in the loading attributes of the cargo: just fill in the required parameters, the ones that are not required can be ignored. Please refer to the help documentation for detailed explanation of each parameter.

If the cargo has a loading requirement that the heavier cargo can not be placed on the lighter cargo, we can use the "stacking order" to satisfy it. The value of "stacking order" indicates the vertical order of the goods. Goods with a higher value of "stacking order" will be placed under the goods with a lower value. The "stacking order" is a relative value, the higher the value, the stronger the load-bearing capacity of the goods, and the more they will be placed below. The default value in system is “10”.

If the goods should be loaded sequentially, we use "loading sequence" to achieve it. The value of the "loading sequence" indicates the order in which the goods are loaded. It is a relative value, the larger the value, the more the goods are loaded first. The default value in system is “0” .

![](/files/-MDn1hQ4poOnBsmZ7EkL)

After the template is finished to fill in, save and close it. Go back to the cargo interface, click \[Import from Excel] under \[Add cargo], find the filled-in template in the dialog box and open it, all cargo data will be imported into this task.

![](/files/-MDn1j9gREVF1DJqr3Kx)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://doc.loadmaster.biz/4-ui-and-terminologies/4.3-cargo/4.3.1-methods-of-adding-cargoes/4.3.1.1-import-in-bulk-through-excel.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.