Skip to main content

How to organize Excel files so that it is compatible with Routal

Simple indications that will ensure the optimization of your plan!

Written by Joao Lucio

For vehicle (drivers)

  1. Locate your information on the first page of the Excel file.

  2. Organize your information by columns.

  3. Give each column a title in the first row. These titles will later be related to the optimizer fields.

  4. The most important information is

  • Give your vehicle an identifier, for example a number, license plate or the name of your driver.

  • Give a starting point address. We recommend writing it as detailed as possible

5. Depending on your operation, add additional information such as work hours, volume, weight and/or maximum stops.

For stops (deliveries)

  1. Locate your information on the first page of the Excel file.

  2. Organize your information by columns.

  3. Give each column a title in the first row. These titles will later be related to the optimizer fields.

  4. The most important information is

  • Give an identifier to your service - delivery, for example a company name or person who will receive the package.

  • Give an address. We recommend writing it as detailed as possible, including street name, number, postal code, city, country, etc. For example: Passeig de García Faria, 77, 08019 Barcelona (Barcelona), Espanya

  • Address supplement should be located in a separate column. For example: floor, door, building.

5. Depending on your operation, add additional information such as reception
hours, order volume, order weight, comments, External ID, etc.

6. If Package tracking is enabled in your project, add a column with the package identifiers of each stop and map it to the Packages field when importing. Learn more in Parcel management: full traceability from collection to delivery.
​
The importer accepts CSV, XLSX and XLS files of up to 10,000 rows. Remember that you can download our example file (Download example) to use it as a guide, and use Autocomplete to map your columns.

And if you still have questions, write to us through our support chat.

We are here to help you!

Did this answer your question?