Watch our handy video on how to import your spreadsheet and download an example spreadsheet below.
Click here to download our example spreadsheet as a starting point
How to import your spreadsheet a step-by-step guide
On the Circuit main screen, select 'Create route from spreadsheet.'
You'll be presented with a series of screens that guide you through the process of importing your spreadsheet:
You can drag your spreadsheet into this window or click 'Upload data from file' to browse for the file on your PC.
Circuit will ask if the top row contains your column names. If this is the case, select Yes. Please refer to the article on preparing your spreadsheet if this is not the case.
Circuit will ask you to make sure each column is mapped/matched correctly on the next page. Circuit will ask if it has understood the column names correctly. Please make sure you click 'Confirm mapping' for every relevant column. If you have imported any data not required to create the route, you can click 'Ignore this column.'
Circuit will make sure that the mapping is remembered each time you import a spreadsheet as long as the format does not change.
If there are any issues with the file, you can fix them here. Once everything looks correct, click continue to finish importing the spreadsheet.
You'll now see all the stops next to the map. From here, you can add drivers and create their routes.
Read next...
Click here to find out how to prepare your spreadsheet for import using Circuit's example spreadsheet, or use the spreadsheet glossary below to check that your column headers and the data you have input are correct.
Click here to learn about how to create a route.
Spreadsheet Glossary
Column Header/Title | Description | Data Type Examples |
Address Name/Flat/Building/Unit Number | The name of the stop, such as a building or business name. This is not street-level data |
|
Address Line 1 | The main address of the stop.
This must be street-level data, |
|
Address Line 2 | A secondary line of the address. |
|
City | The city the stop is in. |
|
State | The state/county the stop is in. |
|
Zip | The zip/postal code of the stop. |
|
Country | The country the stop is in. |
|
Earliest Time | The earliest time you wish for the driver to arrive at the stop. This must be in 24hr clock format. |
|
Latest Time | The latest time you wish for the driver to arrive at the stop. This must be in 24hr clock format. |
|
Time at Stop | How many minutes your driver will spend at the stop. |
|
Notes | Any information you need the driver to know about the stop. |
|
Size | Size information about the package/parcel. |
|
Proof of delivery | Specify if proof of delivery is required or not required for each stop. |
|
Recipient Name | Name of the recipient associated with the stop. |
|
Recipient Email Address | Email address of the recipient associated with the stop. | |
Recipient Phone Number | Phone number of the recipient associated with the stop. |
|
Tracking Visibility | The level of tracking visibility you want to provide in Customer Notifications
|
|
Type | Marking the stop as a delivery or pickup/collection. |
|
ID | An external ID, order, or reference number is associated with the stop. |
|
Package Count | The number of packages or parcels associated with the stop. |
|
Products | The products that are being collected or delivered to the stop. |
|
Seller Website | A direct link to the seller's website. | |
Seller Name | You are stating the seller's name you are delivering/collecting on behalf of. |
|
Driver | The driver's email address or phone number you wish Circuit to allocate this stop to when creating the route. |
|
Latitude | The Latitude coordinates of the corresponding stop |
|
Longitude | The Longitude coordinates of the corresponding stop. |
|
Got a question?
Contact your account manager, start a live chat, or email [email protected]