Skip to content
Hypamoon

For teams that run on HubSpot

HubSpot full name split into first and last

Forms, scanned cards and imports often deliver the whole name in one field. HubSpot then keeps it as the first name, so emails open with the full name, and names written family name first, as in Japan, come out the wrong way round.

How it goes today

  1. Export the contacts with a full name in one field.
  2. Split them with a formula in a spreadsheet.
  3. Fix double names and prefixes such as van der by hand.
  4. Import the file back into HubSpot.

How it can go

Names that arrive in one field are split into first and last name.

Each night contacts with a full name in the first name, or in a field you name, are split into first and last name. Prefixes such as van, de or von stay with the last name, and the family name comes first for the countries you choose. Names the tool is unsure of are left alone and sent to you as a short list.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your HubSpot key in the portal, never in the chat.

Your request

With Hypamoon, each night, find contacts in our HubSpot whose whole name is in the first name or in the field I name, and split it into first and last name, keeping prefixes like van, de and von with the last name and putting the family name first for the countries I give. Send me the ones you were unsure of.

A super admin creates the HubSpot service key under Development, Keys, and picks what it may read and change. It stays yours.

More for teams on HubSpot