CDXZipStream™ Excel Zip Code Add-in
We provide Microsoft Excel templates that completely automate the more common CDXZipStream functions, like geocoding and radius analysis. Cut and paste your data into a template, and you can geocode, optimize routes, calculate driving distance and more with just a single click.
All free templates are compatible with the free CDXZipStream trial. If you receive a VBA Macro Warning message please see the following article.
Driving Calculations
Microsoft Excel Template
Calculates driving distance and driving time between addresses. Works with Google Maps, Here, Caliper Maptitude or Microsoft Bing or MapPoint. Requires CDXZipStream Router version or higher.
Zip Code Radius Analysis
Microsoft Excel Template
Finds all addresses or ZIP Codes in a list that are within a radius distance of a target ZIP. Works with U.S. and Canadian postal code databases. Requires CDXZipStream Lite or Basic versions, or higher.
Driving Calculations Matrix
Microsoft Excel Template
Calculates driving distance and driving time for all combinations of routes between two lists of addresses. Work with Google Maps, Here, Caliper Maptitude or Microsoft Bing and MapPoint. Requires CDXZipStream Router version or higher.
Geographic Access Analysis
Microsoft Excel Template
Geocodes address lists, then sorts these locations according to their straight-line distance to a selected target. Also creates a report showing the closest locations for multiple targets. Works with Bing Maps, Caliper Maptitude or MapPoint. Requires CDXZipStream Router version or higher.
Route Optimization
Microsoft Excel Template
Optimizes driving routes between four or more addresses or postal codes. Provides optimized address order, driving time, and driving distance. Results can be exported to a GPX file. Works with Google Maps, HERE, Caliper Maptitude or Microsoft Bing and MapPoint. Compatible with CDXZipStream Router version or higher.
Route Optimization with Geocodes
Microsoft Excel Template
Optimizes driving routes between four or more geocode (latitude and longitude) points. Provides optimized address order, driving time, and driving distance. Results can be exported to a GPX file. Works with Google Maps, HERE, Caliper Maptitude or Microsoft Bing and MapPoint. Compatible with CDXZipStream Router version or higher.
Location Data Template
Microsoft Excel Template
Gets detailed data for an address list. Data includes ZIP or postal code, street, city, state, county, country, latitude, longitude and best match. Works with Google Maps, Here, Caliper Maptitude and Microsoft Bing and MapPoint. Requires CDXZipStream Router version or higher.
Census Tract FIPS Codes
Microsoft Excel Template
Obtains block and census tract FIPS codes for an address list. FIPS codes are used to obtain data from the census tract demographics feed of CDXZipStream. Works with Google Maps, HERE Caliper Maptitude Microsoft Bing and MapPoint. Requires CDXZipStream Router version or higher.
Closest ZIP Code
Microsoft Excel Template
From a list of ZIP Codes, finds the first, second, or third closest ZIP Code to a target ZIP, and calculates the distance to the target. Works with long lists of target ZIPs. Can also check ZIP Code validity. Requires CDXZipStream Lite version or higher.
Reverse Geocoding
Microsoft Excel Template
Finds the closest address for a list of latitudes and longitudes. Works with Google Maps, Here, Caliper Maptitude or Microsoft Bing and MapPoint. Requires CDXZipStream Router version or higher.
Geocoding
Microsoft Excel Template
Gets latitude and longitude for a list of addresses. Works with Google Maps, Here, Caliper Maptitude, Microsoft Bing Maps or MapPoint. Requires CDXZipStream Router version or higher.
Geocode and Sort by Distance
Microsoft Excel Template
Sorts an address list by distance to a target address. Works with Google Maps, Here, Caliper or Microsoft Bing and MapPoint. Requires CDXZipStream Router version or higher.