We have created an example spreadsheet to help make importing stop data simple.

Click here to download a copy and get started.

If you don't want to use Spoke's example spreadsheet, click here to read our handy guide on how to import any spreadsheet into Spoke Dispatch. Accepted file formats include .csv .tsv .xls .xlsx .xlm .txt.

Before importing your spreadsheet, make sure that row 1 contains a header field for every column with data, as Spoke will assume that the first complete row of data in your spreadsheet is the row that contains your column header fields.

If you forget to add a header row, don't worry, once you have uploaded your spreadsheet, just toggle on the option to > Use Spoke's headers. This will automatically add Spoke's default header row to your spreadsheet.

Unit/Flat/Unit Name - This is an optional field.

In this column, you can enter a unit number, flat number, or unit name.

Address Line 1 - This is a required field.

In this column, you must add the first line of the main address of the stop.

Spoke uses this column’s data to map a route. Spoke optimizes routes for drivers at street level, so make sure that Address Line 1 always contains street level data.

Address Line 2 - This is a recommended field.

In this column, add a second line to the stop address if you have one.

City - This is a recommended field.

In this column, add the city the stop address is in.

State - This is a recommended field.

In this column, add the state/county the stop address is in.

Zip - This is a required field.

In this column, you must add the zip code/postal code the stop address is in.

Country - This is a recommended field.

In this column, add the country the stop address is in

To avoid incorrectly mapped stops, we recommend accurately filling out as many address data columns as possible. However, if you do put all the address information for a stop into the column Address Line 1, Spoke is still able to map your stops.

Earliest Arrival Time - This is an optional field.

In this column, you can add the earliest arrival time for a stop in 24hr clock format.

When creating a route, Spoke will make sure that the ETA for this stop is later than the earliest arrival time.

Latest Arrival Time - This is an optional field.

In this column, you can add the latest arrival time for a stop in 24hr clock format.

When creating a route, Spoke will make sure that the ETA for this stop is earlier than the latest arrival time.

Time at stop - This is an optional field.

In this column, you can add the estimated time in minutes that the driver will need to go from parking at the address to leaving again.

Starter Plan feature - Spoke will use the time at stop specified within your account if this column is left blank.

Premium & Expert Plan feature - Spoke will automatically log the actual arrival and departure time at a stop for all drivers using Spoke's internal navigation on their driver app

Notes - This is an optional field.

In this column, you can add helpful notes about a specific stop.

Notes are used for general information and can be seen and edited by admins, dispatchers, or drivers. On arrival at a stop, notes will be displayed to the driver, so adding notes can help them successfully complete a delivery.

Size - This is an optional field.

In this column, you can add size information about the delivery using numbers.

Recipient Name - This is an optional field.

In this column, you can add the name of the recipient.

If you have Customer Notifications enabled, you can add Recipient/Customer Name to your email/SMS notifications.

Type of stop - This is a recommended/required field.

In this column, you can mark the type of stop as either a pickup or a delivery.

By default, a stop will be marked as a delivery if it is left blank.

If you have Customer Notifications turned on, you must fill in this column because this enables Spoke to send the correct Customer Notifications to your recipients.

​Order - This is an optional field

In this column, you can specify if you want stops to be placed first or last on a route.
Any stops without a specified position can be left blank or set as auto, and they will automatically be placed in the most logical position on the route

Proof of delivery - This is an optional field.

In this column, you can specify if proof of delivery is required or not required for this stop.

If you leave this column blank, your team's default settings will be applied.

Recipient Email Address - This is a recommended/required field.

In this column, you can add the recipient’s email address.

If you have Customer Notifications turned on, you must fill in this column because this enables Spoke to send the Customer Notifications to your recipients by email.

Recipient Phone Number - This is a recommended/required field

In this column, you can add the recipient’s phone number.

If you have Customer Notifications turned on, you must fill in this column because this enables Spoke to send the Customer Notifications to your recipients by SMS.

Tracking Visibility - This is an optional field

In this column you can add the level of tracking visibility you wish to provide in Customer Notifications. If you leave this column blank your account settings for tracking visibility will be used.

ID - This is an optional field.

In this column, you can add an ID number for your delivery to identify it when cross-referencing between Spoke and your own database.

If you have Customer Notifications turned on, you can add ID to your email/SMS notifications.

Package Count - This is a recommended field.

In this column, you can add the number of packages associated with a stop.

This is useful as it lets the driver know there is more than one package to be delivered to that stop.

Products - This is an optional field.

In this column, you can add information about the type of products being delivered. This could be useful for age-restricted items such as alcohol that require a signature.

If you have Customer Notifications turned on, you can add Products information to your email/SMS notifications.

Seller website - This is an optional field

In this column, you can add a link to the seller’s website.

Seller Name - This is an optional field

In this column, you can add the seller’s name.

If you have Customer Notifications turned on, you can add Seller Name information to your email/SMS notifications.

Driver (email or phone number) - This is an optional field

In this column, you can add the email address or phone number of the specific driver(s) you wish to carry out this stop. Phone numbers must be in the international format and not contain any spaces. If adding multiple drivers separate each one with a comma.

By default, Spoke will assign a driver to the stop when creating a route if this column is left blank.

Spoke Client ID - This is an optional field

In this column you can add the Client ID of a client if you have invited them to join your Spoke Connect. Click here to learn more about the Spoke Connect.

Barcode ID - This is an optional field

In this column you can add the Barcode ID of a package if it has a barcode associated with it.

If you would like to add and import a custom property for a stop that is not already included in the available spreadsheet fields above, you can create a custom property.

If you are importing data using a spreadsheet, add your custom properties in a new row when you next upload your delivery data.

If you are importing data using Spoke’s Public API, you will now be able to include custom stop properties in your API integration. Click here for API documentation.

If you don't want to use this example spreadsheet Spoke also lets you upload your own spreadsheet. Simply upload your data in its current format and map it to the correct columns during the import process.

If you are using Spoke's example spreadsheet or uploading one of your own, watch our handy video on how to import spreadsheets into Spoke next.

There may be rare cases where some addresses cannot be found, such as newly constructed homes. In those circumstances, you can use the latitude and longitude coordinates for the location instead of the address.

Download this example spreadsheet with latitude and longitude columns included.

Fill in your data, and for each stop, add the latitude and longitude coordinates OR the address field, but not both.

Contact your account manager, start a live chat, or email [email protected]