1001Ferramentas
Tools Categories Guides FAQ
About Contact Privacy Policy Terms of Use
🪪 Text

Person Name List Formatter

Standardizes lists of people's names: fixes capitalization with particles, flips them to Surname, First name and abbreviates middle names.

The list stays in your browser: nothing is uploaded to any server.

Options

Particles, suffixes and where the surname starts

In Brazilian names the particles de, da, do, das, dos and e stay lowercase inside the name and travel with the surname: "João Pedro da Silva" flips to "da Silva, João Pedro", not to "Silva, João Pedro da". A particle that opens the line is different — there it starts the name and keeps its capital letter.

Suffixes such as Filho, Neto, Júnior and the Roman numerals II to V are not surnames: in "Antonio Carlos Jobim Filho" the surname is Jobim and Filho goes into its own column. That is exactly what a spreadsheet sorted by surname needs, and it is the part a plain uppercase-to-title-case conversion always gets wrong.

Formatting name lists without breaking particles

The sign-up list arrives in ALL CAPS, the badge needs title case, and the spreadsheet wants a surname column of its own. Excel's PROPER function solves half the problem and creates another: it returns Maria Das Graças De Souza, with Das and De capitalized, which is exactly the mistake a human proofreader never lets through on an invitation, a diploma or an attendance sheet.

Portuguese particles de, da, do, das, dos and e stay lowercase inside a name and travel glued to the surname. That is why João Pedro da Silva flips to da Silva, João Pedro rather than Silva, João Pedro da. A particle opening the line is a different case: there it starts the name and keeps its capital. Apostrophes and hyphens also take a capital after the separator, as in D'Ávila and Silva-Santos.

Filho, Neto, Júnior and the Roman numerals II to V are not surnames. In Antonio Carlos Jobim Filho the surname is Jobim, and Filho belongs in a column of its own: without that split, a spreadsheet sorted by surname files half the class under the letter F. The CSV output uses semicolons, the separator Excel opens directly in Portuguese locales, with columns for original name, first name, middle names, surname and suffix.

Frequently asked questions

Which format should I use to sort by surname?
Pick Surname, First name to get da Silva, João Pedro, or tick Split into columns and sort by the surname column in your spreadsheet. The second option usually wins because it keeps the full name in another column, so you can sort, filter and then rebuild the name in normal order with a simple concatenation.
What happens to Dr., Prof. and other titles?
They are removed by default, compared without accents and regardless of case, with or without the trailing period. Dr. Carlos Alberto Nunes JR comes out as Carlos Alberto Nunes Jr., with JR treated as a suffix rather than a surname. If your list has to keep the title, untick the option before standardizing.
What about a line with a single name or an email address?
It is processed anyway and flagged in the report. A single name fills the first-name field and leaves the surname empty, marked as incomplete. Lines with digits, an at sign or more than eight words get a warning that they probably are not names, which is the quickest way to spot the junk that came along with the list.

Related Tools

📧

Extract Emails from Text

Find and extract all email addresses from a text or copied web page. Option to remove duplicates. Processed in the browser.
🔁

Repeat Text

Repeat a text or line N times with a configurable separator: new line, comma, space or any custom character.
🔡

Small Caps Typography

Convert lowercase letters into Unicode small caps. Unmapped characters stay unchanged.