PC*MILER Web Services Spreadsheets

A guide to using PC*MILER Web Services Spreadsheets, an add-in for Microsoft Excel.

Getting Started With Web Services Spreadsheets
PC*Miler Web Services Spreadsheets is an Add-in for Microsoft Excel that allows you to easily generate PC*Miler distances, driver time, tolls, and location ...
Wed, 5 Mar, 2025 at 1:52 PM
Using Web Services Spreadsheets
There are two ways to use PC*Miler Web Services Spreadsheets in Excel—type a formula directly into a cell or use the Insert Function (fx) option.  All formu...
Thu, 6 Mar, 2025 at 8:03 PM
Entering Locations in Web Services Spreadsheets
Depending on the types of data you are licensed to use with your PC*MILER Web Services Spreadsheets API key, you can enter origins and destinations in the w...
Wed, 5 Mar, 2025 at 2:34 PM
Set your region and country for better search results
The latest version of PC*Miler Web Services Spreadsheets includes two new functions that allow you to set a worldwide region and a country to narrow and imp...
Fri, 28 Feb, 2025 at 4:48 PM
=MilesWS
(For PC*MILER Web Services Spreadsheets) =MilesWS returns the mileage between two points (origin to the destination). The origin and destination may be ...
Fri, 28 Feb, 2025 at 7:57 PM
=DriveTimeWS
=DriveTimeWS returns the driving time (in hours:minutes format) from the origin to the destination calculated using the PC*MILER database. The origin and de...
Fri, 28 Feb, 2025 at 8:04 PM
=TollsWS
(North America only; must be licensed for toll data)  =TollsWS calculates accurate, up-to-date toll charges in the U.S. and Canada.  It works in the sam...
Fri, 28 Feb, 2025 at 8:06 PM
=DiscountedTollsWS
(North America only; must be licensed for toll data)  =DiscountedTollsWS returns the portion of the tolls for the trip attributable to the specified dis...
Fri, 28 Feb, 2025 at 8:08 PM
Confidence level in geocoding functions
All of the geocoding functions include a ConfidenceLevel arugment, which is optional and not necessary in most cases. ConfidenceLevel limits geocoding r...
Fri, 28 Feb, 2025 at 1:10 PM
=ZipCodeWS
(U.S. only) =ZIPCodeWS returns the ZIP code corresponding to any U.S. place name. The place name is a city with a state abbreviation (e.g. Austin, TX). ...
Fri, 28 Feb, 2025 at 1:22 PM