P100-AddressValidation - Program and  ONLINE Manual 

Excel365 logo    Short introduction - to all program functions of    P100-AddressValidation                  >>  Video icon pop up   [xx min]     Video logo   

>>> For detailed HELP - click on the corresponding icon in the menu bar I

Menue-eng Pre-Valdidation Entire-List Selected Rows Web-Search Selection Status-Filter Show/hide_columns Overwrite_addresses Export_KML Columns_Assignment Setting

Scope of functions :     P100-Addressvalidation 

The program P100-Addressvalidation is used for worldwide geocoding of postal addresses.
In addition, it enables a sophisticated, freely configurable Google search directly from Excel.
Functional scope geocoding:       
Standard scope: (OSM (Openstreet Maps): single and batch | Google and BING: single, no batch).
If you use a Google or BING API key, powerful batch geocoding is also possible.You can download the respective API key directly
from your Google or BING account. 

Licensing :

You purchase an  unlimited user license  for one computer for the selected subscription period. Unrestricted, as long as you use
the addresses you edit exclusively for internal purposes. Selling or renting the addresses is prohibited and will result in the deactivation
of the program. In this case there will be no refund of the rental price.
If you want to use BING or Google for batch geocoding in addition to OSM (OpenStreetMaps), you need to confirm their usage rights
and purchase the respective API additionally. The functionality of the program can change at any time (update) without notice.

The first time you launch BING and Google after starting the program, you will be prompted to accept the license terms:  

Bing Maps Terms of Use
The use of the Data/Service is subject to the terms declared in:

  • Microsoft Bing Maps and MapPoint Web Service End User Terms of Use
  • and Embedded Maps Service Terms of Use.

Bing Maps Terms of Use icon pop up

Google Maps Terms of Service:
The use of the Data/Service is subject to the terms declared in:

  • Google Maps/Google Earth APIs Terms of Service and
  • Google Maps/Earth Additional Terms of Service.

Google Maps Terms of Service icon pop up 

Structure of the Excel table (Microsoft Excel 2013 ... 2019 ... Office 365)

The Excel table - must begin - in the first row with the column headings. All columns must be labelled.
The addresses must start sequentially from the 2nd line and blank lines are not allowed between start and end row.
Blank lines and blank columns outside the address block must be removed.

Optimum set up
The first two columns ( A + B) should contain a consecutive number (for example, SAP number) and the name (for example, company).
The columns ( C + D + E + F + G ) contain necessary address information, but these can be distributed in the Excel table as required.
Please note that the street name must comply with the house number and the country code is in ISO format (US - UK - DE - CH - UK).
The postcode should be complete, e.g. - 5 digits - for USA, Germany, France, Italy, - 4 digits - for Austria, Switzerland, Netherlands etc. 
Further information is optional, e.g. telephone, e-mail, web address, sales, employees, imprint etc.
Furthermore, a column with the designation: "Protocol or updated" is useful. Here the program enters the respective (last) processing date
of the address.

Tip structure excel table

Pre-Validation:    Pre Validation   Video  icon pop up    ICON Pfeil nach oben zurueck

All addresses are checked for plausibility. For example, post boxes instead of street names, missing house numbers, missing postal codes
or city names. In this way, corrections can be made in the master data in advance.

Pre Validation

Entire-List:    Gesamte Liste     ICON Pfeil nach oben zurueck

All selected actions, e.g. Web Search, Batch Geocoding: Menue PLZ OSM BING Google waagerecht- , refer to the  entire  Excel file.
Attention: The Excel table must not contain empty lines (inside and at the end).

Selected Rows:    Selected Rows     ICON Pfeil nach oben zurueck

All selected actions, e.g. Web Search, Batch Geocoding:  Menue OSM BING Google waagerecht- , refer to the  selected  rows.

Web Search:     Web Search Video  icon pop up   ICON Pfeil nach oben zurueck

Address search via OpenStreet Maps, BING Maps and Google Maps. Different views are applicable: Street, Satellite, Birds Eye.
Manual (move) adjustment of addresses. Internet (web search) for all address fields and their combinations.
(Almost) any number of address fields can be displayed, searched for and updated via Copy and Paste.

Data protection fulfilled: --> All examples are taken from - public - COC sources. https://www.officialusa.com/stateguides/chambers/   


Selection for batch searchStatus Filter    ICON Pfeil nach oben zurueck

Default setting for the batch search.

Status FilterStatus Filter    ICON Pfeil nach oben zurueck

The status FIlter shows the quality of the address data found.

Quality Attributes

Use Filter: one or more filters are set for batch post-geocoding or web search.

Auto Filter:    Auto filter  ICON Pfeil nach oben zurueck

The auto filter is switched on or off for all columns.

Address compare

Show/Hide columns:   ICON Spalten ein ausblenden   Video icon pop up  ICON Pfeil nach oben zurueck

To compare the address requests and the results found (marked with *) directly, all columns that are - not address-relevant - are hidden.

Show Hide Columns

Overwrite addresses:   ICON Adresse ueberschreiben  Video  icon pop up   ICON Pfeil nach oben zurueck

You can copy the addresses found by OSM - BING - or Google to the original file (Excel). Incorrect spellings can thus be easily corrected.

Export KML:     Export KML  Video  icon pop up  ICON Pfeil nach oben zurueck

Geocoded addresses can be displayed on an Internet web map, e.g. Google Earth. All or selected addresses.

Columns Assignment:   ICON Spaltenzuordnung  Video  icon pop up  ICON Pfeil nach oben zurueck

The column assignment is the most important step after completion of the "settings".
Here you define the address-relevant fields as well as all Excel fields that are to be used for display, search and change.

Column Assignment


Spalten bearbeiten large

thumb Spalten bearbeiten

Settings:    Einstellungen Video  icon pop up  ICON Pfeil nach oben zurueck

Basic settings, such as default country or languages, Google or BING for web search and registration of Google or BING API keys can be done here.
Also which quality characteristics should be displayed, can be defined by selecting the respective fields.