State Abbreviation Lookup When Loading Leads in VICIdial

Lead files come from all over, and not everyone formats the state column the same way. One vendor sends you "California", another sends "CA", and a third sends "Calif." VICIdial wants a clean two-character abbreviation in the state field so reports, filters, and State DNC list checks all behave. State Abbreviation Lookup is the setting that cleans this up for you at load time.

It lives on the lead loader screen, the same place where you handle duplicate checking and time-zone coding. By default it is disabled, so if your files already carry two-letter codes you can leave it off. Turn it on only when your incoming files spell state names out in full.

What the lookup actually does

When enabled, the loader reads the state value on each incoming Lead and matches the full spelled-out name against an internal table of states. If it finds a match, it stores the two-character abbreviation in the state field instead of the long name. So "Texas" becomes "TX" and "New York" becomes "NY" before the record ever lands in your list. This keeps every record consistent regardless of how the source file wrote things.

The lookup only touches the state field. It does not change phone numbers, time zones, or anything else. Time-zone coding is a separate setting that works off the phone code and area code, so the two run side by side without stepping on each other.

flowchart TD
  A[Lead file row] --> B{State field}
  B -->|Spelled out| C[Match internal table]
  B -->|Already 2 letters| D[Leave as is]
  C --> E[Store TX, CA, NY]
  E --> F[Record saved to list]
  D --> F

Why a clean state field matters

• Per-state suppression rules and litigation lists key off two-letter codes, so "Florida" spelled out may slip past a check expecting "FL".
• Reports that group by state stay tidy instead of splitting "CA" and "California" into two rows.
• Any Filter that targets specific states becomes reliable, because every record uses the same format.

For the full picture of how lists hold records and how the loader fits the workflow, read the VICIdial lists and leads guide. If you are brand new to the concept of a list, the what is a VICIdial list overview covers the basics first.

When to leave it off

If your Lead loader files are already clean and use two-letter codes, the lookup adds nothing and you can leave it disabled. It is built for the messy real-world case where a vendor hands you full names. Flip it on for those files, leave it off for the clean ones, and your state column stays consistent across every list you build.

VICIfast ships every dialer with the fifth-generation lead loader and these cleanup options ready to go, so you can load messy vendor files without hand-editing them first. See plans and what is included on our pricing page and start dialing clean data the same day.