Which version of Excel do I need to use the app? If the address is not found in the database, the app attempts to format the address lines according to the conventions of the appropriate postal authority. It also adds missing postal information, such as postal codes, city names, state or province names, and so on. If the address is found in the database, the Validate Address app corrects any incorrect address information in your spreadsheet and formats the address using the format preferred by the applicable postal authority. To validate addresses, the Validate Address app analyzes your addresses and compares them to a database of known addresses. If you have the Gold or Silver package, the Validate Address app also provides the latitude and longitude coordinates of the address.
The addresses in your spreadsheet are replaced with a standardized or formatted version of the address. The Validate Address app standardizes and validates addresses in your Excel spreadsheet using address data from postal authorities from around the world. For example: For the 'Firm Name' field, the valid header names and abbreviations can be 'Name', 'Firm', 'Firm Name', 'Frm', 'FrmName', 'Company Name' etc. The abbreviations are user-entered header entries. The header names are taken from leading customer relationship management (CRM) systems and data management tools.The app identifies addresses on the basis of valid header names or header abbreviations. The Validate Address app now supports automatic identification of address fields when address headers are present and the Selected data has column headings check-box is selected.The latest release of the Validate Address app for Excel contains the following enhancements: Select a topic for help with frequently asked questions: It also adds missing postal information, such as postal codes, city names, and state or province names. It can correct information and format the address using the format preferred by the applicable postal authority.