(Premium only) Steps to import a list of stops into a route in lieu of manually entering each stop:

  1. Create a .CSV file of locations that has at least two columns (city name and state abbreviation). The first row should be column headers. Other optional columns are: Stop Name, street address, ZIP/postal code, country abbreviation, latitude, longitude, and stop duration.
  2. Click Import Stops
  3. Click Choose File and browse for your .csv file.
  4. (Optional) Specify which type of delimiter should be detected in your file to indicate a new column.
  5. Click Continue.
  6. In the next window, your location data will be sorted. Use the drop-down menus to assign column headers that PC*MILER will recognize. Choose Skip for unnecessary columns.
  7. Click Continue.
  8. PC*MILER will process the data. The next window will indicate how well the input street addresses matched to locations in PC*MILER map data, and also the distances between the matched locations and input latitude-longitude coordinates (if included in the import). If latitude and longitude pairs were included in the import, they will be used as stop locations. To use matched address instead of the lat-long, click on the matched address. Check the Skip checkbox at the end of the row to not import that location. Click Show Map to see the location on the map.
  9. Click Finish . Stops will be imported into the route window and the route will run automatically.

NOTE on Lat-Long Data: Both the latitude and longitude must be included otherwise it will be skipped. If a valid lat-long is more than 10 miles from the given address, the row will be highlighted.