✦Template Printable Ideas Insights

How to Print Address Labels from Google Sheets for Free

By

Are you looking to print address labels from Google Sheets but don't want to pay a dime? You're in the right place. Google Sheets, along with its array of add-ons, offers a free and efficient way to create and print your address labels. Let's dive into how you can achieve this step-by-step.

Before we start, ensure you have Google Sheets installed on your computer. If not, you can get it from the official Google Workspace website. Once installed, let's get started with creating your address labels.

Setting Up Your Google Sheets for Address Labels

First, open a new Google Sheets document. Here, we'll create a simple spreadsheet containing the addresses you want to print on the labels. Make sure to include columns for First Name, Last Name, Street, City, State, and Zip Code.

How to Print Labels from Google Sheets
How to Print Labels from Google Sheets
Free: Create Avery Address Labels in Google Docs
Free: Create Avery Address Labels in Google Docs
How to Make an Address Book with Google Sheets
How to Make an Address Book with Google Sheets

Now, let's discuss the dimensions of the address labels to set up your Google Sheets correctly. The most common address label size is 1" x 2.5" (2.54 cm x 6.35 cm). To set these dimensions in your spreadsheet:

Calculating Label Dimensions

Since we'll be printing multiple labels, we need to ensure they're evenly spaced. The default margin in Google Sheets is 0.25" (0.635 cm), so we'll subtract this from the width of our label. This gives us a label width of 0.75" (1.905 cm) and a height of 2.25" (5.715 cm).

The Ultimate Address Book | Contact List | Label Printer | Google Sheets Template
The Ultimate Address Book | Contact List | Label Printer | Google Sheets Template
Make Your Own Christmas Address Labels...Picture Tutorial
Make Your Own Christmas Address Labels...Picture Tutorial
How to Print Address Labels from Google Sheets
How to Print Address Labels from Google Sheets

To set these dimensions in your Google Sheets, click on "File" > "Page Setup", then under "Margins", select "Custom". Set the left and right margins to 0, the top and bottom to 0.25" (or 0.635 cm), and the header and footer to 0.25" (or 0.635 cm) as well. Then, click "OK".

Formatting Your Data

Now, let's format your data to fit into the address labels. Highlight your data and go to "Format" > "Conditional Formatting". Under 'Format cells if...', select 'Custom formula is', and enter the following formula: `=MOD(ROW(),2)==0`. This will add shading to every other row, making it easier to read once printed.

Next, adjust the width of your columns so that your data fits neatly into the labels. You can do this by hovering over the line between two column headers and dragging it to the desired width.

How to Create Address Labels in Microsoft Word from an Excel File (PC & Mac)
How to Create Address Labels in Microsoft Word from an Excel File (PC & Mac)
White Address Labels A4 Template
White Address Labels A4 Template
Label Templates Free Download Patible with Avery Label Template 5162 – Simple Template Design
Label Templates Free Download Patible with Avery Label Template 5162 – Simple Template Design
Free PDF Label Templates for Graphic Designing
Free PDF Label Templates for Graphic Designing
IHeart Freebies: Address Labels!
IHeart Freebies: Address Labels!
the printable worksheet is shown for each student to use in their class
the printable worksheet is shown for each student to use in their class

Printing Your Address Labels

With your data formatted, it's time to print your address labels. Unfortunately, Google Sheets doesn't have a built-in function for printing labels directly. However, we can use a free add-on called "Label Printer".

To install the add-on, go to "Extensions" > "Add-ons" > "Get add-ons". Search for "Label Printer" and click the '+' icon to install it. After installation, click on "Extensions" > "Label Printer".

Configuring the Label Printer

in the "Printer Settings" section, select "US Letter" under "Paper Size" and "Portrait" under "Orientation". Under "Label Size", select "Avery 5160" from the drop-down menu. This is a standard label size with 30 labels per page.

a red and white business card with the names of two different businesses in each city
a red and white business card with the names of two different businesses in each city
autofillPDF-Labels 1.0 - print labels in seconds
autofillPDF-Labels 1.0 - print labels in seconds

Next, under "Zones", click on "Zone 1". In the pop-up, select the range of cells containing your address data (e.g., A2:I20). Click "OK". The add-on will now map your data onto the address labels.

Printing Your Labels

Finally, click on "Printer" in the Label Printer menu. Select your printer, choose the number of copies you need, and click "OK" to print your address labels. Ensure your printer is loaded with the correct label paper.

And there you have it! A step-by-step guide on how to print address labels from Google Sheets for free. Whether you're sending out invitations, moving letters, or just want to get organized, this method ensures your addresses are neatly printed and ready to go.