VerveSheets
Formulas for

Parse Names

Parsers1 credit/cellSheets · Excel
=VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.title")
What this pulls

Split full names into components by the row. Returns first, middle, last and suffix down a column — Google Sheets or Excel.

It's one of 250+ live sources you reach with a single =VERVE() function — served from APIVerve's production data engine, billed at 1 credit per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.

See it in a cell

A real example — the input you type, and the values you can pull from it. Click any cell to see the formula behind it.

humannameparser.xlsxsample data
B2fx=VERVE("humannameparser", A2, "field", "parsed.title")
A
B
C
D
E
1
Name
Parsed › Title
Parsed › First
Parsed › Middle
Parsed › Last
2
MR. MARTINO PETROS DE FLORENCE (TINO) Jr.
Mr.
Martino
Petros
de Florence
3
4
click any cell to see its formula1 credit / cell
Ways to use it

One value per row

Fill =VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.title") down a column and Parse Names returns a result for every row — a batch of live values in a single drag, no code.

Enrich data in place

Add Parse Names beside a table you already have to append its output right where your data lives, then sort, filter, or chart on it.

Stays fresh on its own

Set the sheet to refresh on a schedule and the parse names values keep themselves current without anyone re-typing.

Use it in your sheet

The same function works in both apps — install once, sign in with your key, and type it into any cell.

Google SheetsAdd-on

Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.

=VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.title")
Microsoft ExcelAdd-in

Same source, same arguments, same key — in Excel on desktop, the web, or mobile. Excel namespaces it as VERVE.CALL. Drag to fill a whole column.

=VERVE.CALL("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.title")
Fields you can pull

Add a field name as the last argument to land just that value in the cell.

  • Parsed › Title
    =VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.title")
  • Parsed › First
    =VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.first")
  • Parsed › Middle
    =VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.middle")
  • Parsed › Last
    =VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.last")
  • Parsed › Nick
    =VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.nick")
  • Parsed › Suffix
    =VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.suffix")
  • Initials
    =VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "initials")
  • Formal NamePremium
    =VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "formalName")
  • Name
    =VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "name")

Premium marks data included on paid plans. On the Free plan a marked field is withheld and a marked input is ignored — either way the cell reads #PREMIUM(name) instead of a value, so a gated answer can never be mistaken for a real one. Everything unmarked works on every plan. Compare plans

Parse Names, answered

Everything you need to wire it into a sheet.

How do I pull Parse Names into Google Sheets?
Install the VerveSheets add-on, sign in once with your key, and type =VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.title") into any cell. The "field" argument names the value you want back, so the cell resolves to a single number or string you can chart, sort, or feed into another formula.
What data can I pull from Parse Names?
Parse Names returns parsed.title, parsed.first, parsed.middle, parsed.last and parsed.nick, plus 3 more — name any one of them as the "field" argument and that value lands in the cell. Leave the field out and the whole record spills into a two-column table instead.
Which Parse Names fields need a paid plan?
formalName is included from the Starter plan up. On the Free plan the cell returns #PREMIUM(field) rather than a wrong or empty value, so it's always obvious which one to upgrade for. Every other field works on Free.
Can I fill a whole column of Parse Names at once?
Yes. Put your name values down a column and point the formula at the range — A2:A50 instead of A2 — and one call returns a value for every row. Dragging the formula down works too, but the range form is a single billed call per column rather than one per cell.
How many credits does each Parse Names cell cost?
Each resolved cell costs 1 credit. A cell only re-bills when it actually refreshes, so a sheet you aren't touching doesn't keep charging.
Does Parse Names work in Excel as well as Google Sheets?
Yes — same arguments, same key, same fields. Excel namespaces custom functions, so the call is =VERVE.CALL() there and =VERVE() in Google Sheets; nothing else about it changes.
Combine it with
Parse Addresses
=VERVE("streetaddressparser", "1600 Amphitheatre Parkway, Mountain View, CA 90210", "field", "parsed.streetNumber")
RSS Feeds to JSON
=VERVE("rsstojson", "https://www.nasa.gov/rss/dyn/breaking_news.rss", "field", "source")
Browse all sources

Put Parse Names in your next spreadsheet. Add the extension, paste the formula, and the cell keeps itself current.

Add to Google Sheets→Add to Excel

Scaling up?

Volume pricing, custom SLAs, and dedicated support for high-traffic teams.

Contact sales