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 Circuit's example spreadsheet, click here to watch our handy video on how to import any spreadsheet into Circuit for Teams. Accepted file formats include .csv .tsv .xls .xlsx .xlm .txt.

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.

Circuit uses this column’s data to map a route. Circuit 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, Circuit 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, Circuit 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, Circuit 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.

By default, Circuit will use the time at stop specified within your account if this column is left blank.

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, such as small, large, rectangle, long, and envelope.

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 Circuit 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 Circuit 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 Circuit 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 Circuit 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, Circuit will assign a driver to the stop when creating a route if this column is left blank.

Circuit 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 Client Portal. Click here to learn more about the Client Portal.

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 don't want to use this example spreadsheet Circuit 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 Circuit's example spreadsheet or uploading one of your own, watch our handy video on how to import spreadsheets into Circuit 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]