How to Create Avery Labels from Google Sheets

To create Avery labels from Google Sheets, prepare one clean row per label, open a label maker that supports Google Sheets, choose the matching Avery-compatible layout, drag spreadsheet fields onto a WYSIWYG label canvas, preview the full label sheet, export a PDF, and print at 100% / Actual Size.

This guide is for Avery-style label sheets that need more than a fixed address block: product labels, classroom labels, inventory labels, QR labels, barcode labels, branded mailing labels, and other layouts where you want to place fields visually.

If you specifically need plain mailing labels, use How to Print Address Labels from Excel or Google Sheets. If you already know you are printing the 30-up Avery 5160 address layout, read Avery 5160 Address Labels from Excel or Google Sheets.

Short Version

1. Open your Google Sheet.
2. Make sure Row 1 contains clear headers.
3. Start from Google Sheets to Labels or Address Label Maker.
4. Choose the Avery-compatible label template.
5. Drag fields such as name, address, SKU, price, or barcode onto the label.
6. Preview the full sheet.
7. Export the PDF.
8. Print with scaling set to 100% / Actual Size.

Prepare the Google Sheet

The best Avery label workflow starts with simple spreadsheet data. Use one row for each label and keep the first row as field names.

For address labels, a practical sheet looks like this:

For product or inventory labels, use columns like:

Before importing, check for:

• blank rows between real records
• merged cells
• inconsistent header names
• ZIP codes that lost leading zeros
• very long text that may not fit on small labels

Choose the Right Avery-Compatible Template

Avery product numbers describe a physical sheet layout. The most common mailing-label layout in the United States is Avery 5160, but it is not the right choice for every package.

Choose the template that matches your physical label stock:

• Avery 5160-style labels for common 30-up address sheets
• larger address labels for longer mailing addresses
• return address labels for sender labels
• product label sheets for jars, bags, boxes, and packaging
• custom layouts when the package does not match a standard preset

If you are not sure which layout you need, start with the Avery Label Sizes and Template Compatibility Guide.

Design the Label Visually

After importing the sheet, design the label on a visual canvas instead of writing merge syntax by hand. This is the main difference between a spreadsheet-powered label editor and an old mail merge workflow.

In SheetsToLabels, you can:

• drag text, image, barcode, and QR elements onto the label
• bind each element to a Google Sheets column
• resize and reposition fields directly on the canvas
• preview real row data while you edit
• switch to full-sheet preview before exporting

That makes the workflow closer to a WYSIWYG label designer than a document merge. You can see where the SKU, address, price, logo, barcode, or QR code will actually print.

Map Google Sheets Columns to Label Elements

Once the layout is visible, connect each spreadsheet column to the correct label element.

Common address mappings:

• full_name to the first line
• company to an optional second line
• address_line_1 and address_line_2 to the address block
• city, state, and zip to the final line

Common product mappings:

• product_name to the main title
• sku to a small text line
• price to the price area
• barcode to the barcode element

The important part is that the design uses spreadsheet fields instead of manually typed values. That way every row can generate a finished label while the layout remains editable with drag-and-drop controls.

Preview the Full Sheet Before Printing

Previewing one label is not enough. Always review the full sheet because layout problems often appear only when many rows are generated.

Look for:

• names wrapping into too many lines
• blank labels from blank sheet rows
• address lines being cut off
• product names colliding with prices or barcodes
• the wrong label layout for the physical paper

If something looks wrong, fix the sheet or mapping first, then export again.

Export and Print the PDF

Once the preview looks right:

1. Export the label sheet as a PDF.
2. Open the PDF in your normal PDF viewer.
3. Print one test page on plain paper.
4. Set print scale to 100% or Actual Size.
5. Hold the test print behind the physical label sheet to check alignment.
6. Print on label stock only after the test lines up.

Avoid Fit to Page, Shrink to Fit, and browser auto-scaling. Those settings are a common reason Avery labels drift away from the stickers.

Common Questions

Can I create Avery labels directly from Google Sheets?

Yes. Use a workflow that can read Google Sheets data, map columns to label fields, and export a print-ready PDF.

Do I need Google Docs or Word mail merge?

Not necessarily. Google Docs and Word mail merge can work, but they are less visual. A dedicated label workflow is usually faster because template selection, drag-and-drop field placement, live preview, full-sheet preview, and PDF export are in one place.

Which Avery template should I choose?

Choose the template that matches the product number on your physical label package. If you use the wrong layout, the PDF may look correct on screen but print out of alignment.

Related Guides

• How to Print Labels from Google Sheets
• Avery 5160 Address Labels from Excel or Google Sheets
• How to Print Address Labels from Excel or Google Sheets
• How to Fix Label Printing Misalignment
• Google Sheets Add-on Guide for Address Label Maker