Import

The Import button is a powerful tool to add multiple destination addresses at once. You can copy addresses in any application and paste those in the Import textarea. Adding locations in bulk has several advantages. Obviously, you don't need to enter each address in the search box one by one, which saves time. But next to that, placing the addresses on the map is also faster. Instead of sending each address to a Geocoding service, the route planner database is checked first.

Instructions

1. Select the addresses in the origin application, e.g. Word document, Excel spreadsheet or Outlook email

2. Copy all addresses using the correct keyboard combination (often Ctrl-c)

3. In RouteXL, press the Import button

4. Select the textarea and paste the addresses (often Ctrl-v)

5. Press the Import button

6. Wait until all addresses have been added

Notes

• Each address should be on one line.

• If locations are not found, use the correct Address format or select another Geocoding service.

• If there are problems, a message will be displayed after all addresses have been handled.

• The import dialog accepts coordinates and JSON too.

Additional fields

With the address you can also import names, service times, time windows and comments. These additional fields will be stripped from the input before geocoding and added to the location on the map.

• Names between @ and @

• Service times in minutes between ( and )

• Ready and due time as hh:mm before and after >>

• Comments between { and }

• Demand for capacity as number between ^ and ^

• Angle of approach in degrees between * and *

Example

Kennemerstraatweg 464, 1851 NG Heiloo, The Netherlands @Our office@ (15) 09:00>>17:00 {Use the main entrance}

WEBFLEET

If you have a WEBFLEET account a button is added to allow import of orders from the WEBFLEET platform.