Make the label
- At the left, next to Labels, click Create label.
- Type a name, such as Christmas cards, then click Save.
Google Contacts · Google CSV
Print address labels from Google Contacts
Export your contacts from contacts.google.com as a Google CSV file: select them, then More actions > Export. Open the file below, choose the number on your label box and download a PDF that lines up.
- No upload. No account.
- Reads Google CSV as it comes
- Starts on a half-used sheet
Before you export
Put the card list in one label.
Google Contacts calls its groups labels. A label with only the people who get a card keeps everyone else off the sheet, and it's still there next year. Already have one? Go to the steps.
Put the people in it
- Check the box next to each person who gets a card.
- At the top, click Manage labels, click Christmas cards, then Apply.
From Google Contacts to labels in four steps.
-
Open Google Contacts on a computer
Go to contacts.google.com and sign in. The contacts you keep in Gmail are there too.
On a phone?
The Contacts app on Android exports a .vcf file (Fix & manage > Export to file, Google's Android steps), and this page opens that too. Google's steps for a Google CSV file are for a computer.
-
Select the people
At the left, click your card list's label. Check the box next to one person, then Selection actions > All at the top left. No label? Check each person's box, or make one first.
-
Export as Google CSV
At the top right, click More actions > Export. Choose Google CSV, then Export (Google's steps).
Or vCard?
A vCard (.vcf) file opens here too, each part of an address read on its own, as in Google CSV. A contact with both a home and a work address gets the kind most of your contacts have, or the one its card marks as preferred.
-
Open the file below
Open the .csv or .vcf in the box below, choose the number on your label box and download the PDF. Print it at 100% (Actual size).
Do it here
Open your Google CSV here.
Open the .csv file Google Contacts saved, or its .vcf. Names and addresses are read from Google's own columns; e-mail, phone and labels stay off. A contact with no address prints its name alone, as Theo's does in the sample.
Sheet 1 of 1
Worked example
Four contacts in, four labels out.
Google's columns, read as they come: the apartment joins the street, the country prints only outside the US, and the company stays off a home address.
| Row | First Name | Last Name | Organization Name | Labels | Address 1 - Street | Address 1 - Extended Address | Address 1 - City | Address 1 - Region | Address 1 - Postal Code | Address 1 - Country |
|---|---|---|---|---|---|---|---|---|---|---|
| 2 | Grace | Whitfield | * myContacts ::: Christmas cards | 14 Birch Hollow Rd | Concord | MA | 01742 | US | ||
| 3 | Daniel | Okoro | * myContacts ::: Christmas cards | 2207 Bryant St | Apt 3 | San Francisco | CA | 94110 | US | |
| 4 | Marisol | Vega | Vega Design Studio | * myContacts ::: Christmas cards ::: Work | 88 Juniper Ct | Santa Fe | NM | 87505 | US | |
| 7 | Nora | Fitzgerald | * myContacts ::: Christmas cards ::: Family | 210 Queen St W | Toronto | ON | M5V 2B1 | Canada |
- Apt 3, from Extended Address, joins the street: 2207 Bryant St, Apt 3.
- Canada gets a line of its own; US addresses print no country.
- Marisol's Address 1 is her home, so it prints without Vega Design Studio: the company goes with a Work address.
- Google's Labels column, e-mail and phone never print.
Sheets for your contacts
Sizes from Avery's own template files. The numbers in a row share one layout, so one PDF fits them all.
| Sheet | Label size | Per sheet | Same layout | Good for |
|---|---|---|---|---|
| Avery® 5160 | 1 × 2-5/8 in | 30 | 8160 · 9160 · 18160 +56 | Most contacts: a name, a street and a city line at 10 pt. |
| Avery® 5161 | 1 × 4 in | 20 | 8161 · 5261 · 5909 +19 | Long names and long streets: the labels are 4 in wide. |
| Avery® 5162 | 1-1/3 × 4 in | 14 | 8162 · 5262 · 5522 +8 | A contact abroad: four lines, the country last, at 12 pt. |
- Exported everyone? Contacts with no address print their name alone: what prints, and what doesn't.
- Half a sheet left? Set Start at label in the box above to the first free label.
What happens to Google's columns.
A Google CSV file has about thirty columns. Ten of them make the label, the company only above a work address; the rest stay in your file.
-
Line 1
- First Name
- Last Name
-
Line 2
- Organization Name
-
Line 3
- Address 1 - Street
- Address 1 - Extended Address
-
Line 4
- Address 1 - PO Box
-
Line 5
- Address 1 - City
- Address 1 - Region
- Address 1 - Postal Code
-
Line 6
- Address 1 - Country
No address at all
A contact with no address prints its name alone, as Theo's does in the sample. The box above says how many there are, and the full editor's Leave them out drops them all.
Read only when needed
Address 1 - Formatted is read for a contact whose Street, City and the rest are empty, without its last line when that says US.
Address 2 is used only for a contact with no Address 1.
Left off the label
- Middle Name
- Name Prefix
- Name Suffix
- Nickname
- Labels
- E-mail 1 - Value
- Phone 1 - Value
- Birthday
- Notes
Want Dr. on the label? In the full editor, insert that column into a line.
Three things that keep 5160 labels straight.
Print at actual size
"Fit to page" can resize the sheet, and then the lower rows drift off their labels. The PDF opens at 100%; keep it there.
Feed the right side up
Printers differ: some print on the side facing up in the tray, others on the side facing down. Mark an X on a plain sheet, print once and look before you load labels.
Test on plain paper
Hold a plain-paper print over a 5160 sheet against a window. If it sits off, calibrate once and save the correction for that printer.
Questions people ask
Can you print address labels from Google Contacts?
Yes, from its export. Select the contacts, choose More actions > Export and pick Google CSV (Google's steps). Then open the file above, choose the number on your label box and download the PDF.
How do I print address labels from Gmail contacts?
Gmail's contacts live in Google Contacts, so the steps are the same: export them from contacts.google.com as Google CSV and open the file here. People you only e-mailed are saved under Other contacts with their e-mail address (Google's note): add a street address to anyone who gets a card.
Can I print labels for one group of contacts?
Yes. Google Contacts calls its groups labels: click the label at the left, select its people and export them as Google CSV. Putting your card list in a label.
Which export should I choose: Google CSV or vCard?
Either: Google's help names a CSV or a vCard file (Google's steps), and this page reads both, each part of an address on its own. Google CSV is the one to pick if you want to look the list over in a spreadsheet first.
Can I do it from my phone?
On Android, yes: the Contacts app saves a .vcf file (Google's steps), and this page opens it. If your iPhone syncs its contacts with your Google account, they're in Google Contacts too (Google's note), so you can export them from a computer.
Can I print address labels from Google Sheets?
Yes: select the cells of your list, header row included, copy them and paste them in the box above. The labels come out the same way. More on printing labels from Google Sheets.
Is my contact list uploaded?
No. The file is read in your browser and the PDF is made there too. Nothing is uploaded, nothing is stored, and the list never goes in the page address.
Bigger lists, more control.
The editor opens the same file and does more: leave out contacts with no address in one click, sort by last name or ZIP code, add a column to a line, print copies.