Print Return Address Labels from Google Sheets with Avery Templates

You just moved into a new place, you're sending holiday cards to fifty people, or your small business ships dozens of packages a week. Whatever the reason, typing your return address over and over is nobody's idea of a good time. The fix? Print return address labels straight from Google Sheets using Avery-compatible templates like the Avery 5167 (80 labels per sheet) or the Avery 5195 (60 labels per sheet). Both are designed specifically for return addresses, and with the right workflow you can go from a spreadsheet of contacts to a finished, perfectly aligned sheet of labels in minutes.

This guide walks you through the entire process. We'll cover how to set up your data in Google Sheets, choose the right Avery template for your needs, merge everything together, and print with pixel-perfect alignment. No expensive software required.

Choosing Between Avery 5167 and Avery 5195 for Return Addresses

Before you touch a spreadsheet, you need to pick the right label sheet. Avery 5167 and Avery 5195 are both marketed as return address labels, but they serve slightly different purposes. Understanding the difference saves you from buying the wrong supplies and reprinting an entire batch.

Avery 5167: The Compact Workhorse

The Avery 5167 measures 1/2" x 1-3/4" and fits 80 labels on a single letter-size sheet. That tiny footprint is ideal when your return address is short and straightforward, something like:

Because the label is small, you'll typically use a font size between 6pt and 8pt. That sounds tiny, but laser printers handle it crisply. The big advantage here is volume. A single sheet gives you 80 labels, so a pack of 25 sheets produces 2,000 labels. If you're a small business owner who ships frequently, that efficiency matters.

Grab the free Avery 5167 template for Google Docs to get started with this layout.

Avery 5195: A Little More Breathing Room

The Avery 5195 measures 2/3" x 1-3/4" and fits 60 labels per sheet. That extra sliver of height (about 1/6 of an inch) might not sound like much, but it makes a noticeable difference. You can comfortably fit a four-line address, bump the font size up to 8pt or 9pt, or add a small company tagline beneath your name.

This template is a better choice when:

• Your return address includes a suite number, apartment, or unit line

• You want to include a phone number or website below the address

• Readability matters more than label count (invitations, formal correspondence)

• You prefer a slightly larger font for aesthetic reasons

Download the free Avery 5195 template for Google Docs if you'd like the roomier option.

Quick Comparison

Both templates use standard letter-size sheets (8.5" x 11") and work with most inkjet and laser printers. If you're unsure, buy a small pack of each and print a test sheet. That five-dollar experiment saves a lot of frustration later.

Setting Up Your Google Sheets Data for a Clean Mail Merge

A label merge is only as good as the data behind it. Messy spreadsheet data leads to labels with inconsistent formatting, missing apartment numbers, or weird capitalization. Spend a few minutes organizing your Google Sheet before you merge, and every label will come out clean.

Building the Right Column Structure

Open a new Google Sheet and create columns that match each piece of information you want on the label. For a return address, that typically looks like this:

A few rules to follow:

• One piece of data per column. Don't combine city, state, and ZIP into a single cell. Keeping them separate gives you flexibility to format the final label exactly the way you want.

• Use a dedicated Address Line 2 column even if most rows leave it blank. This handles suite numbers, apartment numbers, or "Attn:" lines without forcing you to cram everything into one field.

• Abbreviate states with two-letter postal codes. According to USPS Publication 28, the official standard is the two-letter abbreviation (CA, not Calif.) followed by the ZIP code. Following postal standards improves deliverability and looks professional.

• Format ZIP codes as plain text. Google Sheets sometimes drops leading zeros from ZIP codes (turning 01234 into 1234). Select the ZIP column, go to Format > Number > Plain Text, and re-enter any affected values.

Cleaning Up Common Data Problems

Before merging, scan your sheet for these frequent issues:

1. Inconsistent capitalization. If some names are in all caps and others in title case, use the formula =PROPER(A2) to standardize them. Copy the cleaned values and paste them back as "Values only" to replace the originals.

2. Extra spaces. Trailing or double spaces sneak in when you copy-paste from other sources. The =TRIM(A2) function strips them out.

3. Missing data. If a row is missing a city or ZIP, your label will print with a blank gap. Filter each column for blanks and fill them in before merging.

4. Duplicate rows. For return address labels where every label is the same (your own address repeated 80 times), you only need one row of data. The merge tool will replicate it across every label on the sheet. But if you're printing return address labels for multiple senders, like a team of sales reps, make sure each person appears only once to avoid wasted labels.

Once your data is clean, you're ready to connect it to a template. If you've done mail merges before with shipping or mailing labels, the workflow is similar. For a broader walkthrough of the merge process with other label sizes, check out how to mail merge labels from Google Sheets to Avery templates.

Merging Your Spreadsheet Data into the Avery Template

With your data organized and your template chosen, it's time to connect the two. Foxy Labels integrates directly with Google Sheets and Google Docs to pull your spreadsheet rows into label templates without any manual copy-pasting.

Step 1: Open Your Template in Google Docs

