Email Append: How to Add the Missing Email Column to a List You Already Have

An email append adds email addresses to records that already identify a person or a company. You bring names, job titles, companies or postal rows. You leave with an email column that wasn’t there before.

In 2022, an event sponsorship handed me a 2,800-row attendee file. Names. Job titles. Companies. No emails, because the organiser had only shared badge scans.

So I went shopping for a service. Then I ran a small sample myself first, and that one decision changed what I bought.

There are two routes here. And one of them you can run yourself before lunch.

📌 TL;DR: An email append fills the missing email column on records you already have. Two routes: (1) send your file to an append service, which matches it against their database and usually bills per matched record; (2) run the same match yourself from your spreadsheet: input column, output column, row range, one run. Your data type decides which: B2B work emails are the defensible family, consumer postal appends carry real consent risk. Either way, sample first, verify everything, send in waves.

What Is an Email Append?

An email append matches records you already have against a database and fills in the missing email column. Wikipedia files the practice under email appending, and the definition is refreshingly boring. You supply identifiers. The provider returns addresses.

Three input shapes work:

• A person plus their company: “Jonas Weber” at “Northlight Instruments.”
• A company alone, when a general or role-based address will do.
• Postal or CRM identifiers, like a name plus a mailing address.

The output is one new column. But in between sits the step vendor pages skip past: Data Matching, which lines your row up against a database record using only the fields you handed over. Strong identifiers match. Thin ones don’t. So the Contact Data going IN decides most of what comes out.

Now, two very different families hide under one word. A B2B append takes a person plus a company and returns a work address on that company’s domain. A B2C or postal append takes a consumer name and home address and returns a personal one. Same verb, wildly different consequences.

One scoping note, because these jobs get muddled. An append runs identifiers in, email out. Going the other way, to identify who’s behind an email address, is a separate job. And if your rows already have emails and you want titles or phone numbers added, that’s email list enrichment.

Which Kind of Append Do You Actually Need?

B2B if you’re contacting people at work, B2C postal append if you’re contacting consumers at home. That sounds like a small distinction. It really isn’t.

The Consumer Postal Append (the risky one)

Here’s the part page one blurs on purpose. A consumer postal append takes a name and home address you already hold, matches it to a personal email address, and hands it back. But those people gave you a mailing address. They never gave you an inbox.

Plenty of email platforms restrict appended consumer data in their terms, and some will suspend an account over it. So providers offer a “permission pass”: a first email that says plainly where the address came from and offers an immediate way out. That’s a real mitigation, and a good vendor insists on it. Still, it isn’t consent.

The B2B Work Append (the calmer one)

A work address belongs to a role at a company rather than a private household. Because of that, business outreach in Europe usually rests on Legitimate Interest under GDPR, as long as you’re open about your source and make opting out painless. In the US, CAN-SPAM regulates how you send rather than how you sourced.

Neither framework hands you a free pass. Both are livable if you behave like a person.

And here’s what no append can do, in either family. It cannot manufacture consent. It cannot match a row carrying only a first name and a city. And it never returns everybody, so anyone promising a full match is quietly promising you bounces.

🔍 Did You Know? Google's bulk sender rules set the spam-complaint ceiling at 0.3% (three complaints per thousand emails). Appended contacts never asked to hear from you, so a sloppy append hits that ceiling far faster than an opt-in list would.

How Does an Email Append Service Work?

You send the provider a file, they match it against their database, and they send the file back. That’s the shape of every email append service I’ve dealt with. The details are what nobody puts on the pricing page.

1. You export the file. Usually a CSV, with whatever identifier columns you actually have.
2. You agree scope and terms. Ask for an NDA, ask how your file is stored, ask when it’s deleted.
3. They run the match. Your rows meet their records, field by field.
4. You get the file back. Matched rows carry an address; unmatched rows come back blank or flagged.
5. You verify. Never skip this, even when verification is included.
6. You send carefully. Small waves, real opt-out, eyes on the bounce report.

Now the number everyone asks about: the email append match rate. It moves with your input quality, your region, and the size of the companies on your list. A provider’s headline figure came from THEIR test file, assembled to look good. So the only match rate worth trusting is the one you measure on a sample of your own list.

Pricing usually works per matched record, and that’s the model I’d push for, because you pay for rows they actually filled. Some providers charge per file instead, or per record submitted whether it matched or not. Read that carefully. Turnaround runs from same day on small files to several days on large ones with manual review.

Seven Questions to Ask Before You Buy

Before you hand anyone your customer list, ask these. I keep them in a note and paste them into the first email:

