The Validate Address add-on standardizes and validates addresses in your Google Sheet using data from postal authorities from around the world.

The Validate Address add-on will:
• Work with business and residential addresses.
• Correct your address information when possible.
• Add missing information, such as postal codes, city names, and state/province names.
• Format the address components using the format preferred by the countries postal authority.
• Provide a reason why an address is invalid if we can't fix it for you.

The free version (requiring registration with Pitney Bowes) provides access to US addresses using highest quality USPS data to give you delivery point accuracy.

The paid version (available through monthly subscription from Pitney Bowes) gives you access to the following additional features depending on your level of subscription:
• Address block formatting for mailing labels.
• International Addressing support.