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.

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.

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.

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

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'.

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.

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



















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!