Onfleet's task import allows you to upload large quantities of tasks in a batch rather than creating them one at a time through the dashboard. You can upload CSV, XLS, or JSON files.
Step 1: Create an import sheet
In order for Onfleet to import all the task attributes successfully, your file should contain at minimum the required fields (highlighted red) found in the sample import sheet attached at the bottom of this article.
Thefield is used to indicate the name of the customer you are delivering to. This should be formatted as "FirstName LastName."
Thefield should include a valid, unique phone number for your recipient.
Thefield should include the street number (including letters, if any) without spacing, followed by a space and the street name details, including the full word form of the street type (e.g. "Street" instead of "St" and "East" instead of "E").
Thefield should include apartment, suite or any additional information about the address (this will not be used during geocoding).
Also required:, , , and
The SMS notifications for certain recipients. Set the cell value to if you would like the recipient of the task to receive notifications, and set it to to disable notifications for that recipient. If this field is not used, the task notification setting is defaulted to and a notification will be sent unless the Recipient has notifications disabled.field allows you to enable/disable automated
Thefield is used to store information or special instructions pertaining to the Recipient. Text placed in this field will overwrite any existing notes.
Theand fields allow you to use coordinates instead of an address to add a task. Although the address fields will still be required, their data will be used for display purposes only.
Thefield is used to store task-specific information like an order number or list of items to deliver.
Thefield is used to designate if a given task is a pickup. In order to designate that a task as a pickup, you must input in the task's cell. If this cell is empty, or contains anything but , the task will be imported as a drop-off by default.
Thefield allows you to input a date and time after which a task should be completed. The field allows you to input a date and time before which a task should be completed.
- Unix timestamp
- MM/DD/YYYY hh:mm A (Example: 12/17/2015 2:30 PM)
- MM/DD/YYYY HH:mm (Example: 12/17/2015 14:30)
- DD/MM/YYYY hh:mm A (Example: 17/12/2015 2:30 PM)
- DD/MM/YYYY HH:mm (Example: 17/12/2015 14:30)
The Connections). The name listed must exactly match the connected organization's name for the assignment to occur. If you are only assigning to your own drivers you do not need to use this field.field is used if you are assigning tasks to other Onfleet registered organizations that you are connected with (see
Thefield can be used to immediately assign tasks upon import. This is useful if routing or assignment was planned outside of Onfleet (manually or via a third party tool). The name listed in this field must match a driver's name in Onfleet for the assignment to occur. Tasks imported that have a Driver in this column will be assigned in the order listed on the spreadsheet.
Step 2: Upload sheet and map columns to Onfleet attributes
To import tasks, click the Page button next to the Plus button
Clickin the modal and select the file from your computer. Once uploaded, you will be prompted to map each column header with a corresponding attribute within Onfleet.
If there are any issues with the data provided in your file, the system will alert you and provide a description of the errors. If you would like to correct these errors on your file before proceeding, click Back twice to upload the corrected file.
Note: For your convenience, the attached Onfleet Import Template (Unix) includes fields that will automatically convert your local date/time into unix time. Simply enter your desired date/time into theand fields, enter your timezone's UTC offset and unix time will be generated in the and fields.
Downloadable Import Sheets