Avery 5160 / 8160 Address Label Template: Free Excel & Google Sheets Grid (30-Up)

1. Operational Challenge & Business Context

The Problem This Solves:Printing address labels from word processors often results in misaligned text that crosses sticker boundaries and wastes expensive Avery label sheets. A calibrated spreadsheet grid guarantees accurate alignment.

Avery 5160 (and its laser/inkjet equivalents like 8160, 5260, 5960, and 8460) is the undisputed industry standard for mailing labels in North America. Each $8.5 imes 11 ext{ inch}$ Letter sheet contains 30 labels arranged in 3 columns of 10, with each label measuring $1 imes 2 ext{--}5/8 ext{ inches}$ ($25.4 imes 66.7 ext{ mm}$).

This template solves two primary business needs: you can either type text directly into the pre-dimensioned 30-label grid for quick printing, or maintain a master customer list on Tab 2 and let our formula populate the entire 30-label sheet automatically.

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: 46 KB • License: Free for Commercial & Personal Use

Avery 5160 / 8160 Address Label Template (30-Up)

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

Exact 30-Up Printable Grid (3 Columns x 10 Rows on Letter 8.5 x 11 in)

Pre-Calibrated Cell Dimensions (1 in Height x 2.625 in Width)

Mail Merge Address Database Tab (Name, Street, City, State, ZIP)

Dynamic Multi-Line Address Concatenation Formula

Print Margins Pre-Configured (Top 0.5 in, Side 0.1875 in)

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

3. Step-by-Step Setup & Customization Guide

Populate Customer Address Database

Switch to the 'Contact List' tab and enter customer names, street addresses, cities, states, and ZIP codes.

Pro Tip: Keep addresses uniform with standard USPS abbreviations (e.g. 'Ste' for Suite, 'St' for Street).

Review the Pre-Formatted 30-Label Grid

The 'Printable Grid' tab automatically pulls contacts from your list and formats them into 30 aligned label cells.

Pro Tip: Verify that long company names fit comfortably without wrapping past the bottom border.

Print Test Page on Plain Paper First

Print at 100% scale (disable 'Fit to Page') on regular paper and hold it up against an Avery 5160 sheet to verify alignment before using real sticker sheets.

Pro Tip: Always set printer scale to 'Actual Size' / 100%.

4. Formula & Automation Architecture

The grid uses TEXTJOIN(CHAR(10), TRUE, ...) combined with INDEX math to flow sequential table rows into a 3-column sticker layout while ignoring blank fields.

Core Formulas Used in This Sheet:

=TEXTJOIN(CHAR(10), TRUE, ContactName, CompanyName, StreetAddress, City & ", " & State & " " & ZipCode)

Combines separate address fields into a single multi-line formatted address block with line breaks.

=INDEX(AddressList!A:A, (ROW()-1)*3 + COLUMN())

Automatically routes continuous contact list entries into a 3-column printable label grid.

5. Frequently Asked Questions & Troubleshooting

Which Avery label product numbers are compatible with this template?

Compatible with Avery 5160, 8160, 5260, 5960, 8460, 6570, 18160, 48160, and generic 30-up 1 x 2-5/8 inch address labels from AmazonBasics and OnlineLabels (OL875).

Why is my printer cutting off the bottom row of labels?

Check your printer settings: ensure 'Page Scaling' is set to '100%' or 'Actual Size', and paper size is set to 'US Letter (8.5 x 11 in)' rather than A4.