Free address list template
A simple address book in a spreadsheet. Fill in your contacts once, then print address labels from the same list whenever you need them.
Free while in beta · no card needed
How it works
- Download the template. Choose the Excel (.xlsx) file, or the CSV file for Google Sheets or Numbers.
- Fill it in, one person per row. Delete the two grey example rows first. Keep the heading row at the top.
- Paste the list into LabelPeel. Copy the rows with the heading row, or upload the file. Pick your sheet, check the labels, and print.
Make address labels from your list
What is in the template
The address columns are the ones LabelPeel reads for labels. Keep the headings as they are.
| Column | What goes in it |
|---|---|
| First name, Last name | The person's names, in separate columns |
| Company | The business name, if the address is for work |
| Address, Address 2 | The street and any apartment or suite line |
| City, State, ZIP, Country | The town, state, ZIP code and country (leave Country blank in the US) |
| Email, Phone | Contact details |
| Birthday | A date or a month and day, such as March 14 |
| Notes | Anything else you want to keep |
Use it in Excel, Google Sheets or Numbers
- Excel: Double-click the .xlsx file. The heading row stays on the screen as you scroll, and the filter arrows sort the list by last name or ZIP code.
- Google Sheets: Click File › Import, choose the Upload tab, and pick the CSV or Excel file.
- Numbers: Open the CSV or .xlsx file with File › Open. Check that ZIP codes still show their leading zeros.
If you want more help with the spreadsheet, read the guide to printing labels from Excel or the guide to printing labels from Google Sheets.
Make labels from your list
- Copy the rows from the heading row down, and paste them into LabelPeel. You can also upload the saved file.
- Pick Avery® 5160 for 30 labels on a sheet. For longer addresses, try Avery® 5161, which is 1 inch by 4 inches.
- Ask the AI helper to change the list. Try "sort by last name" or "only keep the rows where City is Miami".
- Print a test page on plain paper, hold it over a label sheet, and then print at 100% or Actual size.
The label sizes chart shows what each sheet is for. Every sheet page also has a free Word and PDF template.
Ideas you can type
- "Sort by last name."
- "Only keep the rows where State is FL."
- "Remove the rows that have no city."
- "Make the names bold and the address normal."
Keep the list clean
Most mistakes on labels come from the list, not the printer. Before you print, scan the list for three things. Check that every row has a full address, including the ZIP code. Check that names are spelled the same way every time, such as "Smith" and not "smith" in one row. Check that the Country column is blank for US addresses, or filled in for every row if you mail abroad.
Use the filter arrows on the heading row to find blank cells quickly. A short check takes a few minutes, and it saves you from reprinting a full sheet of labels.
Tips
- Keep one address per row. If two people share an address, use two rows.
- Type the ZIP code as text, so codes that start with zero keep it.
- Remove duplicates before you print, so no one gets two labels.
- Keep a backup copy of the file before you make big changes.
Sheets for this job
Questions
Is this address list template free?
Yes. Download the Excel or CSV file and fill it in. You do not need an account to download it.
Can I use this as a contact list too?
Yes. It has first and last name, company, email, phone and birthday columns, so it works as a simple contact list.
Can I print labels from the address list?
Yes. Paste the rows into LabelPeel, pick Avery® 5160 or another sheet, and print at 100%. Print a test page on plain paper first.
Do I need to put the names in two columns?
Yes, the first name and last name go in separate columns. LabelPeel joins them on the label, so Jane and Smith print as Jane Smith.
Skip the mail merge — paste your list and print
Every row becomes one label, lined up on the sheet. Free while LabelPeel is in beta.
Guides
How to Print Labels From Excel (3 Easy Ways)
Three ways to print labels from an Excel list: Word mail merge, Avery® Design & Print, or pasting the rows into LabelPeel. Steps for each and fixes.
How to Print Labels From Google Sheets
Print labels from a Google Sheets list in three ways: paste it into a label tool, export it to Excel for a mail merge, or build a table in Docs.
How to Print Address Labels at Home (4 Easy Ways)
Print address labels in Word, the Mac Contacts app or LabelPeel. Covers address layout, return labels, which Avery® sheet to buy and printing fixes.
Labels Not Lining Up? How to Fix Print Alignment
Labels not lining up? Fix print scaling, paper size, the wrong template and printer feed, then test on plain paper. Also print a single label.