Google Sheets is an excellent free spreadsheet software that offers a wide range of capabilities. However, printing labels directly from Google Sheets is not a built-in feature. But don’t worry! We’ve got you covered. In this guide, we will show you how to print labels from Google Sheets using the free “Create & Print Labels” add-on from Labelmaker.
Prepare Your Document
Before we dive into the process, you’ll need to have a Google Sheet set up with the labels or data information you want to print. Make sure to include headers such as “Full Name,” “Address,” “City State,” “Zip Code,” and so on in the first row of the sheet.
Get Google Sheets’ Create & Print Labels Add-on Installed
To generate labels from Google Sheets and Google Docs, you’ll need to install the “Create & Print Labels” add-on. Here’s how:
- Open a blank Google Docs file.
- Navigate to Extensions > Add-ons. You’ll see a list of available add-ons.
- Use the search bar to find the “Create & Print Labels” add-on. Type the add-on’s name and press Enter.
- Select Labelmaker Create and Print Labels. It will be the first item on the list. This will prompt a pop-up asking you to install it. Click Install.
- A pop-up will appear, asking for permission to start installing. Click Continue to confirm.
- Sign in to your email address. Enter your email and password, then click Next.
After signing in successfully, a pop-up window will appear asking for permission to access your Google Account. Click Allow.
A pop-up notification will confirm that the add-on has been installed successfully. Click Done at the bottom.
How to Create an Address List
Now that you have installed the necessary add-on, let’s focus on creating an address list. Follow these steps:
Go to https://sheets.google.com/ and log in using the Google account where you installed the Create & Print Labels add-on, if you haven’t logged in yet.
Select Blank to create a new blank Google sheet.
- Divide the components of the address into separate columns and provide appropriate column headings. The main components of an address are Name, City, Street, and State. Make sure to follow these steps precisely for the Create & Print Labels add-on to work correctly.
- Input all the address information properly after creating the column headers. Also, give your spreadsheet a meaningful name. This is crucial for producing accurate address labels using the Create & Print Labels add-on.
You can choose to show or hide the gridlines in Google Sheets before proceeding with the label-making process.
Now, let’s learn how to print address labels from Google Sheets using the add-on:
- Once you’ve created an address list, it’s time to combine the labels with Google Docs. Open a browser and navigate to https://docs.google.com.
- After starting a new document, click Add-ons/Extensions. Choose Create & Print Labels, and then click Create Labels.
- In the resulting right pane, click “Select a Spreadsheet” to connect the spreadsheet from which you want to extract data.
- By doing this, you will be able to access the information from your Google spreadsheet. A dialog window will show all the sheets in your document. Choose the address list you created earlier.
- Label the data by adding each column heading from the address list to the box in the center of the document. Click the name of each column heading in the spreadsheet to add them one by one. Make sure each column header title is located on its own row to avoid printing the address as a single line.
- Finally, click Merge. The Google Doc is now ready for printing, as the address list from the spreadsheet has been combined into it. A pop-up confirmation will appear once the integration is complete.
How to Print Labels From Google Sheets
To print the labels, follow these steps:
- Click the Print button, located in the top-left menu bar of Google Docs.
- Choose your printer. If you can’t see it, click See more to find it. Once you’ve selected the printer, click Print/Save at the bottom of the page. That’s it!
You can also set the print area in Google Sheets using this menu.
If something goes wrong, it’s usually due to incorrect label headers. Make sure you have entered them correctly while building your address list. If you encounter any alignment issues, there is a link to an article in the generated labels document that covers how to fix them.
Frequently Asked Questions
Can You Use Google Sheets With Avery Labels?
Yes, there are several add-ons available that support Avery labels. Simply go to Extensions > Add-ons and search for “Avery labels.” Choose an add-on, install it, and follow the instructions provided.
Does Google Have a Template for Address Labels?
No, Google Sheets does not have a default label template. However, you can download an add-on that provides similar functionality.
How Do I Make Labels for Free in Google Sheets?
Most label maker add-ons for Google Sheets offer a free version or trial period. If you need to create bulk address labels over an extended period, you may need to purchase a paid version. Alternatively, you can sign in with a different Google account to use the trial period again.
How Do I Print Address Labels From a Google Spreadsheet?
The best way to print address labels from a Google Spreadsheet is by using an add-on that imports the data into a Google Docs document. This ensures that the layout is optimized for printing.
Wrapping Up the Print Labels from Google Sheets Guide
While you can create labels manually, using a Google Docs add-on streamlines and simplifies the process. There are several add-ons to choose from, but based on our experience, the “Create and Print Labels” add-on from Labelmaker is the best option. We hope you’ve found this guide on how to print labels from Google Sheets helpful. If you need any further assistance, feel free to let us know in the comments.