Dynamic Dropdowns: Clean Up Country Fields in HubSpot (US vs USA vs United States)
Your HubSpot “Country” field probably has too many versions of “United States.”
US. U.S. USA. United States. united states. Unted States.
Every variant is a broken filter, a wrong report number, or a workflow that did not fire. And country fields are just the beginning — the same thing happens with city names, regions, job titles, and any other field where people type instead of select.
Why This Keeps Happening
Country fields are one of the worst offenders for data inconsistency because:
- Every integration formats differently — your web form says “United States”, your import says “US”, your Zapier sync says “USA”
- Reps type whatever feels natural — and what feels natural varies by person and by day
- HubSpot does not enforce consistency on text fields — it accepts whatever comes in
Over time, a single country ends up with five or six variants in your CRM. Multiply that across every country your contacts are in, and your “Country” field becomes almost useless for segmentation.
The Fix: Scan, Review, Replace
Dynamic Dropdowns handles this in a few steps:
- Scan — point it at your Contact records and the Country property. It scans your portal and pulls every unique value that has been entered.
- Review — you see the full list. “US”, “U.S.”, “USA”, “United States”, “united states” — they are all surfaced. Uppercase and lowercase variations are grouped automatically, but it is all adjustable. You decide which values make the cut.
- Create — Dynamic Dropdowns creates a new dropdown property with your curated list. Clean, consistent, ready to use in forms and workflows.
Your original text field is untouched. The new dropdown runs alongside it, so there is zero migration risk.
What Changes After the Cleanup
Segmentation works again. A list that filters by “Country = United States” catches every contact — not just the ones who happened to type the same string.
Reports are accurate. Your “Contacts by Country” dashboard shows real numbers, not a fragmented view where the same country appears five times.
Workflows fire correctly. A workflow that routes US leads to the US sales team actually catches all US leads — not just the ones that match one specific text variant.
Forms collect clean data going forward. Swap the text field for the new dropdown on your forms, and every future submission is clean from the start.
This Pattern Works for Any Messy Text Field
Country is the obvious example, but the same problem exists everywhere:
- State/Province — “California” vs “CA” vs “calif.”
- Industry — “Software” vs “Software/Tech” vs “SaaS” vs “Technology”
- Job Title — “VP Sales” vs “Vice President of Sales” vs “VP of Sales”
- Lead Source — “Google” vs “google search” vs “Googled it” vs “online”
Anywhere your team or your integrations have been typing values into a text field, Dynamic Dropdowns can scan, group, and clean them up.
Try It
Dynamic Dropdowns is free for early users with no usage cap.
Install Dynamic Dropdowns: Here
Learn more: Dynamic Dropdowns Page