Metadata
SPLIT_NAME_JSON
Returns parsed name components and metadata as JSON text.
Syntax
=SPLIT_NAME_JSON(full_name)Parameters
NameTypeDescription
Name
full_nameTypetext or range
DescriptionFull name text, or a range containing full names.
Returns
A JSON string with parsed components, confidence, and metadata.
Example
=SPLIT_NAME_JSON("Ludwig van Beethoven")Result: {"lastName":"van Beethoven","hasCompoundSurname":true}
The actual JSON also includes firstName, middleName, title, suffix, and confidence.
Notes
Range inputs are supported. SPLIT_NAME flattens the input range into one output row per name.
The parser handles titles, suffixes, comma-formatted names, and common surname particles such as van, von, de, del, and de la.
All parsing runs locally inside the spreadsheet with no external API calls.