Excel Report
The Excel export produces a structured multi-sheet workbook (.xlsx) designed for integration with warehouse management systems, order tracking tools, and internal reporting workflows. Unlike the PDF which is formatted for human reading, the Excel report is structured for data processing — clean column headers, consistent data types, and no merged cells except in headers.
Generating an Excel Report
- Open the load plan in the editor
- Click Export in the top toolbar (or press Ctrl+E)
- Select Excel Report
- Click Generate
The only option that affects the workbook is the loading direction in the export dialog — it determines the row order of the Packing List and Loading Sequence sheets. The file downloads immediately as a .xlsx file compatible with Microsoft Excel, LibreOffice Calc, and Google Sheets.
Workbook Structure
The workbook contains four sheets. Each sheet is described in detail below.
Sheet 1 — Summary
A high-level overview of the entire plan, laid out as labeled sections:
| Section | Content |
|---|---|
| Header | Plan name and generation timestamp |
| Container blocks | One block per container: name, type, internal dimensions (L×W×H), volume, max payload, tare weight |
| Plan Summary | Total / Placed / Unplaced item counts (counted in physical units, including units on pallets), total weight, volume used, Space Utilization %, plan mode, solve time |
| Scores | Overall, Space Utilization, Weight Balance, Stability, Handling, Damage Safety — plus a bar chart of the score breakdown |
The Plan Summary section is the quickest integration point — item counts, weight, and utilization for the full shipment in one place.
Sheet 2 — Packing List
One row per item placement, in loading-sequence order (the first row is the first item to load). This is the primary data sheet for WMS import and system integration.
| Column | Type | Description |
|---|---|---|
| Item Name | Text | Item name |
| SKU | Text | Product SKU (empty if not set) |
| Container | Text | Container name (e.g., "Container 1") |
| Pos X (mm) | Number | Distance from the far-end wall, along the container length — the door is at the maximum X |
| Pos Y (mm) | Number | Distance from floor to item's bottom face |
| Pos Z (mm) | Number | Distance from the left wall, across the container width |
| Width (mm) | Number | Space the item occupies across the container width in its placed orientation |
| Height (mm) | Number | Space the item occupies vertically in its placed orientation |
| Length (mm) | Number | Space the item occupies along the container length in its placed orientation |
| Weight (kg) | Number | Item weight |
| Rotation | Text | Applied rotation code: LWH, WLH, LHW, HLW, WHL, or HWL |
| Status | Text | "Placed", "Warning" (placed with constraint warnings), or "Unplaced" |
Position coordinates reference the near corner of the item's bounding box, in millimeters. The origin (0, 0, 0) is the floor corner at the far end of the container on the left wall; the door is at the maximum X. Length runs along X, height along Y, width along Z.
Unplaced items appear at the bottom of the sheet, highlighted in red, with Status = "Unplaced", empty container/position columns, and their base (unrotated) dimensions.
Sheet 3 — Compliance
Every constraint violation in the plan, one row per violation.
| Column | Content |
|---|---|
| Item | The item the violation applies to |
| Severity | HARD (red — must be resolved) or SOFT (amber — advisory) |
| Rule | The constraint rule that was violated |
| Message | Human-readable description of the violation |
A plan with no violations shows a single "No violations detected" line. If the plan has an AI analysis, the AI insights text follows below the violations table.
Use this sheet to automate compliance reporting. Filter by Severity = "HARD" to identify plans that require attention before dispatch.
Sheet 4 — Loading Sequence
Items in the recommended physical loading order, one row per item. This sheet is intended to be printed or imported directly into a warehouse task management system as a picking and loading sequence.
| Column | Content |
|---|---|
| Step | Loading sequence number |
| Item Name | Item name |
| Weight (kg) | Item weight |
| Position (X, Y, Z) | Numeric coordinates (mm) in one cell |
| Rotation | Applied rotation code |
| Notes | Constraint warnings for the placement; fragile items are prefixed with "FRAGILE" |
The sequence starts at the far end of the container (away from the door) and works toward the door, bottom-to-top within each depth band — so nothing is ever loaded behind cargo that is already in place.
Units
The workbook is always exported in metric units — dimensions in millimeters, weights in kilograms — regardless of the display unit preference in Settings. This keeps column headers and data types stable for automated importers.
If your WMS expects imperial input, convert during import. A silent mm-vs-inch mismatch causes significant positioning errors.
Compatibility
The .xlsx file format is compatible with:
- Microsoft Excel 2007 and later
- LibreOffice Calc 5.0 and later
- Google Sheets (via upload)
- Most ERP and WMS systems that accept Excel input
No macros or ActiveX controls are used. The file contains only data, formulas, and basic formatting.