Download Macros to improve your Data

Take your data to the next level

Back to Macro Library

MailingCountry Converter: Full Name to ISO 3166-1 Alpha-2

Object: Contact, Field: MailingCountry
Standardisation
DataQuality
Contact

This macro standardizes country data in the MailingCountry field on Contact objects by converting full country names into their corresponding ISO 3166-1 alpha-2 codes.

For instance, it transforms “United States of America” into “US” and “Germany” into “DE.”

The macro leverages a pre-defined database of country names and codes to ensure accuracy and consistency, facilitating compatibility with external systems, improving data uniformity, and supporting efficient reporting.

It can be executed manually, through batch processing, from list views, or integrated into automated workflows such as triggers and Salesforce Flows. By streamlining and standardizing country data, this tool helps maintain clean, uniform records in your Salesforce environment, improving overall operational efficiency and alignment with global standards.

Download
MailingCountry Converter: Full Name to ISO 3166-1 Alpha-2

Converts full country names, such as “United States of America,” into their ISO 3166-1 alpha-2 country codes, like “US,” in the MailingCountry field on Contact objects in Salesforce.

Download Macro
Specifications
  • Object: Contact
  • Field: MailingCountry
  • Based on action: Find & Replace

Learn how to import a Macro