kutorlabs
Tutorials••4 min read

Fix Margin Drift: Print Avery 5160 Labels From Google Sheets

Printing Avery 5160 stickers directly from Google Sheets cells drifts out of alignment by row 5. Use a print-calibrated dialog instead of Word mail merge.

By Kutor Labs Workspace Engineering

Everyone who tries to print sticker sheets straight out of Google Sheets™ hits the exact same wall.

Rows 1 and 2 look centered. Row 3 starts creeping toward the top edge of the sticker. By Row 6, your SKU title is sliced across the die-cut perforation, and Row 10 prints half a barcode onto the backing paper.

So teams fall back to exporting a .csv, opening Microsoft Word or Google Docs, configuring a brittle Mail Merge plugin, re-mapping columns, and hoping nobody updates a price or SKU in the master spreadsheet ten minutes later.

The root issue is not your printer. It is trying to force a spreadsheet grid to behave like print layout CSS.


Why Native Google Sheets™ Printing Causes Cumulative Drift

Google Sheets™ calculates row heights in screen pixels (21px default) with dynamic text wrapping and cell borders, then hands that virtual table to Chrome's print compositor. Even a 0.4mm rounding discrepancy per row multiplies by 10 rows into a 4mm vertical error by the bottom of an Avery 5160 (30-up, 3 columns × 10 rows) sheet.

Worse, if one cell wraps onto two lines while the row next to it stays on one line, every row beneath it shifts down unpredictably.


How a Print-Calibrated Modal Dialog Eliminates Word Mail Merge

Instead of exporting CSVs out of your spreadsheet or stretching sheet row heights by trial and error, QR Code & Label Generator for Google Sheets™ compiles your selected rows into a dedicated Print Preview Modal inside Google Sheets™:

  • Dedicated 3-Column Print Grid: Renders a clean 3-column CSS Grid (grid-template-columns: repeat(3, 1fr)) with page-break-inside: avoid on every label card so labels never split across page breaks.
  • Client-Side Canvas Codes (QRCode & JsBarcode): Every label embeds a locally generated PNG Data URL (image/png) directly from HTML5 Canvas—meaning your barcodes and QR codes print sharply without waiting on external image servers.
  • Paired Metadata Layout: Automatically pairs your primary product title (Column A) with the SKU/URL subtitle and scannable code side-by-side (label-title truncation prevents multi-line row bloat).
  • Zero Print Chrome (@media print): Toolbar buttons (Print Labels, Close) sit inside a .no-print container that disappears automatically when window.print() runs.

Step-by-Step: Print Clean Label Sheets Directly From Google Sheets™

  1. Install & Open the Add-on: Install QR Code & Label Generator for Google Sheets™ and open: Extensions → QR Code & Label Generator for Google Sheets™ → Open Generator (See the Quick Start Guide for initial setup.)
  2. Select Your Product & SKU Rows: Highlight your data range in Google Sheets™ (or click + Sample Data to test with 5 built-in SKU rows). Verify First row is header (skip Row 1) and your source column.
  3. Choose QR Code or Barcode 128: Pick the format your scanner or workflow needs and verify the live preview in the sidebar.
  4. Click "Print Avery Label Sheet":
    • The print preview modal opens with your 3-column label cards rendered and ready.
    • Click Print Labels (window.print()).
    • Critical Printer Settings: Set Scale to 100% (never "Fit to printable area"), uncheck Headers and footers, and select your matching paper size before printing on sticker stock.

Always-Live Single Source of Truth

Because the print dialog reads directly from your active spreadsheet selection via spreadsheets.currentonly permissions, there are no stale CSV exports lying around on your desktop—and zero confidential product lists uploaded to third-party label websites.

Up to 50 labels per batch are free with zero watermarks; Pro ($19/year or $34.99 one-time Lifetime) unlocks unlimited bulk batches for high-volume fulfillment runs.

Need linear SKU barcodes for handheld warehouse scanners? Read our guide on generating bulk Code 128 inventory barcodes in Google Sheets, or check our complete QR and Avery overview.

Install QR Code & Label Generator from Google Workspace™ Marketplace →

Filed under:#Google Sheets#Avery 5160#Label Printing#QR Codes#Inventory Labels#Workspace Add-ons

Frequently Asked Questions

Why do Avery 5160 labels drift out of alignment when printed directly from Google Sheets?

Google Sheets renders cells for screen accounting rather than fixed physical paper geometry. Small differences in cell padding, line wrapping, and browser Fit-to-Page scaling compound down the page, pushing rows 5 through 10 across sticker borders.

Do I have to export a CSV to Microsoft Word Mail Merge to print barcode labels?

No. QR Code & Label Generator includes a built-in print modal dialog that renders your selected spreadsheet titles, SKUs, and client-side Canvas QR or Code 128 images into a clean 3-column CSS Grid ready for browser printing.

Are the printed QR codes and barcodes generated locally?

Yes. Before opening the print dialog, the sidebar renders every QR code and Code 128 barcode directly onto an HTML5 Canvas in your browser memory, so print output stays crisp even for private internal SKUs.

What browser print settings should I use so the sticker grid stays aligned?

Set Scale to 100% (Default/Actual Size—never Fit to Page), disable browser Headers and Footers, and match your printer paper size (Letter or A4) to your physical label stock.

Series • Part 6 of 6
Workspace

Google Workspace Add-ons & Automation

Client-side canvas engines for Google Slides timers, 4K vector icons, and bulk Google Sheets barcodes & Avery labels.