Avery® Label maker
How to print Avery® labels from Google Sheets
Create unlimited Avery labels for free. Use data from Google Sheets™️ to merge into a selected template in Google Docs™️.
Step 1
Step 1
Open your Google Sheets document that contains the data you want to merge. Press "Extensions" > "Avery Label Maker" > "Create Labels"
Open your Google Sheets document that contains the data you want to merge. Press "Extensions" > "Avery Label Maker" > "Create Labels"
Step 2
Step 2
Use the search bar to find the label template of your choice.
Use the search bar to find the label template of your choice.
Step 3
Step 3
Select the Sheet from which you want to pull data. Select a column and place it in the editor box. Add additional fields and style the text as you wish.
Select the Sheet from which you want to pull data. Select a column and place it in the editor box. Add additional fields and style the text as you wish.
Step 4
Step 4
After the data fields are added, press "Create labels". The more data in the sheet, the longer it will take to prepare your document. If the loading bar times out, you may have to split the data into multiple sheets and run each the split data sheets separately.
After the data fields are added, press "Create labels". The more data in the sheet, the longer it will take to prepare your document. If the loading bar times out, you may have to split the data into multiple sheets and run each the split data sheets separately.
Step 5
Step 5
Press "Open Document" and view your sheet in Google Docs. Click "File" > "Print". Set Margin to "None" and scale to 100%. Print the labels with your desired printer.
Press "Open Document" and view your sheet in Google Docs. Click "File" > "Print". Set Margin to "None" and scale to 100%. Print the labels with your desired printer.