No integration with your order system yet? You can still get orders into Mover. The Excel template lets you upload up to 250 orders at a time, ready for route planning.
This article walks you through downloading the template, filling in the Orders sheet, uploading it, and checking the result.
Download the template
Open Orders from the side menu.
Click Import orders in the top-right corner. A panel opens on the right.
In the panel, click the word Template to download the Excel file. Save it somewhere you can find it. Note that the file you upload must be an Excel file (.xlsx) in this format.
What's in the template
The file has four tabs:
Instructions – a short description of the template.
Orders – the only tab that gets imported. This is where your orders go.
Country Codes – a reference list of country codes and calling codes.
Notes & Calculations – a free sheet for your own notes. It is never imported and can be deleted.
On the Orders tab, underlined column names are mandatory. If a mandatory field is empty or invalid, that order is not created. Hover over a column header to see its rules.
Fill in the Orders tab
You can add up to 250 rows, one row per order. For larger volumes, split the orders into several files.
Order details
Column | Mandatory | What to enter |
Order ID | Yes | A unique ID of at least 3 characters. The same ID can't be used twice, so the same order is never created twice. No order IDs in your system? Combine the date and a row number, for example 20261015_1, 20261015_2. |
Related order ID | No | Use this if your company has more than one ID for the same order, for example separate shipments or services under the same booking or sales order ID. It links them together. |
Tags | No | One or more tags separated by commas, for example |
Estimated colli | Yes | Number of colli (for example boxes), a whole number of 1 or more. It doesn't need to be exact, only good enough that a route never ends up with more than one vehicle can carry. |
Estimated colli total weight [kg] | Yes | Approximate total weight in kg, greater than 0. An average is fine. |
Pickup
Column | Mandatory | What to enter |
Pickup country code | Yes | Two-letter code, for example DK. Select from the list or check the Country Codes tab. |
Pickup address | Yes | One field with street, street number and city or postal code. |
Pickup date | Yes | Format dd/MM/yyyy. Today or a later date. |
Pickup time from / to | Yes | The window when pickup is allowed, as hh:mm. "To" must be later than "from". Start a little before the first delivery so there is time to load. The planner decides the exact departure inside this window. |
Delivery
Column | Mandatory | What to enter |
Delivery country code | Yes | Same as for pickup. |
Delivery address | Yes | One field with street, street number and city or postal code. If your source file has street and postal code in separate columns, combine them first. |
Delivery date | Yes | Format dd/MM/yyyy. The same as or later than the pickup date. |
Delivery time from / to | Yes | The delivery window, as hh:mm. "To" must be later than "from". |
Contact details and instructions (optional)
Pickup and delivery each have columns for contact person, company, email, country calling code, phone and instructions. You don't need them to plan routes. They become useful when drivers execute the route and need to know who the recipient is.
Emails must contain an @.
If you enter a phone number, also enter the country calling code, for example +45.
Use tags to control planning
Tags are optional, but they let you steer planning beyond pure optimization. A few examples:
Mark heavy orders that need two people, for example
2people.Separate curbside from indoor delivery so each gets the right task time.
Add the route an order belongs to today (for example
Route:North-Wed) to keep the same orders together on the same vehicle.Add a distribution center tag (for example
DC:1) if you plan from more than one pickup location.
Tags only have an effect once your rule set refers to them. See Understanding and Using Tags for more.
Upload the file
Save the file.
In the Import orders panel, drag and drop the file onto the upload area, or click it to choose the file.
On the Orders page, filter on your delivery date (use the Delivery date filter) so you can watch the orders appear.
Check the result
Each order gets a status:
Ready (blue) – the order is good to use in route planning.
Placed – something needs fixing, most often an address the system doesn't recognize.
Refresh the page and open the Placed view (or use the Status filter). The more orders you upload, the longer the check takes, but it is usually done within about 20 seconds. Ideally the Placed list is empty.
Fix an order stuck in Placed
Open the order.
Click Edit order.
Edit the Address until the system recognizes it and pick the suggested match.
Save.
Review address confidence
A recognized address isn't always a precise one. Use the Confidence score filter on the Orders page and show orders below about 75%. Review them. A low score usually means the point sits in the middle of the postal code instead of on the building. Planning still works, but the driver may not find the right place and the driving time will be off.
Most fixes are small: a misspelling, a doubled letter or an abbreviation. Correct the address and the point moves to the right place. About 90% is the best score the system gives. See Address Confidence for what the scores mean.
Common reasons an order isn't created or stays Placed
A mandatory column is empty.
The pickup date is in the past.
The Order ID already exists or is shorter than 3 characters.
"Time to" is not later than "time from", or the delivery date is before the pickup date.
The address is incomplete, or the street and postal code are split across columns.
A tag is empty (two commas in a row).
What's next
Once your orders are Ready, set up a rule set and create your route plan. See Route Planning with Rule Sets. If some orders don't end up on a route, see Orders Left Unplanned? How to Improve Your Rule Set.