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.

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.

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.

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

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

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

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.




















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.