NAMESPLIT app icon

Google Sheets add-on

NAMESPLIT for Google Sheets

Split contact names into first, middle, last, title, suffix, confidence, and formatted outputs with formula-first Google Sheets functions.

26 custom functions
Range input support
Compound surnames
No external API calls
Read function docsMarketplace listing URL pending publication
Split columns=SPLIT_NAME("Dr. Martin Luther King Jr.")Martin | Luther | King | Dr. | Jr.
Contact list=SPLIT_NAME(A2:A, TRUE)Header + component rows
Compound last=SPLIT_LAST_NAME("Ludwig van Beethoven")van Beethoven

CRM contact cleanup

Turn full-name columns from forms and exports into first, middle, last, title, and suffix fields.

Mail merge prep

Format names as Last, First or formal display names before pushing data into templates.

Auditable parsing

Use confidence scores and compound-surname flags to review ambiguous records before bulk imports.

Function map

Component formulas plus NS_ aliases

Open full reference

Split

SPLIT_NAME

Components

SPLIT_FIRST_NAMESPLIT_MIDDLE_NAMESPLIT_LAST_NAMESPLIT_TITLESPLIT_SUFFIX

Metadata

SPLIT_NAME_CONFIDENCEHAS_COMPOUND_SURNAMESPLIT_NAME_JSON

Format

FORMAT_NAME_LAST_FIRSTFORMAT_NAME_FIRST_LASTFORMAT_NAME_FORMALGET_INITIALS

Namespaced Aliases

NS_SPLITNS_FIRSTNS_MIDDLENS_LASTNS_TITLENS_SUFFIXNS_CONFIDENCENS_HAS_COMPOUND_SURNAMENS_JSONNS_FORMAT_LAST_FIRSTNS_FORMAT_FIRST_LASTNS_FORMAT_FORMALNS_INITIALS

Range-ready parsing

Point one formula at a contact column and spill clean component fields for downstream filters, mail merges, and imports.

Review metadata

Confidence scores and compound-surname flags make ambiguous records easier to audit before a bulk update.

Private by design

Parsing runs inside the spreadsheet without external API calls or server-side storage.

    xs