Print Google Sheets Address Labels

Evelyn Jul 09, 2026

Ever found yourself manually typing addresses onto labels, only to realize you've made a mistake? Or perhaps you've spent countless hours formatting addresses in a word processor, wishing there was a faster way? Well, the good news is, there's a more efficient method using Google Sheets and its integration with label printing software.

How to Print Labels from Google Sheets
How to Print Labels from Google Sheets

Google Sheets, a powerful spreadsheet tool, allows you to create, organize, and analyze data. But did you know it can also help you print address labels? By following this guide, you'll learn how to create and print address labels directly from Google Sheets, saving you time and reducing errors.

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

Preparing Your Data in Google Sheets

Before you start, ensure your addresses are in a Google Sheets document. Each address should be in a separate row, with columns for the recipient's name, street, city, state, zip code, and country (if necessary).

Address Label Template | Free Word Templates
Address Label Template | Free Word Templates

For example, your sheet might look like this:

Name Street City State Zip Code Country
John Doe 123 Main St Anytown CA 12345 USA
Jane Smith 456 Oak Ave Othertown NY 67890 USA
How to Make an Address Book with Google Sheets
How to Make an Address Book with Google Sheets

Formatting Your Addresses

To ensure your addresses print correctly, use the "Text to Columns" feature to separate each address into its respective fields. This will make it easier to merge the data into a label template later on.

Here's how to do it:

How to Print Labels From Google Sheets
How to Print Labels From Google Sheets
  1. Select the range containing your addresses.
  2. Click on "Data" in the menu, then "Split text to columns".
  3. Choose the column separator (usually a comma or a tab), then click "Split".

Creating a Label Template

Now that your addresses are formatted correctly, you need to create a label template. You can use software like Avery Design & Print or Label Planet to create a template that fits your label size and style.

White Address Labels A4 Template
White Address Labels A4 Template

Once you've designed your template, save it as a PDF. You'll use this PDF to merge your Google Sheets data into the label fields.

Printing Address Labels from Google Sheets

Excel help & learning
Excel help & learning
Make Your Own Christmas Address Labels...Picture Tutorial
Make Your Own Christmas Address Labels...Picture Tutorial
sticker template a4 | Address Label Templates | Personalized Address Labels | Avery
sticker template a4 | Address Label Templates | Personalized Address Labels | Avery
Printing envelopes from Google Docs
Printing envelopes from Google Docs
How to mail merge from Excel to Word step-by-step
How to mail merge from Excel to Word step-by-step
How to Make Personalized Address Labels using Cricut
How to Make Personalized Address Labels using Cricut
How to Make Address Address Labels with Mail Merge using Excel and Word
How to Make Address Address Labels with Mail Merge using Excel and Word
autofillPDF-Labels 1.0 - print labels in seconds
autofillPDF-Labels 1.0 - print labels in seconds
Need Quick Labels? Use Google Sheets!
Need Quick Labels? Use Google Sheets!
How to mail merge and print labels from Excel to Word
How to mail merge and print labels from Excel to Word
For easy card list management and address label printing
For easy card list management and address label printing
Contact List, Google Sheets, Address Book, Address Sheet, Contact Organizer, Emergency List, Client Tracker, Contact Information Digital Log
Contact List, Google Sheets, Address Book, Address Sheet, Contact Organizer, Emergency List, Client Tracker, Contact Information Digital Log
How to Create Mailing Labels in Google Docs
How to Create Mailing Labels in Google Docs
How to Make Address Address Labels with Mail Merge using Excel and Word
How to Make Address Address Labels with Mail Merge using Excel and Word
Use Excel's Power to Print Labels in No Time
Use Excel's Power to Print Labels in No Time
Avery Template 5160 Address Labels 1
Avery Template 5160 Address Labels 1
How to Create Printable Address Labels with Images in Microsoft Word
How to Create Printable Address Labels with Images in Microsoft Word
Online Address Book Tutorial | Capturing Joy with Kristen Duke
Online Address Book Tutorial | Capturing Joy with Kristen Duke
Contact list template for Google Sheets with built in search
Contact list template for Google Sheets with built in search
Life Hacks: How I Stay Productive With Gmail Labels
Life Hacks: How I Stay Productive With Gmail Labels

Now that you've prepared your data and created a label template, it's time to merge the two and print your labels.

For this, you'll need a third-party add-on like "Merge Sheets with PDF" or "PDF Merge for Google Sheets". These add-ons allow you to merge your spreadsheet data with your PDF label template.

Using Merge Sheets with PDF

Here's how to use the "Merge Sheets with PDF" add-on:

  1. Install the add-on from the Google Workspace Marketplace.
  2. Open your Google Sheets document and click on "Add-ons" in the menu, then "Merge Sheets with PDF".
  3. Select the range containing your addresses, then choose your PDF template.
  4. Click "Merge and Print".

Using PDF Merge for Google Sheets

The process is similar with "PDF Merge for Google Sheets". After installing the add-on:

  1. Open your Google Sheets document and click on "Add-ons" in the menu, then "PDF Merge for Google Sheets".
  2. Select the range containing your addresses, then choose your PDF template.
  3. Click "Merge and Print".

Once the merge is complete, your labels will be ready to print. Simply follow your printer's instructions to print your labels on sticker paper or label sheets.

And there you have it! By following this guide, you've learned how to create and print address labels directly from Google Sheets. This method saves time, reduces errors, and streamlines your labeling process. So, the next time you need to print address labels, give this method a try. Happy labeling!