Depending on the types of data you are licensed to use with PC*MILER Spreadsheets, you can enter origins and destinations in the following ways.
City/State Pairs or ZIP/Postal Codes
City/state must be in quotation marks.
"Princeton, NJ" or 08540
"Toronto, ON" or M4B 1B7
"Cancun, QR" or 77500
Learn more about entering Mexican Postal Codes.
Postal codes outside of the U.S. and Canada
Learn more about postal code formats.
Three-digit ZIP Codes
When using 3-digit ZIP codes, a state abbreviation must be included, e.g. 123, NY. If the state is not included, an error message will be returned. Depending on how the cell is formatted, Excel may add zeroes at the beginning of the ZIP code; but an error message will be generated whether or not this occurs.
Latitude/longitude points can be entered as stops on a route in degrees minutes seconds format or decimal degrees (e.g. 0401750N,0742131W or 40.297222N,74.358611W).
Here is an example of a lat/long near Kendall Park, NJ in both formats:
0402515N,0743340W or 40.420833N,74.561111W
Latitude/Longitude Points with Street Addresses
This functionality will geocode the lat/long to the nearest point on the particular street in the address, rather than to the nearest street in the direction of travel, as would be the case for a lat/long by itself.
The lat/long is added before the address, followed by a semicolon. An example is:
40.211670N,74.703480W;1200 Kuser Road
Street Address with City/State
All street addresses MUST be separated from the preceding place name by a semicolon.
"new york, ny;118 broadway"
A nine-digit Standard Point Location Code can be entered if you are licensed for that data.
Custom Places created in Content Tools can be entered as stops.