Importing from Excel or CSV
When you have more than a handful of items, entering them one by one is impractical. LOP's spreadsheet import lets you upload an Excel (.xlsx, .xls) or CSV (.csv) file containing your item list and brings all items into the plan in a single step.
This is the fastest way to get started when you already maintain cargo lists in Excel, or when your warehouse team exports packing lists in spreadsheet format.
Step 1: Prepare Your Spreadsheet
Your spreadsheet needs a header row in the first row, followed by one row per item. The columns can be in any order — LOP will detect and map them automatically — but the data must be clean and numeric for dimension and weight fields.
Recommended columns:
| Column | Required | Notes |
|---|---|---|
| Name / Description | Yes | Text label for the item |
| Length | Yes | Numeric only, no unit symbols |
| Width | Yes | Numeric only, no unit symbols |
| Height | Yes | Numeric only, no unit symbols |
| Weight | Yes | Numeric only, no unit symbols |
| Quantity | Recommended | Defaults to 1 if omitted |
| SKU | Optional | Passed through to reports |
| Fragile | Optional | Use 1/0, yes/no, or true/false |
| Stackable | Optional | Use 1/0, yes/no, or true/false |
| Max Weight on Top | Optional | Numeric, in kg or lbs |
| Notes | Optional | Free text |
LOP automatically detects your header row — it does not need to be in row 1. Summary rows above the header, merged cells, and metadata rows are handled automatically. If you enable AI Smart Detection, the system identifies headers, footers, and data boundaries with high accuracy.
Example spreadsheet:
| Name | Length | Width | Height | Weight | Quantity |
|---|---|---|---|---|---|
| Export Carton A | 600 | 400 | 300 | 12.5 | 20 |
| Steel Drum 200L | 580 | 580 | 880 | 185 | 8 |
| Pallet – Finished Goods | 1200 | 800 | 1400 | 420 | 4 |
Step 2: Open the Import Dialog
- Open your plan in the Editor.
- In the Items Panel on the left, click the Import button (it shows a spreadsheet icon).
- The import wizard will open.
Step 3: Upload Your File
Drag your Excel or CSV file into the upload area, or click Browse to select it from your computer. LOP accepts .xlsx, .xls, and .csv formats.
Once the file is uploaded, LOP reads the header row and the first several rows of data, then automatically suggests a column mapping.
Step 4: Review the Column Mapping
LOP displays a mapping table showing which column in your file corresponds to which item property. The auto-detection works by matching common column names in English, Turkish, and German.
Review each mapping and adjust any that were not detected correctly. Use the dropdown menus to assign columns manually if needed. You can also mark a column as Ignore if it contains data you do not want to import.
If your file uses non-standard column names — for example, "Pkg Length" instead of "Length" — simply select the correct property from the dropdown next to that column. LOP will remember your mapping for the rest of this import session.
Step 5: Set Dimension and Weight Units
Below the column mapping table, set the units that match the values in your spreadsheet:
Dimension unit:
- Millimeters (mm)
- Centimeters (cm)
- Meters (m)
- Inches (in)
Weight unit:
- Kilograms (kg)
- Pounds (lbs)
LOP converts all values to its internal unit system (millimeters and kilograms) automatically. You do not need to convert your spreadsheet first.
Choosing the wrong unit will result in items that are orders of magnitude too large or too small. Double-check that the unit you select matches the actual values in your file. If a 600mm box is imported as 600 inches, it will be nearly 15 meters long — the optimizer will be unable to fit it in any container.
Step 6: Preview Items
LOP shows a preview of the first several items as they will be created after applying the column mapping and unit conversion. Review the dimensions and weights to confirm they look correct before proceeding.
If something looks wrong, go back to Step 4 or Step 5 to adjust the mapping or units.
Step 7: Import
Click Import Items. All items from the spreadsheet will be added to your plan immediately. The Items Panel will update to show the newly imported items.
You can now run the optimizer to generate a loading plan.
Tips for Clean Imports
- Numeric fields must contain numbers only. Do not include unit symbols (mm, kg, lbs) in the cells — put the unit only in the column header if you want to document it.
- Blank rows are skipped automatically. You can have empty rows in your spreadsheet without causing errors.
- Duplicate names are allowed. If two rows have the same name, they will be imported as two separate item definitions. This is intentional — different items can share a name if they have different dimensions.
- Quantity of zero is treated as 1. An item with quantity 0 will still be imported as a single unit.
- Fragile and stackable columns accept a variety of formats: 1/0, yes/no, true/false, and checked/unchecked all work.
- Large files (hundreds of rows) import quickly — there is no practical row limit for standard shipment sizes.