Avery-Compatible Barcode & Asset Tag Label Template (Avery 5160 / 5163)

1. Operational Challenge & Business Context

The Problem This Solves:Purchasing proprietary asset tag software and pre-printed metal tags costs thousands of dollars. This template turns standard Avery label sheets into durable, scannable barcode stickers.

Affixing barcode labels to warehouse bins, tools, and computer equipment streamlines physical audits. By pairing standard Avery sheets (5160 or 5163) with free barcode fonts (Libre Barcode 39 or Code 128), you can generate thousands of barcodes on demand.

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.0)

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

Avery Barcode & Asset Tag Label 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.

Dual Grid Layouts (30-Up Avery 5160 for small items, 10-Up Avery 5163 for large tags)

Code 128 & Code 39 Scannable Barcode Encoding (*SKU*)

Asset Tag ID, Equipment Description & Serial Number Fields

Company Property Ownership Notice ('PROPERTY OF ACME CORP')

Tested 100% Compatible with USB and Bluetooth Handheld Scanners

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

3. Step-by-Step Setup & Customization Guide

Enter Asset IDs & SKU Numbers

Input your inventory numbers (e.g. AST-1001, AST-1002) in the Master Asset List tab.

Pro Tip: Keep IDs alphanumeric without special punctuation for maximum scanner compatibility.

Apply Barcode Font

Ensure the barcode formula cell is set to font 'Libre Barcode 39' or 'Code 39' (free from Google Fonts).

Pro Tip: Cover printed stickers with clear packing tape for heavy-duty industrial water resistance.

4. Formula & Automation Architecture

The formula wraps raw asset IDs in required start and stop delimiter characters ("*" & A2 & "*") to enable laser barcode reader decoding.

Core Formulas Used in This Sheet:

="*" & AssetID & "*"

Wraps text in start/stop asterisks required for Code 39 barcode fonts to scan properly.

5. Frequently Asked Questions & Troubleshooting

Where do I get the barcode font for Excel?

Download the free 'Libre Barcode 39' or 'Libre Barcode 128' font from Google Fonts, install it on your computer, and select it from Excel's font menu.