How to Print Avery Labels from Google Sheets

Clarence Jul 17, 2026

Streamlining your labeling process? Google Sheets in tandem with Avery labels can significantly boost your efficiency. This duo allows you to create, manage, and print labels en masse, saving you time and reducing human error. Let's delve into how you can smoothly print Avery labels straight from your Google Sheets.

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

Avery provides a wide range of label templates, designed to fit various printers and label sizes. To get started, you'll first need to download and import an Avery template into your Google Sheets. But don't worry, it's a cinch! Let's break down the process step by step.

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

Downloading and Importing Avery Templates

Head over to the official Avery website and find your label template. Once you've found the one you need, click 'Download' and save the '.xlsx' file to your computer.

Microsoft Word Label Templates Avery 5160
Microsoft Word Label Templates Avery 5160

Now, let's import this template into your Google Sheets:

Steps to Import the Avery Template

Avery Label Templates - Blue Layouts
Avery Label Templates - Blue Layouts

1. Open Google Drive and create a new Google Sheets document.
2. Click 'File', then 'Import'.
3. Choose 'Upload' and select the Avery template you've downloaded.
4. Ensure 'Replace spreadsheet' is unchecked, and click 'Import'.

There you have it! Your Avery template is now safely within your Google Sheets document, ready to be populated with your data.

Populating Your Avery Labels

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

Before you start inputting your data, remember that Avery templates have pre-defined merge areas. These are the sections where your data will appear on the final label. They're labeled in the format 'Merge Field 1', 'Merge Field 2', and so forth.

Now, let's fill in those merge fields with your data:

Steps to Populate Your Avery Labels

the avery logo is shown in red, blue and white with an orange triangle on it
the avery logo is shown in red, blue and white with an orange triangle on it

1. Delete any pre-existing data in the merge fields.
2. In the relevant merge field, type or paste your data.
3. Repeat this process for all merge fields.

Remember, Google Sheets auto-expands rows and columns, so you won't be restricted to filling only one label at a time.

Avery Address Label Template 5162 | williamson-ga.us
Avery Address Label Template 5162 | williamson-ga.us
Custom QR Code Labels for Products - 30 QR Labels from Spreadsheet - Printable Avery 5160/8160 - Bulk QR Code Labels
Custom QR Code Labels for Products - 30 QR Labels from Spreadsheet - Printable Avery 5160/8160 - Bulk QR Code Labels
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
Free PDF Label Templates for Graphic Designing
Free PDF Label Templates for Graphic Designing
Avery Label Template
Avery Label Template
Avery Template 60505 UltraDuty GHS Labels 2
Avery Template 60505 UltraDuty GHS Labels 2
30 Avery Label Template 5960 – Simple Template Design
30 Avery Label Template 5960 – Simple Template Design

Printing Your Avery Labels

Congratulations! Your Avery labels are now data-rich and ready for printing. Here's how you can proceed:

Steps to Print Your Avery Labels

1. Ensure your printer has label paper loaded.
2. In your Google Sheets document, highlight all your filled-in merge fields.
3. Click 'File', then 'Print'.
4. In the 'Layout' section, click the arrow next to 'Scale',
and select 'Custom'.
5. Enter your label's dimensions (these can be found in your Avery template's description).
6. Finally, click 'Print'.

Et voilà! Your Google Sheets data is now beautifully adorning your Avery labels, ready to be affixed and utilized.

Once you're comfortable with the process, you can streamline it by creating a master sheet with your Avery template and regularly updating it with fresh data. This will allow you to print new labels in a snap whenever you need to.

printer, label paper, Avery template, and attention to scale settings are key to a successful print job. So, keep these factors in mind, and you'll be whipping up labels like a pro in no time!