Importing Places into the Address Book in Bulk

For fleets with many destinations, it can be useful to import many places at once. The Samsara Dashboard supports bulk addresses by uploading a.CSV file.

Adding New Addresses via CSV Upload

When adding new addresses, you can start by downloading the Sample Template CSV file that contains each of the columns you will need to fill in. The Sample Template and the required versus optional columns are attached at the bottom of this article. Once you fill in the required information, you can upload the file back to the Samsara Dashboard.

To use the sample template, please follow these instructions:

1. In the Dashboard, click on Settings > Addresses/Geofences

2. Click on More Actions > Upload CSV

3. Click on Sample Template from the pop-up menu to download the template

4. Open the template in a spreadsheet application, such as Excel, Numbers, or Google Sheets

5. Fill in the address data, using Row 2 as an example (see the section below titled Preparing Data for via CSV Upload for more formatting reference)

6. Save the file as a .CSV file

7. Upload the file back to the Samsara Dashboard (see the section below titled Uploading to the Samsara Dashboard)

Editing Existing Addresses via CSV Upload

You can use the bulk uploader to edit addresses. When doing so, you might find it useful to start by downloading your existing Addresses List. 

To download existing address data from the Samsara Dashboard, please follow these instructions:

1. In the Dashboard, click on Settings > Addresses/Geofences

2. Click on More Actions > Upload CSV

3. Click on Addresses List to download your existing address data

4. Update the information in the CSV file (see the section below titled Preparing Data for Import via CSV Upload for more formatting reference)

5. Upload the file back to the Samsara Dashboard (see the section below titled Uploading to the Samsara Dashboard) 

Removing All Addresses

If a mistake is made during a bulk upload, such as not including a state in the address line, it is easy to remove all addresses in bulk.

To remove, navigate to Settings > Addresses/Geofences > More Actions > Remove All Addresses.

Uploading to the Samsara Dashboard

To upload the file to the Samsara Dashboard, please follow these instructions:

1. Click on More Actions then select Upload a file 

2. Choose the CSV file from your computer, or drag and drop the CSV file into the window

3. Click Preview to review the addresses that will be added and/or edited

4. Click Confirm to confirm the changes

Preparing Data for CSV Upload

Here are some important things to keep in mind when creating your file:

• The file must be properly formatted CSV file

• The first row of the CSV file is the header row, and you must include it in the file

• The CSV file must contain no more than 500 rows of data (including one row for the header)

You can use the table below to understand what type of data can be edited with the bulk uploader.