Creating address labels is a difficult task, but only if you are using the wrong tools. Most of us use Google Docs to write, edit, and collaborate online, but did you know that you can also use it to design and make address labels? Google Docs can be used to create templates of all kinds that can then be modified and reused as the situation requires.
In fact, you will find that creating address labels in Google Docs is much easier than doing it offline, where you may need the help of other office staff. This will become a one man / woman job with the help of Google Docs and a cool plugin.
Organize contacts in spreadsheet
Where are all your contacts? You need to create a new spreadsheet and enter contacts in a column. Whether you are using Google / Gmail or Outlook Contacts, there is always a way to export contacts to a CSV file. This will take the hard work out of the job. Most CRM applications also come with this feature. Then you can add or remove contacts from the spreadsheet as needed.
Make sure the spreadsheet is in the correct order. That means each contact’s name is in a separate row with other details like the address and numbers in the cells below. Scan the entries to rule out errors and correct them when necessary.
Google Docs Tag Plugin
You can open / create a new Google Docs document by typing docs.new in the address bar of the browser. Click Get Add-ons on the Add-ons tab to open a new pop-up window.
Use the search bar to find and install the Avery Label Merge plug-in.
This plugin needs access to your Google Drive to get the data from the spreadsheet. Click on Let when asked for permission to make sure everything runs smoothly.
Click on the Plugins tab again and select Start from the Avery Plugins menu to begin the process. A pop-up window will appear on the right sidebar.
Click the Select Spreadsheet button at the top to choose the Google Sheets spreadsheet where you have exported the contacts to make address labels. Other options include choosing names directly below the drop-down menu. Click the Add button to add new rows. Avery understands that the process can be difficult to understand, so they have written a guide that you will notice appears in the open Google Docs document.
Please note that there are some restrictions on the free or trial version. That information is available in the lower right corner of the screen. Currently, you are limited to 20 combinations with a maximum of 50 labels per combination. Good enough to test the plugin and see if it works properly or as intended. The pro version will cost you $ 30 per year or $ 80 for a lifetime license.
Click the Filter Rows button to add a new column to the bottom of the worksheet. Now just type x in any cell in a row to filter the entire row / contact completely. Useful for skipping tag contacts that you don’t otherwise want to delete manually.
This is what it will look like on the spreadsheet in action.
This is how it will look in Google Docs, where you are managing the spreadsheet contacts.
Based on the information you have provided, the tag box will appear within the Google Docs document at the end. You must have noticed it in the screenshots above as well. The values will change based on the options you have chosen on the Avery Add-on Label Printer.
You can change the font format here, in the box as seen in the screenshot above, and it will be reflected in the tag you make in Google Docs. You also can merge images, QR and barcodes if you like. Click the Merge button to start the process.
The original spreadsheet will update to show the date and time of the last join. The plugin in Google Docs will display two links to download newly created address labels in Docs and PDF format that you can download and save to your desktop.
It was vague and therefore wrote alphabets instead of proper names, but this is what address labels would look like if you had entered names and images correctly as well.
Things will depend on how you format the label with text, images, etc.
Conclusion: create address labels in Google Docs
Creating address labels is easy but not free with the Avery Label Merge plugin. The free version is very limited and is not suitable for corporations and even medium-sized businesses. I suggest you try the trial version to see if the features suit your needs, and if it does, go ahead.