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

Evelyn Jul 09, 2026

Printing labels from Google Sheets using Avery 8160 templates is a straightforward process that can save you time and ensure professional-looking results. Whether you're creating address labels, shipping labels, or name tags, this guide will walk you through the steps to achieve perfect Avery 8160 labels from your Google Sheets data.

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

Before we dive into the process, ensure you have the following: an Avery 8160 template (which is compatible with standard letter-sized paper), your data ready in Google Sheets, and a printer capable of handling Avery 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

Preparing Your Google Sheets Data

To begin, open your Google Sheets document and organize your data in columns, ensuring each row represents a single label. For Avery 8160, each label has three rows and two columns, so structure your data accordingly.

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

For example, if you're creating address labels, your columns might be labeled 'First Name', 'Last Name', 'Address', 'City', 'State', 'Zip', and 'Country'. Make sure to adjust column widths to fit your data comfortably.

Formatting Your Data

Free Blank Label Templates Online
Free Blank Label Templates Online

Formatting your data ensures your labels look polished and professional. Use the 'Wrap text' option (Format > Text wrapping > Wrap text) to allow text to wrap within each cell. Also, apply appropriate text wrapping, font size, and styles to make your labels readable and visually appealing.

To apply consistent formatting to your entire data range, select your data, click on 'Format' in the menu, then choose 'Apply formatting' > 'Range'. This will open a side panel where you can adjust text, background, and border styles.

Adding Avery 8160 Merge Fields

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

Merge fields allow you to insert your Google Sheets data into your Avery template. In your Google Sheets document, click on 'Extensions' in the menu, then 'Avery Design & Print'. This will open the Avery Design & Print app, where you can select your Avery 8160 template.

Once your template is selected, click on 'Merge fields' in the toolbar. This will add merge fields to your template, corresponding to the columns in your Google Sheets data. You can drag and drop these merge fields onto your template, positioning them where you want your data to appear.

Printing Your Avery 8160 Labels

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

After preparing your data and template, you're ready to print your labels. In the Avery Design & Print app, click on the 'Print' icon in the toolbar. This will open your printer settings.

Ensure your printer is set to 'Avery 8160' or 'Avery Letter' and that your paper is loaded correctly. Double-check your print settings, including paper size, orientation, and scale, to ensure they match your template. Once everything is set, click 'Print' to start printing your labels.

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 create and print Avery Labels straight from home | Business Tip |
How to create and print Avery Labels straight from home | Business Tip |
Avery Label Templates - Blue Layouts
Avery Label Templates - Blue Layouts
Avery Template 5160 Address Labels 1
Avery Template 5160 Address Labels 1
Avery Template 5160 Address Labels 1
Avery Template 5160 Address Labels 1
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!)
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 Download Free Avery Label Templates
How to Download Free Avery Label Templates
Make Your Google Sheets Look Professional with Alternating Colors 🎨
Make Your Google Sheets Look Professional with Alternating Colors 🎨
Chevron, Polka dot, & Stripes Editable LARGE Avery Labels (15264) 6 Per Page
Chevron, Polka dot, & Stripes Editable LARGE Avery Labels (15264) 6 Per Page
Address Label Template | Free Word Templates
Address Label Template | Free Word Templates
autofillPDF-Labels 1.0 - print labels in seconds
autofillPDF-Labels 1.0 - print labels in seconds
Free Avery Label Templates - Free Word Templates
Free Avery Label Templates - Free Word Templates
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
30 Avery Label Template 5960 – Simple Template Design
30 Avery Label Template 5960 – Simple Template Design
30 Avery 8593 Label Template – Simple Template Design
30 Avery 8593 Label Template – Simple Template Design
Shop Avery Labels
Shop Avery Labels
Avery Template 5162 Address Labels 1-1/3
Avery Template 5162 Address Labels 1-1/3

Checking Your Print Job

Before printing, it's a good idea to do a test print or use the 'Print preview' option to ensure your labels look as expected. This can help you catch any formatting issues or errors in your data before wasting ink or labels.

To perform a test print, select 'Print preview' in the print dialog box, then choose 'Actual size' under the 'Scale' dropdown. This will show you a preview of how your labels will print. If everything looks good, proceed with printing your labels.

With your Avery 8160 labels printed, you're ready to use them for addressing envelopes, creating shipping labels, or organizing your files. By following this process, you can efficiently turn your Google Sheets data into professional-looking labels, saving you time and effort.