Print Avery Address Labels from Google Sheets: Step-by-Step Guide

Evelyn Jul 09, 2026

Streamlining your mailing process? Avery address labels can significantly speed up this task, especially when integrated with Google Sheets. By following this comprehensive guide, you'll learn how to print Avery address labels directly from your Google Sheets data, ensuring a professional and efficient mailing experience.

Free: Create Avery Address Labels in Google Docs
Free: Create Avery Address Labels in Google Docs

Before diving into the process, ensure you have Google Sheets set up with your recipient's addresses in the correct format. Avery offers various label templates, with the most common being the 5160 (30 labels per sheet), so organize your data accordingly.

Address Label Template | Free Word Templates
Address Label Template | Free Word Templates

Preparing Your Google Sheets Data

To print Avery address labels accurately, your Google Sheets data should be structured correctly. Here's how to prepare your data:

Make Your Own Return Address Labels
Make Your Own Return Address Labels

1. Use a single column for addresses, with each cell containing one address. Avery labels are designed to accommodate multiple lines, so use line breaks (
) to separate the street, city, state, and zip code.

Formatting Addresses

Learn How to Upload and Print a Project to Avery Design & Print Online
Learn How to Upload and Print a Project to Avery Design & Print Online

To insert line breaks, click on the cell containing the address, then click "Enter" to start a new line. Alternatively, use the "Alt + Enter" shortcut on Windows or "Option + Return" on Mac to insert a line break.

Example: 123 Main St
Anytown, ST 12345

Adding Labels

Design Templates for Christmas Cards | Free & Customizable
Design Templates for Christmas Cards | Free & Customizable

Once your addresses are formatted correctly, you're ready to add labels. Google Sheets offers an "Image" function that allows you to insert Avery label templates. Here's how to do it:

1. Click on "Insert" in the menu, then select "Drawing" or "Image" (depending on your Google Sheets version).

2. Upload the Avery label template (e.g., 5160) and position it on your sheet. You can resize it to fit your data.

How to Make an Address Book with Google Sheets
How to Make an Address Book with Google Sheets

Printing Avery Address Labels

With your data prepared and labels added, it's time to print your Avery address labels. Follow these steps:

Free Blank Label Templates Online
Free Blank Label Templates Online
White Address Labels A4 Template
White Address Labels A4 Template
Microsoft Word Label Templates Avery 5160
Microsoft Word Label Templates Avery 5160
someone holding up a avery address label on a white wall with the words how to make address labels
someone holding up a avery address label on a white wall with the words how to make address labels
How to Make Personalized Address Labels using Cricut
How to Make Personalized Address Labels using Cricut
Avery Template 5163 Shipping Labels 2
Avery Template 5163 Shipping Labels 2
a laptop computer with the words how to create address labels with images in microsoft word
a laptop computer with the words how to create address labels with images in microsoft word
Make Your Own Christmas Address Labels...Picture Tutorial
Make Your Own Christmas Address Labels...Picture Tutorial
How To Create Blank Avery 5160 Free Template
How To Create Blank Avery 5160 Free Template
How to Create Printable Address Labels with Images in Microsoft Word
How to Create Printable Address Labels with Images in Microsoft Word
autofillPDF-Labels 1.0 - print labels in seconds
autofillPDF-Labels 1.0 - print labels in seconds
Avery | Labels, Cards, Dividers, Office Supplies & More
Avery | Labels, Cards, Dividers, Office Supplies & More
Label Templates Free Download Patible with Avery Label Template 5162 – Simple Template Design
Label Templates Free Download Patible with Avery Label Template 5162 – Simple Template Design
How to create and print Avery Labels straight from home | Business Tip |
How to create and print Avery Labels straight from home | Business Tip |
Avery Template 5162 Address Labels 1-1/3
Avery Template 5162 Address Labels 1-1/3
Avery Label Templates - Blue Layouts
Avery Label Templates - Blue Layouts
How to add your own text to printable labels (plus FREE printable cleaning labels!)
How to add your own text to printable labels (plus FREE printable cleaning labels!)
IHeart Freebies:  Address Labels!
IHeart Freebies: Address Labels!
Editable Avery Label 5610 and 5613 Power Point Template Bundle
Editable Avery Label 5610 and 5613 Power Point Template Bundle

1. Select the range containing your addresses and labels. Ensure you've selected the correct number of labels for your Avery template.

Setting Up the Printer

Before printing, ensure your printer is set up correctly:

1. Click on "File" in the menu, then select "Print".

2. Choose your printer and click "Options".

3. Under "Layout", select "Fit to page width" or "Scale to fit" to ensure your labels print correctly.

Printing the Labels

Once your printer settings are configured, print your labels:

1. Click "Print" or press "Ctrl + P" on Windows or "Command + P" on Mac.

2. Ensure the correct number of copies is selected (usually 1, as Avery labels are designed for single-sided printing).

3. Click "Print" to print your Avery address labels.

Congratulations! You've successfully printed your Avery address labels using Google Sheets. This efficient process ensures your mailings are professional and well-organized. Now that you've mastered this technique, consider exploring other Google Sheets and Avery label integrations to further streamline your workflow.