Welcome to the CDXZipStream December 2015 Newsletter

One of the major advantages of using Bing Maps is the world-wide coverage it provides.  Bing has some level of geographic coverage for every country in the world, with at least major road coverage and basic geocoding ability for over 250 countries.  We've also seen recent improvements in coverage first-hand, such as the inclusion of traffic when estimating travel time in many countries, and the addition of over 3000 transit systems across 30 countries.

This wide geographic coverage also applies to specific address data.  Using Bing Maps in conjunction with the CDXLocateBing function, you can look up postal codes and verify address information world-wide.  In general this can be done where Bing geocoding precision is either "Address" or "Rooftop", which applies to about 70 countries. For a detailed listing please refer to the Microsoft website.
 

Here is a short video showing how to find ZIP or postal codes, and get complete address data, using CDXZipStream:

The video above also shows how to use the "Autocopy" option available in the functions CDXLocateBing and CDXRouteBing.  Selecting "Autocopy" automatically obtains data for the entire list of addresses, until the first occurrence of an empty row, so there's no need to manually copy and paste formulas along the list.  We've recently improved this option so you can use it anywhere in your worksheet, not just next to the original address list.  It will also continue to obtain data even when parts of the address are missing, such as ZIP codes in a multi-line address, as long as street data is present.