Skip to main content
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/96810510.432df982-f91b-487b-9cf0-a0bc7b93f833-004b9086-9518-493b-a9da-7e0729bd568c/image3_Pastedimage.png

CDXGeoStream for Excel

by CDX Technologies

ZIP and postal code lookups, distances, USPS address verification, geocoding and demographics.

CDXGeoStream brings postal geography into Excel. Look up the city, county or state for any U.S. ZIP code or Canadian postal code, measure straight-line or driving distance and time, find every ZIP code within a radius, verify addresses against USPS data, geocode addresses, put maps in your workbook, and pull census demographics for a ZIP code, city, county or state.

Cell functions
Type them like any other formula. The ones that return one value per row, such as CDX.CITY and CDX.DISTANCE, also take a whole column, so one formula can answer every row.

  • CDX.CITY, CDX.STATE, CDX.COUNTY: the city, state or province, and county for a ZIP or postal code
  • CDX.DISTANCE: straight-line distance between two ZIP or postal codes, cross-border included
  • CDX.DISTANCE2WP: straight-line distance between two latitude/longitude points
  • CDX.ROUTE: driving distance or time by road
  • CDX.RADIUS: every ZIP or postal code within a radius, with its distance
  • CDX.CLOSESTZIP: the closest ZIP or postal code to a target, from a list you provide
  • CDX.ZIPLIST: the ZIP codes in a state, narrowed by county and city if you like
  • CDX.GEOCODE: latitude and longitude, or a single field, for an address, ZIP or postal code
  • CDX.REVGEOCODE: the address at a latitude/longitude
  • CDX.VERIFY: the USPS-standardized address and ZIP+4 for a U.S. street address
  • CDX.CENSUS: a demographic value for a ZIP code, such as population, median income or median age
  • CDX.CITYDATA, CDX.COUNTYDATA, CDX.STATEDATA: the same values for a whole city, county or state

Bulk tools
Select a range and pick a tool in the CDXGeoStream pane:

  • Verify addresses (USPS), and deduplicate and flag a list
  • Geocode addresses, or reverse geocode coordinates
  • Find ZIPs in a radius, find the closest ZIP, or list the ZIP codes in an area
  • Look up ZIP data, demographics and census tract FIPS codes
  • Build a distance matrix between two lists, straight-line or driving
  • Sort a list by distance, optimize a route through a set of stops, or export it as a GPS (GPX) file
  • Insert a map, or map a set of addresses

Who uses it
Sales and marketing teams planning territories and mailings, logistics and field-service teams planning routes, and analysts adding location and demographic data to customer and site lists.

Getting started
Open CDXGeoStream from the Home tab. A short setup takes your API key and walks you through your first formula. Don't have a key? It links to a free account at cdxgeostream.com. No credit card is required.

Account and plans
CDXGeoStream requires a CDXGeoStream account. The Free plan includes a monthly credit allowance for ZIP and postal code lookups, straight-line distance and radius searches, demographics, USPS address verification, and census tracts for a ZIP code or coordinates. Street-address geocoding and census tracts, reverse geocoding, driving distance and time, maps and road route optimization need a paid plan or a credit pack. Plans and credit packs are sold at https://cdxgeostream.com/plans. Nothing is billed through Microsoft.

Requirements
Excel for Microsoft 365 on Windows or Mac, or Excel on the web.

Help: https://app.cdxgeostream.com/help/
Support: https://cdxgeostream.com/support

App capabilities

When this app is used, it
  • Can read and make changes to your document
  • Can send data over the Internet

At a glance

https://catalogartifact.azureedge.net/publicartifacts/96810510.432df982-f91b-487b-9cf0-a0bc7b93f833-004b9086-9518-493b-a9da-7e0729bd568c/image5_1lookups.png
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.png
https://catalogartifact.azureedge.net/publicartifacts/96810510.432df982-f91b-487b-9cf0-a0bc7b93f833-004b9086-9518-493b-a9da-7e0729bd568c/image5_1lookups.png
https://catalogartifact.azureedge.net/publicartifacts/96810510.432df982-f91b-487b-9cf0-a0bc7b93f833-004b9086-9518-493b-a9da-7e0729bd568c/image0_2uspsverification.png
https://catalogartifact.azureedge.net/publicartifacts/96810510.432df982-f91b-487b-9cf0-a0bc7b93f833-004b9086-9518-493b-a9da-7e0729bd568c/image4_3map.png
https://catalogartifact.azureedge.net/publicartifacts/96810510.432df982-f91b-487b-9cf0-a0bc7b93f833-004b9086-9518-493b-a9da-7e0729bd568c/image1_4distancematrix.png
https://catalogartifact.azureedge.net/publicartifacts/96810510.432df982-f91b-487b-9cf0-a0bc7b93f833-004b9086-9518-493b-a9da-7e0729bd568c/image2_5demographics.png
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies