Back to Macro Library

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

Name: Pixel&Code
Price range: $

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.

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

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 Macro

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

Take your data to the next level

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