Mastering Avery Templates in Google Sheets: A Step-by-Step Guide

Evelyn Jul 09, 2026

Google Sheets is a powerful tool for data management, and using pre-designed templates can significantly streamline your workflow. Avery, a well-known brand in office supplies, offers a wide range of templates specifically designed for Google Sheets. In this guide, we'll walk you through the process of using Avery templates in Google Sheets, from finding the right template to customizing it to fit your needs.

a screenshot of a spreadsheet with multiple columns and numbers on the screen
a screenshot of a spreadsheet with multiple columns and numbers on the screen

Avery templates are designed to help you create professional-looking documents, labels, and more, directly within Google Sheets. Whether you're creating address labels, name tags, or reports, Avery has a template to suit your needs. Let's dive in and explore how to use these templates effectively.

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

Finding and Accessing Avery Templates

Before you can start using Avery templates, you need to find the one that fits your requirements. Avery offers a vast collection of templates, so it's essential to know where to look.

How to Use the ArrayFormula Function in Google Sheets
How to Use the ArrayFormula Function in Google Sheets

Avery provides a dedicated website for their Google Sheets templates. You can access this library by visiting the Avery Google Sheets Templates page. Here, you'll find templates categorized by type, making it easy to find what you need.

Browsing and Searching Templates

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

Once you're on the Avery template library page, you can browse templates by category or use the search bar to find specific templates. Categories include Address Labels, Name Tags, Reports, and many more. Clicking on a category will display all the available templates in that category.

If you know the name or a specific feature of the template you're looking for, you can use the search bar to filter templates. This can save you time when dealing with the vast collection of templates available.

Downloading and Importing Templates

How to use an Excel spreadsheet in Google Sheets (access from any device, anytime) or Numbers for Ma
How to use an Excel spreadsheet in Google Sheets (access from any device, anytime) or Numbers for Ma

Once you've found the perfect template for your needs, it's time to download and import it into your Google Sheets. Avery templates are designed to be easily imported into Google Sheets, making the process seamless.

To download a template, click on the 'Download' button on the template's page. This will download an XML file to your device. Next, open Google Sheets and click on 'File' in the menu, then select 'Import' and choose 'Upload' from the options. Select the downloaded XML file and click 'Open' to import the template into your Google Sheets.

Customizing Avery Templates

Google Sheets Checklists
Google Sheets Checklists

After importing an Avery template into your Google Sheets, you'll likely want to customize it to fit your specific needs. Avery templates are designed to be easily customizable, allowing you to change text, colors, and more.

To start customizing your template, click on the 'Customize' button in the top-right corner of your Google Sheets window. This will open the Avery Design & Print Software, which allows you to make changes to your template.

Free Spreadsheet Templates for Excel & Google Sheets
Free Spreadsheet Templates for Excel & Google Sheets
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
the google spreadsheet has been updated to help students learn how to use them
the google spreadsheet has been updated to help students learn how to use them
How to Auto Sort in Google Sheets
How to Auto Sort in Google Sheets
How to use Google Sheets: A beginner's guide | Zapier
How to use Google Sheets: A beginner's guide | Zapier
How to Calculate Average in Google Sheets
How to Calculate Average in Google Sheets
Habit Tracker Template - Track Your Habits with Google Sheets - FREE Template
Habit Tracker Template - Track Your Habits with Google Sheets - FREE Template
How to Make an Assignment Tracker Template in Google Sheets Using AI
How to Make an Assignment Tracker Template in Google Sheets Using AI
Google Docs Free Checklist Template
Google Docs Free Checklist Template
How to Insert Special Characters in Google Sheets
How to Insert Special Characters in Google Sheets
How to use Google Sheets to Organise your Blog
How to use Google Sheets to Organise your Blog
Struggling to add Alternating Colors in Google Sheets
Struggling to add Alternating Colors in Google Sheets
Just in case spreadsheet - free template
Just in case spreadsheet - free template
How to Make Self-Checking Math Activities in Google Sheets
How to Make Self-Checking Math Activities in Google Sheets
How to Embed Google Sheets Within Your Documents?
How to Embed Google Sheets Within Your Documents?
5 Ways I Use Google Sheets to Organize My Biz — Julienne DesJardins
5 Ways I Use Google Sheets to Organize My Biz — Julienne DesJardins
How to Use the SORTN Function in Google Sheets
How to Use the SORTN Function in Google Sheets
How To Use Google Sheets | Part 4
How To Use Google Sheets | Part 4
Google Sheets Checkbox Strikethrough
Google Sheets Checkbox Strikethrough

Changing Text and Fonts

One of the first things you'll likely want to do is change the text in your template. To do this, simply click on the text you want to change, and a text box will appear, allowing you to type in your new text. You can also change the font, size, and color of the text using the formatting tools in the Avery Design & Print Software.

To change the font, size, or color of text, select the text you want to change, then click on the 'Text' tab in the Avery Design & Print Software. Here, you'll find options to change the font, size, and color of your text. You can also use the formatting tools to bold, italicize, or underline your text.

Adding Images and Shapes

In addition to changing text, you can also add images and shapes to your Avery templates. To add an image, click on the 'Images' tab in the Avery Design & Print Software, then select the image you want to add. You can also add shapes to your template by clicking on the 'Shapes' tab and selecting the shape you want to add.

Once you've added an image or shape, you can resize it, change its color, and position it anywhere on your template. You can also add text to your shapes, making them perfect for creating labels or name tags.

Printing and Exporting Avery Templates

Once you've customized your Avery template to your liking, it's time to print or export it. Avery templates are designed to be printed directly from Google Sheets, making the process simple and efficient.

To print your template, click on the 'File' menu in Google Sheets, then select 'Print'. This will open the print dialog box, where you can choose your printer settings. Once you've set your printer settings, click 'Print' to print your template.

Exporting as PDF or Image

In addition to printing your template, you can also export it as a PDF or image file. This can be useful if you want to share your template with others or use it in another application.

To export your template as a PDF, click on the 'File' menu in Google Sheets, then select 'Download' and choose 'PDF document'. This will download a PDF version of your template to your device. To export your template as an image, click on the 'File' menu, then select 'Download' and choose the image format you want (JPEG, PNG, etc.).

Using Avery templates in Google Sheets can save you time and help you create professional-looking documents, labels, and more. With a wide range of templates to choose from and easy customization options, Avery templates are a powerful tool for anyone using Google Sheets. So why not give them a try and see how they can streamline your workflow?