How to print envelopes from Google Sheets
By Jake Marsh · Updated
To print envelopes from Google Sheets, install Labelyard, open Extensions > Labelyard > Create labels and pick your envelope (for example "#10 business envelope" or "A7 invitation envelope") in the Label sheet list. Write the recipient's address with column names like {{Name}}, type your return address in the box for the top left corner, click Create PDF, and set the same envelope size in your printer's dialog. Each row prints on its own envelope.
Before you start
- A Google Sheets tab with one recipient per row and column names in row 1.
- Envelopes your printer can feed. Most home printers take one envelope at a time or a small stack in the rear or manual tray; check your printer's manual for which way up they go.
- Labelyard has five envelope sizes: #10 (4-1/8 x 9-1/2 in), 6 x 9 in catalog, A7 (5-1/4 x 7-1/4 in), DL (110 x 220 mm) and C5 (162 x 229 mm).
Steps
- Open Extensions > Labelyard > Create labels.
- Search "envelope" under Label sheet and click your size.
- Pick the rows to print. For a test, choose Row numbers... and type a single row.
- Write the recipient address on the Design tab:
{{Name}} {{Address}} {{Address 2}} {{City}}, {{State}} {{ZIP}} - Type your return address in Return address (top left of the envelope). It prints the same on every envelope.
- Click Create PDF. Each page of the PDF is one envelope, sized to it.
- Print with the envelope size selected in the print dialog and Scale at 100%. Print one envelope first and check which side and which edge your printer feeds.
Clean addresses on every envelope
Guest lists and customer lists are rarely tidy. Labelyard handles the common problems as it lays out each envelope:
- Missing lines disappear. With Leave out lines whose columns are empty ticked, a row with no Address 2 prints three lines instead of three lines and a gap.
- Stray commas go. A row with no city doesn't print ", NY 10001".
- ZIP codes keep their zeros. Labelyard reads the values the way the sheet displays them, so a ZIP shown as 02134 prints as 02134.
- Long names fit. Text shrinks a little, then wraps, so "The Hernandez-Whitfield Family" stays on the envelope.
The preview on the right shows each envelope as it will print. Click through a few rows with long names before you print the whole batch.
Envelopes or address labels?
| Envelopes | Address labels |
|---|---|
| No labels to peel and stick | Faster for a long list, 30 to a sheet |
| Looks finished for invitations and cards | Works with any envelope or package size |
| Each envelope is fed by hand on most home printers | Feeds like normal paper |
For a long holiday card list, address labels on the 5160 layout are often quicker. For wedding invitations, printing on the A7 envelope looks cleaner.
What it costs
Labelyard's free trial covers your first 300 labels or 14 days, whichever comes first, with no card needed. Previews and alignment test pages never count. After that it's $9.99 a month, $39 a year or $99 once for lifetime use on one Google account, and a $149-a-year team plan covers everyone at your company or school domain. Install it from the Labelyard page.
Labelyard: Print Labels & Envelopes
Print address labels, name tags and stickers from Google Sheets rows, lined up on the first try $9.99 a month or $39 a year per Google account.
Questions
Can I print a return address only, with no recipient?
Use a return address label sheet instead: pick the 5167 layout (80 per sheet) and The same label on every spot.
Which envelope do I use for wedding invitations?
A7 envelopes (5-1/4 x 7-1/4 in) fit 5 x 7 invitations, and Labelyard has that size built in.
Why does my printer put the address in the wrong place on the envelope?
The PDF page is the envelope's size, so a wrong position almost always means the printer used a different paper size or scaled the page. Select the envelope size in the print dialog and set 100%. If it's still shifted, use Move right (mm) and Move up (mm) on the Print tab.
Can each envelope have a different return address?
No. The return address box prints the same text on every envelope. For two senders, filter the sheet to one sender's rows, print with Only rows visible after filtering, then change the return address and print the rest.
More Labelyard guides
More Google guides
- How to create a PDF for each row in Google Sheets (PickMerge)
- How to make a Google Sheets spreadsheet accessible (Includewell)
- How to export more than 1,000 rows from Search Console (Queryledger)
- How to count cells by font color in Google Sheets (Huecount)