Start by opening the Avery template you downloaded. The 5167 template will show a grid of 80 small label cells, and the 5195 will display 60. Each cell represents one label on the physical sheet. You'll notice the cells are already sized and positioned to match the Avery label dimensions, so the printed output aligns perfectly with the adhesive labels.

Step 2: Launch the Foxy Labels Add-On

From within Google Docs, open the Foxy Labels add-on (found under Extensions). The add-on reads your template layout and connects to your Google Sheets file. Select the spreadsheet that contains your return address data, then choose the specific sheet tab if your file has multiple tabs.

Step 3: Map Your Merge Fields

The add-on will display a list of available columns from your spreadsheet: Name, Address Line 1, Address Line 2, City, State, ZIP. You drag or insert these field placeholders into the first label cell of the template. A typical return address layout looks like this:

Format the text the way you want it to appear on every label. Set the font (Arial or Helvetica work well at small sizes), adjust the size (7pt for 5167, 8pt for 5195), and tweak line spacing if needed. Whatever formatting you apply to this first cell gets replicated across all labels.

A few formatting tips:

• Left-align text for a clean, professional look. Centered return address labels can look awkward on small envelopes.

• Use a sans-serif font. At 7pt or 8pt, serif fonts lose clarity. Arial, Calibri, and Helvetica all print crisply on both inkjet and laser printers.

• Handle blank Address Line 2 gracefully. If some rows have a suite number and others don't, the add-on can skip blank fields so you don't end up with an empty line in the middle of the label.

Step 4: Generate and Review

Hit the merge button. The add-on populates every label cell on every page with data from your spreadsheet. If you have one row and 80 labels (Avery 5167), that single address fills all 80 positions. If you have 10 different sender addresses, they'll fill the first 10 label positions, and you can choose to leave the rest blank or repeat them.

Before printing, zoom in and review several labels for:

• Correct spelling of names and street addresses

• Proper state abbreviations and ZIP codes

• No text clipping or overflow at label edges

• Consistent font size and spacing across all labels

If you need to produce labels regularly, perhaps monthly mailers or weekly shipments, Foxy Labels pricing plans offer unlimited mail merges from Google Sheets so you can regenerate labels whenever your contact list changes.

Printing, Troubleshooting, and Getting Perfect Results Every Time

The merge is done, your document looks great on screen, and now comes the part that trips up most people: printing. Label alignment issues are the number one complaint in online forums about Avery labels, and nearly all of them come down to printer settings, not template errors.

Dialing In Your Print Settings

When you print from Google Docs (File > Print), the browser hands the job off to your system's print dialog. Here's the checklist that prevents misaligned labels:

1. Set paper size to US Letter (8.5" x 11"). This should be the default, but verify it. A4 paper is slightly taller and narrower, which shifts every label position.

2. Set margins to "None" or "Minimum." Google Docs sometimes adds its own margins on top of the template margins. The Avery template already accounts for the correct page margins, so your print settings should not add more.

3. Set scale to 100% (Actual Size). Never choose "Fit to Page" or "Shrink to Fit." Any scaling, even 99%, shifts label positions enough to cause visible misalignment across 60 or 80 labels.

4. Disable headers and footers. Some browsers print page URLs or dates in the margin area, which pushes content down.

Running a Test Print

Before loading your Avery label sheets, print the first page on plain paper. Then hold the printed page up against an unused Avery sheet with a light behind them (a window works perfectly). Check whether the text falls within the label boundaries. If it's off by a millimeter or two, adjust the template margins slightly and test again.

This one step saves more label sheets than any other tip in this guide. A pack of Avery labels costs more than a sheet of copy paper, so always test first.

Common Problems and Fixes

Text is cut off on the right edge. Your return address or name is too long for the label width. Shorten the text, reduce the font size by 0.5pt, or switch from Avery 5167 to 5195 for the extra width (both are 1-3/4" wide, so if width is the issue, consider abbreviating the street name or using a narrower font like Arial Narrow).

Labels align on the first row but drift lower on subsequent rows. This almost always means your print scale is set to something other than 100%. It can also happen if the template has an extra line break at the top of the page. Check both.

Ink smears on the label surface. Avery labels come in inkjet and laser varieties. Using inkjet labels in a laser printer (or vice versa) causes smearing and poor adhesion. Check the label packaging to confirm compatibility with your printer type.

Labels peel up inside the printer and cause a jam. This happens with old or improperly stored label sheets. Store labels flat in their original packaging, away from humidity and heat. If a sheet feels like the labels are already lifting at the edges, don't feed it through your printer.

Beyond Return Addresses

Once you've mastered return address labels, the same workflow applies to other label sizes. Shipping labels, file folder labels, name badges, and product labels all follow the same pattern: organize your data in Google Sheets, open the right template, merge, and print. You can browse the full catalog of Avery-compatible templates to find the exact layout for your next project, whether that's a 4" x 6" shipping label or a round jar label for homemade candles.

The combination of Google Sheets and Avery-compatible templates puts professional label printing within reach of anyone with a browser and a printer. No design degree needed, no expensive software subscriptions, and no more handwriting your address eighty times over. Start with the Avery 5167 template or the Avery 5195 template, set up your spreadsheet, and print your first batch of return address labels today.