How to Print Avery Labels from Google Sheets for Free

Evelyn Jul 09, 2026

Ever found yourself in a situation where you need to print Avery labels directly from your Google Sheets data? You're not alone. Avery labels are a staple in offices worldwide, and printing them directly from your Google Sheets can save you time and effort. The best part? You can do this for free. Let's dive into a step-by-step guide on how to achieve this.

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

Before we start, ensure you have Google Sheets and Avery labels compatible with your printer. For this guide, we'll use Avery 5160 address labels as an example, but the process is similar for other Avery label types.

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 Data

First, make sure your data is in a tabular format, with each label's information in a separate row. For address labels, this could include columns for name, address, city, state, and zip code.

Free Blank Label Templates Online
Free Blank Label Templates Online

To ensure your labels print correctly, set your print area. Select the range of cells containing your data, then click on 'File' > 'Print' > 'Set print area'. This ensures only the relevant data is printed.

Setting Up Your Printer for Avery Labels

Avery Template 5163 Shipping Labels 2
Avery Template 5163 Shipping Labels 2

Printer settings are crucial for printing labels correctly. Here's how to set them up:

Windows Users

1. Open your printer's properties by right-clicking on its icon in your system tray and selecting 'Printer properties'.

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

2. Go to the 'Paper/Quality' tab and select 'Custom size' or 'User-defined size'.

Mac Users

1. Open your printer's preferences by clicking on the Apple menu > System Preferences > Printers & Scanners.

a blank label that is in the shape of a rectangle with two lines on each side
a blank label that is in the shape of a rectangle with two lines on each side

2. Click on the 'Options & Supply Levels' button next to your printer. Then, click on the 'Paper Size' dropdown and select 'Manage Custom Sizes'.

Printing Avery Labels from Google Sheets

Microsoft Word Label Templates Avery 5160
Microsoft Word Label Templates Avery 5160
Design Templates for Christmas Cards | Free & Customizable
Design Templates for Christmas Cards | Free & Customizable
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!)
Free Avery Label Templates - Free Word Templates
Free Avery Label Templates - Free Word Templates
How to create and print Avery Labels straight from home | Business Tip |
How to create and print Avery Labels straight from home | Business Tip |
30 Avery 8593 Label Template – Simple Template Design
30 Avery 8593 Label Template – Simple Template Design
Free Avery Label Templates - Free Word Templates
Free Avery Label Templates - Free Word Templates
How to Download Free Avery Label Templates
How to Download Free Avery Label Templates
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
Avery Template 5162 Address Labels 1-1/3
Avery Template 5162 Address Labels 1-1/3
Avery Template 60505 UltraDuty GHS Labels 2
Avery Template 60505 UltraDuty GHS Labels 2
Address Label Template | Free Word Templates
Address Label Template | Free Word Templates
how to make your own sticker labels 4 Free Printable Floral Labels
how to make your own sticker labels 4 Free Printable Floral Labels
Chevron, Polka dot, & Stripes Editable LARGE Avery Labels (15264) 6 Per Page
Chevron, Polka dot, & Stripes Editable LARGE Avery Labels (15264) 6 Per Page
Word Template for WL-25
Word Template for WL-25
Editable Avery Label 5610 and 5613 Power Point Template Bundle
Editable Avery Label 5610 and 5613 Power Point Template Bundle
How To Create Blank Avery 5160 Free Template
How To Create Blank Avery 5160 Free Template
Avery Labels | DIY Planner Stickers
Avery Labels | DIY Planner Stickers

Now that your data and printer are ready, it's time to print your Avery labels:

Windows Users

1. In Google Sheets, click on 'File' > 'Print'.

2. In the 'Layout' section, select 'Custom size' from the 'Paper size' dropdown. Enter '3.125' for width and '1.5' for height (inches).

Mac Users

1. In Google Sheets, click on 'File' > 'Print'.

2. In the 'Paper size' dropdown, select 'Manage Custom Sizes'. Enter '3.125' for width and '1.5' for height (inches).

Once you've set your custom paper size, click 'Print'. Your Avery labels should now print correctly from your Google Sheets data.

Printing Avery labels directly from Google Sheets can streamline your labeling process, saving you time and effort. With a little setup, you can have your labels ready in no time. Happy printing!