URL / CRM / Accounting

How to normalize HubSpot Lifecycle Stage values

2026-06-21
Task

CRM export stages can use different wording. HubSpot needs a Lifecycle stage column with accepted English values.

Short answer

Create replacement rules such as subscriber -> Subscriber, lead -> Lead, and customer -> Customer.

How to do it in Eofferix

  1. Upload the contacts table and open the table editor.
    Lifecycle stage normalized for HubSpot in Eofferix
    The Lifecycle stage column contains accepted HubSpot values.
  2. Create Lifecycle stage from lifecycle_stage and add Contains -> Replace with rules for each accepted value.
    Replacement dictionary for HubSpot Lifecycle stage
    The rules map local or inconsistent wording to unified values.
  3. Keep only values that HubSpot accepts in the result.
  4. Save the template and use the column in the CRM import.

Before / after

The data below is a training example and does not belong to real user files.

Before

source data
contact_idlifecycle_stage
C-1001subscriber
C-1002lead
C-1003customer

After

result
contact_idLifecycle stage
C-1001Subscriber
C-1002Lead
C-1003Customer

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up