You can not only create orders manually, but also import them from files containing tables with data on the orders. XLSX and CSV (in UTF-8 encoding) files are supported. 

To import orders, follow the steps below.

1. Select Import orders after expanding the Planning item in the navigation bar.
   
   
   
2. Click Select file and select the file from which you want to import data. The maximum file size is 8.3 MB.
3. If necessary, select the existing template or create a new one (the Add template button).
4. Click Import.
5. Enable the Exclude first line option in the table of orders if the file has its own column headings.
    

6. Select column headings in the drop-down lists. The Address (or Latitude and Longitude), Time from and Time to columns are required. You can upload a table without coordinates and address if a geofence is specified in one of the columns. The geofences must be stored in the same resource in which the orders are created. You must select the Address name for a column with the geofence.
   

   If you have created custom fields in the settings, you can also select their names as column headings and save the template.

7. Select the orders you want to import. To edit a cell, click on it, make changes, and save them. Enable the Repeated orders option if these orders should be fulfilled several times.

   To edit several orders simultaneously, select them in the list, click on the cell you want to edit, and make changes. After saving the changes, they will be applied to all the selected orders.

8. Click Save.

Import templates

Import templates are column headings saved in a certain sequence. They are required so as not to select column names in the import table manually. You can create templates in the window of selecting a file for import (the Add template button) or in the table at the next stage of import (the icon  in the lower-left corner). In the template creation window, specify the template name, edit the set of columns if necessary and save the changes. 

The list of the created templates is shown in the window of selecting a file for import. Here you can also copy, edit and delete templates (the icon  opposite the template name)

Import table

After the import, the data from the file is shown in a table. In the table, you can select orders and edit their data. The names of the columns and their contents correspond to the fields of the order creation/editing window, that is, these fields will be filled in after you save the imported orders. If some data is missing in the import table, the fields in the orders are filled in automatically with the values ​​specified on the General tab of the settings (the Order parameters section). In the empty Time from and Time to columns, the time is automatically indicated for permanent orders, while the date of the next day and time is indicated for single ones.

The Exclude first line option allows hiding the first line of the file if it has its own column headings.

If the table contains orders with incorrect address information, the lines with such orders are highlighted in red and placed at the beginning of the table after selecting the Address column.