Spreadsheet Upload

Pro subscribers have access to our spreadsheet upload tool, which allows you to bulk-upload Stops with an Excel (.xlsx) spreadsheet. We ask users to follow our upload template guidelines to promote accuracy.


Are you a FedEx or OnTrac contractor looking for direct manifest uploads? Reach us at support@roadwarrior.app and we'll set you up.

Tutorial

  1. Download and Fill Out Excel Template

Find the upload template here, then fill out as instructed. Do not modify the first row of the sheet. For a complete list of template guidelines, see the section below.

2. Upload the spreadsheet through the RoadWarrior Web App

Access the RoadWarrior Web App here. If you run into issues, check out our troubleshooting guide below, or reach our team at support@roadwarrior.app for assistance.

3. Check your mobile device for the uploaded Route

If you have app notifications enabled, you will get a notification indicating successful upload. You may need to manually sync your mobile app from the bottom of the side menu.

Template Guidelines

Do not modify the header row (row 1)--this row gives important information to our system that helps categorize the data.

Required Columns:

In general, the required columns have a green header; the rest are supplementary. Required columns, along with any notes, are listed below:

  • Name - identifier for the address. Most commonly, this will be the resident/point of contact at your Stop

  • Building/House Number - numerical part of street address

  • Street Name - street part of street address

  • City*

  • State/Region*

  • Postal* - zip code or post code

  • Country - see list of country codes on the second sheet of the Excel template

*If you add the city and state, you do not need a postal code; if you add a postal code, you do not need the city/state information.

Optional Columns:

  • Color - the color of the Stop or Favorite pin when uploaded. When left blank, the addresses will upload to your account’s default colors. See list of colors on the second sheet of the Excel template

  • Phone - phone number for your contact

  • Note - any pertinent information you would like to add to your Route. If you use hashtag filtering, this is the place to include those hashtags.

  • Latitude & Longitude - you can use coordinate values, instead of addresses, to define your Stops. Any values here will override the address.

    • When filling out this column, opt for decimal degrees (ex. 40.0150, -105.2705) rather than degrees, minutes, and seconds (ex. 40 0 54 N, 105 16 14 W)

  • Stopover/Visit Time - the number of time in minutes you expect to spend at each Stop. This will be calculated into your total Route travel time.

Troubleshooting

Here are a few troubleshooting tips for the most common issues if you get stuck:

  1. Header Error - make sure your header row is unmodified from the original template

    • Even if you leave a column blank, you should not delete the full column

  2. File Type Incompatible - RoadWarrior is only compatible with .xlsx documents at this time

    • Convert any .xls or .csv files to .xlsx, with the proper header rows, before uploading

  3. *Geocoding Error - take a look at the row # if a geocoding error appears, and locate the site on your spreadsheet

    • Make sure the address is typed correctly by comparing the address to Google Maps

    • These errors can now be corrected directly in the Web App without changing your spreadsheet--keep reading below!

Geocoding Error Correction

Geocoding Errors can be corrected directly in the Web App as long as Upload Error Handling is turned On. To enable this feature:

  1. Navigate to the Uploads tab

  2. Enter Upload Settings by clicking the Settings Icon

  3. Select Fix Issue on Error

If a Geocoding Error occurs, you'll be able to correct the pin by:

  1. Clicking the desired location on the map

  2. Searching for the address directly

  3. Skipping the location entirely

How to Upload Using Google Sheets

  1. Log into the web portal using your Pro username and password. Use the left sidebar menu to get to the upload tool.

  2. Download our Excel Template found above and save that file to somewhere you can find it later.

  3. Open http://drive.google.com. In the upper-left hand corner click the red box that says “New" and click "File Upload." Select the file you downloaded earlier called “Rw.Location.Upload.xlsx.”

  4. Open Google Docs to “Sheets” https://docs.google.com/spreadsheets, then click the “Open File Picker” button in the upper right corner. Click the “Upload” tab, and select the file you downloaded earlier called “Rw.Location.Upload.xlsx.”

  5. Fill in your addresses (do not change the very top row of information) for all of the bolded headings.

  6. Click “File,” scroll over “Download as,” and select “Microsoft Excel (.xlsx).”

  7. Go back to the Upload page of the web portal, find your new spreadsheet and upload that to the tool. Now you're all done!

We've updated our user guide to reflect access to our new RoadWarrior Web App. Looking for the User Site Tutorial instead? Click here to see the archive.