Free template
Address list template
People search for an address list template at very predictable moments: a wedding, a move announcement, holiday cards, a baby arriving. The job is always the same — get a clean set of postal addresses out of a chaos of old texts, envelopes, and half-remembered apartments. A spreadsheet is genuinely the right tool here, because the end product is usually a mail merge or a sheet of labels, and both want columns, not prose. The trick is splitting the address into separate fields (street, ZIP, city, country) from the start; one big address blob is the single most common reason label printing fails. Where the sheet stops working is freshness: people move, and a list you built for the wedding is quietly 20 percent wrong by the next occasion. Keep a verified-date column, and if your addresses live alongside birthdays and notes anyway, this CSV imports cleanly into Endearist.
Opens in Excel, Google Sheets, Numbers — or imports straight into Endearist.
What each column means
| Column | How to use it | Example |
|---|---|---|
| Name | The primary person you're addressing in the household — one row per household, not per person. | Ruth Calloway |
| Household members | Who else lives there — partner, kids, housemates. Matters so nobody is missing from the card, or wrongly included. | Husband Pete, kids Owen and June |
| Street address | Street, house number, and unit or apartment if needed — everything that belongs on the first address line. | 482 Alder Street, Apt 3 |
| ZIP / postal code | Format as text, not number — otherwise Excel eats the leading zero of New England ZIP codes like 02139. | 02139 |
| City | Its own column rather than "city, state" in one field — that's what lets you filter by place and print clean labels later. | Cambridge, MA |
| Country | Fill in only for international addresses and print it in capitals on the last line — that's what postal services expect. | CANADA |
| Label line | The finished first line for the envelope or label — "The Calloway Family" or "Ruth Calloway & Pete Shaw". Saves all the rework at print time. | The Calloway Family |
| Last verified | When you last confirmed the address (YYYY-MM-DD) — because mail arrived or you visited. Addresses go stale faster than you'd think. | 2026-04-18 |
| Notes | Postal quirks: unlabeled buzzer, PO box preferred, "moving in the fall". No personal secrets — this is a mailing list. | Moving to Denver in October — confirm before the holidays |
How to use this template
- Set the ZIP column to text immediately
Before you type a single address, select the ZIP column and format it as plain text (in Sheets: Format → Number → Plain text). Otherwise the program turns 02139 into 2139, and you'll only find out when cards bounce back as undeliverable.
- Keep every address part in its own column
Resist the urge to write "482 Alder Street, Cambridge, MA 02139" into one cell. Mail merge in Word and every label tool expect separate fields for street, city, and ZIP — a glued-together field means an hour of find-and-replace surgery later.
- Verify the stalest entries before each mailing
Before any mailing, sort by the last-verified column and send the five to ten stalest entries a quick message: "Are you still on Alder Street?" It takes ten minutes and beats getting a card back stamped "return to sender" weeks after the occasion.
- Print labels with mail merge, not by hand
For labels, use Word's Mailings → Start Mail Merge → Labels and pick this file as the data source; in Google Docs an extension like Avery Label Merge does the same job. The label-line column becomes line one, street below it, then city and ZIP — set it up once and every future occasion prints in minutes.
Mistakes to avoid
- One row per person instead of per household
If Ruth and Pete each get their own row, the household gets two cards — or you're deduplicating by hand at send time. For a mailing list the rule is one row per mailbox, with everyone living there in the household-members column. Per-person lists are a different tool for a different job.
- Only touching the list every few years
Roughly one in ten people moves every year. An address list opened for the wedding and then again three years later is substantially fiction the second time. Update an address the moment you hear about a move — that's exactly what the "moving in October" style note is for.
- The same person under three spellings
"R. Calloway", "Ruth Calloway", and "Calloway, Ruth" are three different people as far as the sheet is concerned — and merging several old lists produces exactly this. Settle on one name format, sort alphabetically once, and clean up duplicates before printing labels, not after.
- Sharing the address list around
It's tempting to share the file "briefly" with family so everyone can contribute addresses. But a collection of private home addresses with kids' names attached is sensitive — once shared via "anyone with the link", it can't be un-shared. Collect addresses by message instead and keep the file under one pair of hands.
Frequently asked questions
- How do I make an address list in Excel?
- Download the CSV and open it in Excel. First, format the ZIP column as text so leading zeros survive, and freeze the header row. Then enter one row per household, keeping street, city, and ZIP in separate columns. That makes the list mail-merge-ready immediately and lets you sort by city or by when you last verified an address.
- How do I print address labels from a spreadsheet?
- In Word, go to Mailings → Start Mail Merge → Labels, choose your label stock (Avery formats are built in), and select this spreadsheet as the data source. Map the fields — label line, street, city, ZIP — and run the merge. In Google Docs, a free extension like Avery Label Merge walks through the same flow.
- How do I ask people for their current address without it being awkward?
- Lead with the occasion and keep it direct: "We're sending holiday cards this year — are you still at 482 Alder Street?" A confirmation question is easier to answer than an open request for a full address, and it shows you had it once. For many addresses at once, a short personal message per household beats an anonymous form.
- Is it legal to keep a list of people's home addresses?
- For private purposes — birthday mail, invitations, holiday cards — yes, that's ordinary and fine; data-protection rules like the GDPR explicitly exempt purely personal and household activity. Care is still warranted: no public sharing, no passing the list to third parties, and delete what you no longer need. The moment the list serves a business purpose, stricter rules apply.
Last updated: 2026-06-10
When the spreadsheet gets too small.
Endearist imports this CSV directly — and reminds you before contacts go quiet. Free up to 25 contacts.
Start free