Back to Macro Library

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

Name: Pixel&Code
Price range: $

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 Macro

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

Take your data to the next level

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