• Where does the data come from? A vendor who can’t answer in plain language isn’t one.
• How often is it refreshed? A stale database returns yesterday’s addresses.
• Is Data Verification included? Syntax, domain and mailbox checks, or do you buy that separately?
• How do you bill unmatched rows? Get this in writing before the file goes out.
• What happens to my file afterwards? Retention, deletion, and who inside their business can open it.
• Can I run a paid sample first? A hundred rows tells you more than any case study.
• Legal entity names or trading names? Sounds fussy. It isn’t, and I’ll show you why shortly.

A provider who answers all seven plainly is someone you can work with. One who dodges the data-source question has just told you something.

The batch route is genuinely fine, by the way. It’s just slow, and it costs money before you’ve learned anything about your own file. If your list already sits in a CSV, you can enrich a CSV yourself and skip the round trip.

How Do You Append Emails Yourself From a Spreadsheet?

Install the add-on, add your API key, pick the right service, map your columns, and run your rows. Same job as the batch service. Except you keep the file, you watch every result land, and you can stop after ten rows.

1. Install the add-on. Grab the CUFinder add-on from the Google Workspace Marketplace. New to add-ons? Google’s help page explains how they install.
2. Copy your API key. Open your CUFinder dashboard and copy the API key from there.
3. Enter the key in the add-on. Paste it once and you’re connected.
4. Pick the service that matches your input. Open the add-on from the Google Sheets menu and it appears as a right panel listing all the enrichment services. Names plus companies in your rows? Choose Contact Enrichment, which will find a professional email by name and company. Company names only, no individual attached? Choose Company Name to Company Email, the company email finder that returns a general business address.
5. Set your columns and range, then run. Choose the input column, the output column where addresses land, and the row range: rows 2 to 100 for a sample, the whole sheet once you trust it.

Before you run anything, spend five minutes on the input columns. Cheapest match-rate upgrade there is:

• One person per row.
• The legal entity name in the company column, not the trading name.
• A consistent name format: “Jonas Weber,” never “WEBER, J.”
• Duplicates removed, or you’ll pay twice for the same person.
• Your range starting at row 2, so you don’t append an email for someone called “Name.”

That second bullet is the one that cost me. When I sampled 100 rows of the badge-scan file, about two-thirds came back with a work email, and I nearly accepted that as my ceiling. But the failures had a pattern: every one listed a trading name, the brand printed on the badge, instead of the registered company. So I spent an afternoon fixing that single column and re-ran the sample. The match rate climbed noticeably. Same tool, same file, same day.

Set your expectations honestly too. Some rows will come back blank, and that’s the tool declining to guess. An empty cell costs you nothing. A fabricated address costs you a bounce.

Working in Excel instead? Same job, different mechanics: the email lookup in Excel guide covers the CSV round trip. And if your rows are company domains rather than named people, that’s a bulk email finder workflow instead.

💡 Pro Tip: Run 100 rows and measure the match rate on YOUR data before you pay anyone anything, including us. A sample is the only honest product demo, and a provider who won't let you run one has answered your question.

A Worked Example: 5 Rows, Before and After

Let’s make it concrete. Say your sheet looks like this, with people in column A, their companies in column B, and an empty column C where the work emails should be:

	A	B	C
1	Name	Company	Work email
2	Amara Osei	Kestrel Freight Group
3	Jonas Weber	Northlight Instruments
4	Bea Lindqvist	Ferrow Materials
5	Ravi Chandra	Chandra Advisory
6	Hannah Mork	Pelham Dairy Co

Then I ran it: Contact Enrichment selected in the panel, input columns A and B, output column C, row range 2 to 6. A minute later, the same sheet looked like this.

	A	B	C
1	Name	Company	Work email
2	Amara Osei	Kestrel Freight Group	amara.osei@kestrelfreight.com
3	Jonas Weber	Northlight Instruments	j.weber@northlightinstruments.com
4	Bea Lindqvist	Ferrow Materials	bea.lindqvist@ferrow.com
5	Ravi Chandra	Chandra Advisory
6	Hannah Mork	Pelham Dairy Co	hannah.mork@pelhamdairy.com

Four rows filled. One didn’t, and that blank cell is the honest part of this example. Ravi runs a one-person advisory with no company mail domain behind it, so there was no work address to find. Nothing got guessed into that cell, which is exactly right.

Once the sample looks sane, widen the range and run the rest. Here’s how my badge-scan file actually went:

→ 2,800 rows → clean the company column → 100-row sample → full run → verify → three sending waves.

What Should You Check Before You Send to Appended Emails?

Verify every appended address, warm your sending domain, and send in small waves while you watch the bounces. Appending is the easy half. This next part protects your reputation with mailbox providers, which you can’t buy back quickly.

