Skip to main content
All CollectionsCircuit for TeamsMANAGE & TRACK ROUTES
How to import spreadsheets into Circuit for Teams
How to import spreadsheets into Circuit for Teams

Bulk upload stops in a spreadsheet to quickly create routes

Chloe Ammonds-Nutt avatar
Written by Chloe Ammonds-Nutt
Updated over a month ago

Watch our handy video on how to import your spreadsheet and download an example spreadsheet below.


How to import your spreadsheet a step-by-step guide

  • Select > Create route from spreadsheet

  • Next drag your spreadsheet into this window or click 'Upload data from file' to browse for the file on your PC.

  • Accepted file formats include .csv .tsv .xls .xlsx .xlm .txt.

  • You will be asked if the top row of your spreadsheet contains your column names

  • Next, make sure each column is mapped correctly

  • Click > Confirm mapping for every column that is mapped correctly

  • If you have imported any data that's not required, click > Ignore this column

  • If a column has been mapped incorrectly, you can correct it by clicking the drop-down menu, selecting the correct option, then clicking > Confirm mapping

Screenshot 2024-09-18 at 17.06.52.png

You only need to map your columns once, as Circuit will remember these settings.

You would only need to re-map your data if you change your spreadsheet format.

  • Once everything looks correct, click > Continue to finish importing

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

  • Flat 2

  • Unit 3

  • Empire State Building

Address Line 1

The main address of the stop.

This must be street-level data,

  • 1 Bond street

  • 234 Demo close

  • 10 Berry lane

Address Line 2

A secondary line of the address.

City

The city the stop is in.

  • Orlando

  • Chicago

  • Manchester

State

The state/county the stop is in.

  • Texas

  • California

  • Hertfordshire

  • Queensland

Zip

The zip/postal code of the stop.

  • 10001

  • 20500

  • SW1A 0AA

Country

The country the stop is in.

  • USA

  • UK

  • Canada

  • Australia

  • Brazil

Earliest Arrival Time

The earliest time you wish for the driver to arrive at the stop. This must be in 24hr clock format.

  • 8:30

  • 10:30

  • 16:45

Latest Arrival Time

The latest time you wish for the driver to arrive at the stop. This must be in 24hr clock format.

  • 10:00

  • 13:00

  • 21:00

Time at stop (minutes)

How many minutes your driver will spend at the stop.

  • 1

  • 60

  • 240

Notes

Any information you need the driver to know about the stop.

  • Leave in the safe place

  • Leave with neighbor

  • A gate code

  • Beware of the dog

Size

Size information about the package/parcel.

  • Small

  • Large

  • Rectangle

  • Long

  • Envelope

Proof of delivery

Specify if proof of delivery is required or not required for each stop.

  • required

  • not_required

Recipient Name

Name of the recipient associated with the stop.

  • Jane Doe

  • John Smith

Recipient Email Address

Email address of the recipient associated with the stop.

Recipient Phone Number

Phone number of the recipient associated with the stop.

  • (202) 960-2925

  • +44 020 3868 3278

  • +447868790415

Tracking Visibility

The level of tracking visibility you want to provide in Customer Notifications

  • ETA

  • Stops in queue

  • Live driver tracking

Type of stop

Marking the stop as a delivery or pickup/collection.

  • Delivery

    Or

  • Pickup

Order

The order you want the stop to be placed on the route first/auto/last

Tracking Visibility

The level of tracking visibility you want the recipient to see in their recipient notifications

Id

An external ID, order, or reference number is associated with the stop.

  • 345643

  • 36456473FGDHFN

  • RAF45676FGD

Package Count

The number of packages or parcels associated with the stop.

  • 1

  • 4

  • 7

Products

The products that are being collected or delivered to the stop.

  • Protein Powder

  • Birthday Cake

  • Flowers

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.

  • Jack's burgers

  • Ryan's Flowers

  • Cake4u

Driver

The driver's email address or phone number you wish Circuit to allocate this stop to when creating the route.

Circuit Client ID

The client ID generated for each client that is invited to the client portal.

Latitude

The Latitude coordinates of the corresponding stop

  • 40.748400

  • 51.500700

  • -33.856800

Longitude

The Longitude coordinates of the corresponding stop.

  • -73.985700

  • -0.124600

  • 151.215300

Got a question?

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

Did this answer your question?