Avery QR Code Product & Packaging Label Template (Avery 22806 / 22807 Square & Round)

1. Operational Challenge & Business Context

The Problem This Solves:Creating custom QR code labels individually via online generator tools is slow and repetitive. This template creates full sheets of scannable QR stickers dynamically from a list of URLs.

Avery 22806 ($2 imes 2 ext{ inch}$ square) and Avery 22807 ($2 ext{ inch}$ round, 12 per sheet) are the premier label formats for artisanal retail products, jar lids, candle boxes, and promotional inserts. Generating QR codes via formula allows you to produce batch labels instantly.

2. Free Template Download & Cloud Access

Grab the ready-to-use spreadsheet below in either Microsoft Excel or Google Sheets format:

Verified Free Download (v2.1)

File Size: 46 KB • License: Free for Commercial & Personal Use

Avery QR Code Product & Packaging Sticker Generator

Download the fully customizable template pre-configured with formulas, validation rules, and summary dashboards. Compatible with all modern versions of Excel and Google Sheets.

12-Up Square & Round Sticker Grid (2 x 2 in on Letter 8.5 x 11 in)

Dynamic Formula-Driven QR Code Image Generator (=IMAGE formula)

Call-to-Action Text Slot ('SCAN TO REORDER', 'SCAN FOR MENU')

Product Name, Batch Number & Expiration Date Fields

Compatible with Avery 22806 (Square), 22807 (Round), 22816, and OL2679

Download for Excel (.xlsx)Open in Google Sheets (Make a Copy)

3. Step-by-Step Setup & Customization Guide

Enter Target URLs or Product Link

Input your website URL, digital menu link, or Google review page in the URL column.

Pro Tip: Use URL shorteners (like Bitly) to keep QR code patterns simple and fast to scan.

Customize Product Title & Call-to-Action

Add text such as 'Scan for Instructions' or 'Scan to Leave a Review'.

Pro Tip: Test scan the printed sheet with your smartphone camera before applying to products.

4. Formula & Automation Architecture

In Google Sheets, the native =IMAGE(...) function fetches vector-grade QR codes directly into cells without requiring any graphic design software.

Core Formulas Used in This Sheet:

=IMAGE("https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=" & ENCODEURL(TargetURL))

Generates live, high-resolution scannable QR code image directly inside spreadsheet cells.

5. Frequently Asked Questions & Troubleshooting

Will these QR codes ever expire?

Static QR codes that link directly to your website URL never expire as long as your website page remains live.