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
Names stay in Google Apps Script™
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:A100, 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

Parsing uses Western-order and explicit Last, First heuristics. Review ambiguous names and cultural naming conventions. Confidence is a rule-based score, not a probability of correctness.

Data and permissions

Parsing runs in Google Apps Script™. The add-on requests permission to display Help and Feedback dialogs and send limited usage events to Amplitude. Events exclude formula inputs, results, spreadsheet contents and account email. Optional feedback sends only your entered message and optional email. See the privacy policy.

    xs