How to Print Avery Labels from Google Sheets

Evelyn Jul 09, 2026

Ever found yourself in a situation where you need to print Avery labels from Google Sheets, but you're not sure how to go about it? You're not alone. Avery labels are a popular choice for creating professional-looking labels, and with Google Sheets, you can create and print them with ease. In this guide, we'll walk you through the process step by step, ensuring you get the most out of your Google Sheets and Avery labels.

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

Before we dive in, make sure you have the following: a Google Sheets account, an Avery label template (you can find these online or purchase them), and a printer compatible with your Avery label size. Let's get started!

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

Preparing Your Google Sheets

First things first, you need to set up your Google Sheets document with the information you want to appear on your Avery labels.

Free Blank Label Templates Online
Free Blank Label Templates Online

Here's a quick tip: Use the table format in Google Sheets for better organization and easier printing. You can do this by highlighting your data, clicking 'Format' in the menu, then 'Format as table'.

Formatting Your Data

How to make printable labels for FREE (using Canva)
How to make printable labels for FREE (using Canva)

Once your data is in a table, you can format it to fit your Avery labels. Here's how:

1. Select the range of cells you want to format. Right-click and select 'Format cells'.

2. Under the 'Number' tab, choose the format you want (e.g., text, number, currency).

How to create and print Avery Labels straight from home | Business Tip |
How to create and print Avery Labels straight from home | Business Tip |

Adding Avery Label Merge Fields

To ensure your data prints correctly on your Avery labels, you'll need to add merge fields. Here's how:

1. In your Google Sheets document, click 'Insert' in the menu, then 'Merge fields'.

Avery Template 5164 Shipping Labels 3-1/3
Avery Template 5164 Shipping Labels 3-1/3

2. Choose the Avery label merge field that corresponds to the data you want to print (e.g., 'Name', 'Address', 'Phone').

Printing Your Avery Labels

DIY Planner Tutorial: How to make your own planner stickers without a Silhouette machine
DIY Planner Tutorial: How to make your own planner stickers without a Silhouette machine
Editable Avery Label 5610 and 5613 Power Point Template Bundle
Editable Avery Label 5610 and 5613 Power Point Template Bundle
Avery Label Templates - Blue Layouts
Avery Label Templates - Blue Layouts
Design and Print Your Own Labels - DIY - Make Your Own Avery Labels/Stickers
Design and Print Your Own Labels - DIY - Make Your Own Avery Labels/Stickers
Free Avery Label Templates - Free Word Templates
Free Avery Label Templates - Free Word Templates
How to Print Avery Labels in Microsoft Word on PC or Mac
How to Print Avery Labels in Microsoft Word on PC or Mac
How to Download Free Avery Label Templates
How to Download Free Avery Label Templates
Free Avery Label Templates - Free Word Templates
Free Avery Label Templates - Free Word Templates
Microsoft Word Label Templates Avery 5160
Microsoft Word Label Templates Avery 5160
Custom Barcode Labels for Inventory & Products - Avery 5160 - 90 Labels (3 Sheets) - SKU, Retail - Done For You from Google Sheets
Custom Barcode Labels for Inventory & Products - Avery 5160 - 90 Labels (3 Sheets) - SKU, Retail - Done For You from Google Sheets
Free PDF Label Templates for Graphic Designing
Free PDF Label Templates for Graphic Designing
How to Print and Design with Avery Labels
How to Print and Design with Avery Labels
Avery Label Template
Avery Label Template
30 Avery 8593 Label Template – Simple Template Design
30 Avery 8593 Label Template – Simple Template Design
Avery Template 60505 UltraDuty GHS Labels 2
Avery Template 60505 UltraDuty GHS Labels 2
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
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
Avery Template 5162 Address Labels 1-1/3
Avery Template 5162 Address Labels 1-1/3
Online Address Book Tutorial | Capturing Joy with Kristen Duke
Online Address Book Tutorial | Capturing Joy with Kristen Duke

Now that your Google Sheets document is set up, it's time to print your Avery labels. Here's how:

1. Select the range of cells you want to print. Right-click and select 'Print'.

2. In the print preview, click 'More settings' at the bottom. Under 'Layout', select 'Fit to page'.

Choosing Your Avery Label Size

Before printing, make sure you've selected the correct Avery label size. Here's how:

1. In the print preview, click 'Change' next to 'Label size'.

2. Select your Avery label size from the dropdown menu. If your size isn't listed, you can manually enter the dimensions.

Printing Your Avery Labels

Once you've selected your Avery label size, you're ready to print. Here's how:

1. Click 'Print' in the print preview. Your Avery labels will print according to the size and layout you've chosen.

2. Once printed, you can peel and stick your Avery labels as needed.

And there you have it! With these steps, you're well on your way to printing professional-looking Avery labels from Google Sheets. Happy printing!