• Verify everything, including “verified” data. Syntax, then domain, then mailbox. Google’s Admin Toolbox MX check confirms a domain even receives mail.
• Treat catch-all results as maybes. A Catch-All Email domain accepts mail for any address, so “accepted” never proves the mailbox exists. Send to those last.
• Warm the sending domain. Volume jumping from nothing to thousands overnight reads as spam, and your Email Deliverability pays for it.
• Send in waves and read the bounce report. Google’s sender guidelines hold bulk senders to a 0.3% complaint rate, and one bad segment carries you past it.
• Include a real opt-out and a physical address. The CAN-SPAM compliance guide spells out honest headers, a working unsubscribe, and a postal address.
• Suppress before you send. Run the appended file against your unsubscribe and complaint lists first.

That wave discipline saved the badge-scan campaign. I had roughly 1,900 usable addresses and every instinct said send them all at once. Instead I sent about 300, waited a day, and read the bounce report. One segment came back ugly, so I pulled it, fixed it, and sent waves two and three clean.

What Mistakes Should You Avoid With Email Appending?

The big ones: appending without a lawful basis, skipping verification, and blasting the whole file on day one. I’ve made two of these personally, so treat this as a scar map.

• Appending to a list you have no lawful basis to contact. An append fills a column; it never creates permission.
• Skipping verification because “the vendor already verified it.” Data ages between their check and your send. Verify again, on your side.
• Blasting the whole appended file on day one. This is the most common way a good append becomes a deliverability problem.
• Leaving trading names and abbreviations in the company column. “Kestrel Freight” and “Kestrel Freight Group Ltd” are not the same string to a matching engine.
• Paying per record for rows you’ll never contact. Filter to your real target segment BEFORE the file goes out.
• Never refreshing. Contact data decays as people change jobs, so an appended column that’s sat for a year needs re-verifying.

📌 Example: My 100-row sample matched roughly two-thirds on the first pass. Every failure listed a trading name instead of the registered company. One afternoon of cleaning that column, one re-run, and the match rate climbed noticeably, all before I'd paid anyone for the full 2,800.

FAQ: Email Appending

What does “append” mean in email?

Two different things share that word. In Outlook or Gmail, appending means adding text to a message, like a signature or a legal disclaimer at the bottom. In data work, an email append adds a missing address to a record you already hold. This page covers the second one.

How much does an email append cost?

Most providers bill per matched record, so you pay only for rows they actually filled. Others charge per file, or per record submitted whether it matched or not. Consumer data is normally priced differently from business data. Get the model in writing, and ask how unmatched rows are counted.

Is there a free email append?

Not at scale, no. Free trial credits and small samples exist, and you should use them to test your own file. But a genuinely free bulk append doesn’t exist, because somebody paid to collect and refresh that data. The free lists circulating online are the ones that damage your domain.

What is a good email append match rate?

There’s no universal good number, because match rates move with input quality and region. A file of named people at mid-size companies matches far better than a column of trading names. So run a 100-row sample of your own list and measure it there. That figure is your benchmark, not the vendor’s demo.

Is email appending legal?

It depends on your data and your jurisdiction. Under GDPR you need a lawful basis, usually legitimate interest for business contacts, plus transparency and an easy opt-out. CAN-SPAM governs how you send: honest headers, a physical address, a working unsubscribe. Consumer postal appending carries much more risk. I’m a marketer, not a lawyer, so check with yours.

How do I append email addresses in Excel?

Excel has no native append function, so you round-trip the file. Export your sheet as a CSV, run the append through a Google Sheets add-on or a web enrichment tool, then import the finished file back into Excel. Your columns come back in the same order, with the email column filled.

What’s the difference between email appending and email verification?

Appending adds addresses you don’t have. Verification tests addresses you already have. You need both, in that order: append first, then verify every returned address before it touches a campaign. Skipping the second step is precisely how appended lists earned their reputation for bouncing.

Will appended emails hurt my deliverability?

They can, and often do when people rush. Appended addresses stay unproven until you verify them, and appended contacts complain more than opt-in subscribers because they never signed up. So verify everything, warm the domain, send in waves, and suppress complainers immediately. Do that and appends behave.

It’s Time to Fill That Empty Email Column

So here’s where you stand. You have a list that identifies people perfectly well but can’t reach one of them, and two honest ways to fix that. Send the file out and pay per matched record. Or open the sheet, sample 100 rows, and find out what your data is really worth before anyone invoices you.

You know which one I’d try first.

Picture your version of my badge-scan Monday. Column C fills while you make coffee. You clean the handful of company names that failed and re-run just those. Wave one goes out Tuesday, and by Thursday there are replies in your inbox that didn’t exist last week. Not magic. Just a column that finally has something in it.

And email is only the first missing column. The whole data enrichment in Google Sheets hub covers what to add after it: phone numbers, company size, revenue, tech stack, all of it.

Tell me in the comments: how many rows are sitting in your file right now with an empty email column?