If you use an Excel file to record the stops or deliveries of your planning, take into account the advice that we leave you below so that the file is compatible and your optimal optimization.
How to create stops using an Excel file
Organize the information by columns and give them a title in the first row. You can give a name to the delivery service, which may well be the name of the company or person who is going to receive it.
Write your address very well. You can have it written in one or split into multiple columns. It must include: street name, number, postal code, city and country. For example: Carrer de la Marina, 19, 08005 Barcelona (Barcelona), Spain.
Address 2 can refer to all the additional information you need at your address, such as the door number
You can also add comments, such as "leave in the mailbox", example.
The reception hours will be the hours in which the client will be available to receive the service.
All this information will then be related to the optimizer: the name field with the field of your name file as well, for example.
Tip: to make sure that each field is correctly designated, a green check will appear next to it.
To continue, you must click on Map stop fields and if all the addresses have been written correctly, click on the Create stops button.
Routal will notify you if any address has been entered incorrectly using a yellow or red color as you can see below:
Remember that if you have questions, you can download an example file or contact our support team at any time by chat.
You can also create stops from scratch. You can find more information about creating stops from scratch in the following article.