Download Macros to improve your Data

Take your data to the next level

Back to Macro Library

BillingCountry Converter: Full Name to ISO 3166-1 Alpha-2 (Account)

Object: Account, Field: BillingCountry
Standardisation
DataQuality
Account

This macro converts full country names in the BillingCountry field on Account objects in Salesforce to their corresponding ISO 3166-1 alpha-2 codes.

For example, it changes “United States of America” to “US” and “Germany” to “DE.” This standardization enhances data consistency, facilitates seamless integration with external systems, and supports more efficient reporting and analysis. The macro can be executed manually, in batches, from list views, through triggers, or integrated into Salesforce Flows for automated processing. It’s an essential tool for maintaining clean and uniform country data in your CRM.

Download
BillingCountry Converter: Full Name to ISO 3166-1 Alpha-2 (Account)

Replaces full country names, such as “United States of America,” with their ISO 3166-1 alpha-2 codes, like “US,” in the BillingCountry field on Account objects in Salesforce, ensuring standardized and uniform data.

Download Macro
Specifications
  • Object: Account
  • Field: BillingCountry
  • Based on action: Find & Replace

Learn how to import a Macro