How to Build a Safe "Hi {First Name}," Greeting Column for a Mail Merge

To build a safe greeting, write the whole opening line into a column, with a neutral fallback for rows that have no usable first name. The email greeting line builder does it for a whole list in your browser. Upload a CSV or .xlsx file, pick the first name column, write the greeting with {first} where the name goes, such as Hi {first},, set a fallback, and download.

The file is read on your device and not uploaded.

Why build it before the merge

A merge tag puts whatever is in the cell into your opening line. Blank cells, a single initial, a role word like Info or Team, and names typed in capitals produce openings such as "Hi ,", "Hi AVA," or "Hi Team,", which tell the reader at once that the email was mass-produced. Building the whole greeting in one column lets you fix those rows before sending, and you map one field instead of a name plus a fallback rule that differs between sending tools. For the wider picture, see cold email personalization at scale.

Doing it by hand

In Excel or Google Sheets, with first names in column A:

=IF(OR(TRIM(A2)="",LEN(TRIM(A2))<2),"Hi there,","Hi "&PROPER(TRIM(A2))&",")

PROPER fixes AVA and ava, but it also lowercases the rest of McDonald, and the formula knows nothing about role words such as Info or Team, titles such as Dr., or names with digits. To catch those you filter the column by eye, or add more OR conditions as you find them.

Step 1: load the file

Upload the CSV or .xlsx, or paste the cells with the header row first.

Step 2: pick the column and write the greeting

Choose the first name column and type the greeting with {first} in it, such as Hello {first}, or Hi {first} - quick question. Only {first} is replaced. Set the fallback for rows with no usable name.

Step 3: read the counts and download

The counts and the tidied names show what changed. Download the file and map the new column in your sending tool.

Which names get the fallback

A row gets the fallback when the cell is blank, holds only a title such as Dr., has a single letter such as J., is a role word (team, admin, info, support, sales and similar), contains a digit, or is longer than 20 letters. Titles are skipped when a name follows, so Dr. Cara becomes Cara, and only the first word of a longer name is used. So a cell reading Mary Jane gets Mary.

Names typed all in capitals or all in lower case are set to Name Case, including after a hyphen or an apostrophe. Mixed-case names are left as they are.

Other checks before a send

A greeting does not prove the address works. Check the whole opening against the rest of the row: the mail merge field checker finds empty fields, and the first name cleaner finds names that are really company names. See CSV fill rate before a mail merge. To get a first name from an address when the column is empty, use name from email.

What this tool cannot do

• It uses the first word of the cell.
• It cannot tell a real first name from a company name that looks like one.
• The role word list is English only.
• Only the first sheet of a workbook is read.

Check the addresses before you send

A good opening line on an undeliverable address is wasted. Upload your list on the verify page: the first 100 email checks are free with a Google sign-in, no card. Each address comes back valid, risky or invalid with a reason, and nothing is sent to anyone on the list. For larger lists, see bulk email verification, list cleaning and pricing.

Build your greetings now

Open the email greeting line builder.