Back to Macro Library

Country Converter: Full Name to ISO 3166-1 Alpha-2 (Lead)

Name: Pixel&Code
Price range: $

Object: Lead, Field: Country

Standardisation

DataQuality

Lead

This macro converts full country names in the Country field on Lead objects in Salesforce into their corresponding ISO 3166-1 alpha-2 codes.

For instance, it replaces “United States of America” with “US” and “Germany” with “DE.” This standardization enhances data uniformity, streamlines reporting, and improves compatibility with external systems that use ISO country codes. The macro can be executed manually, in batches, from list views, through triggers, or integrated into Salesforce Flows for automated conversion. By simplifying and unifying country data, this tool ensures consistency across your CRM and related processes.

Download Macro

Download

Country Converter: Full Name to ISO 3166-1 Alpha-2 (Lead)

Replaces full country names, such as “United States of America,” with their ISO 3166-1 alpha-2 codes, like “US,” ensuring standardization in the Country field on Lead objects in Salesforce.

Download Macro

Specifications

Object: Lead
Field: Country
Based on action: Find & Replace

Learn how to import a Macro

Take your data to the next level

Country Converter: Full Name to ISO 3166-1 Alpha-2 (Lead)