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.
NEW: Users can also upload a plain text file (.txt) or type or copy + paste a list of addresses instead of using the .xlsx template file.
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
- 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
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:
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
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
*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:
Navigate to the Uploads tab
Enter Upload Settings by clicking the Settings Icon
Select Fix Issue on Error
If a Geocoding Error occurs, you'll be able to correct the pin by:
Clicking the desired location on the map
Searching for the address directly
Skipping the location entirely
How to Upload Using Google Sheets
Log into the web portal using your Pro username and password. Use the left sidebar menu to get to the upload tool.
Download our Excel Template found above and save that file to somewhere you can find it later.
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.”
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.”
Fill in your addresses (do not change the very top row of information) for all of the bolded headings.
Click “File,” scroll over “Download as,” and select “Microsoft Excel (.xlsx).”
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.