Print Avery® 5160® Labels from Excel — Free, No Word Needed

This program is not made, tested or endorsed by Avery Products Corporation. Avery and all Avery brands, product names and codes are trademarks of CCL Label, Inc.

Avery® 5160® labels use America's most popular label format — those familiar 2.625" × 1" address labels with 30 labels per sheet. If you have addresses in an Excel spreadsheet, you shouldn't need to wrestle with Word's complicated mail merge feature just to print them. There's a much simpler way.

OpenLabelMaker lets you upload your Excel file directly, automatically map your columns to a template for 5160® labels, and print perfectly aligned labels in minutes. No Microsoft Word required, no confusing mail merge setup, and no alignment issues.

Step-by-Step: Excel to 5160® Labels

Step 1: Prepare Your Excel Data

Your Excel spreadsheet should have columns for address information. Common column headers include:

Step 2: Upload to OpenLabelMaker

1. Open OpenLabelMaker in your web browser
2. Click "Create New Label" or "Import Data"
3. Select the template for 5160® labels from the template library
4. Upload your Excel file using the "Import" button
5. Preview shows your first few records to confirm import

Step 3: Map Excel Columns to Label Fields

OpenLabelMaker automatically detects common address fields, but you can manually map if needed:

• Name field → First row of each label
• Address field → Second row of each label
• City, State, ZIP → Third row, properly formatted
• Company field → Optional first row if included

Step 4: Customize the Layout for 5160® Labels

Fine-tune your label appearance:

• Choose fonts that fit well in the 2.625" × 1" space
• Adjust line spacing for readability
• Add your return address if needed
• Preview individual labels before printing

Step 5: Generate & Print 30 Labels Per Sheet

Create a PDF that aligns perfectly with 5160® label sheets:

1. Click "Generate PDF" to create the printable file
2. Download the PDF to your computer
3. Load 5160® or compatible label sheets into your printer
4. Print the PDF — each sheet contains exactly 30 labels
5. Labels peel off cleanly and stick securely

5160® Label Specifications

Understanding the exact dimensions ensures perfect printing:

Excel vs Word Mail Merge: Why Excel Direct is Better

Common Excel Data Scenarios

Scenario 1: Customer Database

Your Excel file contains customer information for mailing campaigns:

• Source: CRM export, customer survey, sales database
• Columns: First Name, Last Name, Company, Address, City, State, ZIP
• Best practice: Combine First + Last name for the name field
• Tip: Filter out incomplete addresses before uploading

Scenario 2: Event Attendee List

Printing name tags and mailing materials for conference attendees:

• Source: Registration platform export (Eventbrite, Mailchimp)
• Columns: Full Name, Company, Title, Address fields
• Best practice: Include company name on address labels
• Tip: Sort by ZIP code for postal efficiency

Scenario 3: Holiday Card List

Personal mailing list for holiday cards and invitations:

• Source: Contact app export, manual list
• Columns: Family Name, Address, City, State, ZIP
• Best practice: Use "The Smith Family" format for family addressing
• Tip: Include apartment numbers in address field

Troubleshooting Common Issues

Excel File Won't Upload

• Save as .xlsx format (not .xls or .csv)
• Remove any merged cells or complex formatting
• Ensure file is under 5MB in size
• Check that column headers are in the first row

Labels Don't Align with Sheet

• Verify you're using sheets with the correct 30-per-sheet layout
• Check printer settings — use "Actual Size" not "Fit to Page"
• Ensure paper guides are properly adjusted
• Test with plain paper first to check positioning

Text is Cut Off

• Reduce font size (try 10pt or smaller)
• Abbreviate long addresses ("St" instead of "Street")
• Use shorter line spacing
• Break very long company names across two lines

Batch Printing for Large Lists

When you have hundreds or thousands of addresses, OpenLabelMaker handles large batches efficiently:

• Automatic pagination: Splits data across multiple 30-label sheets
• Print range selection: Print specific sheets if you run out of labels
• Progress tracking: See exactly which addresses are on which sheets
• Resume capability: Continue from where you left off if printing is interrupted

Related Resources

Frequently Asked Questions

Can I use Google Sheets instead of Excel?

Yes! Export your Google Sheets data as Excel (.xlsx) format and upload it the same way. The process is identical.

How many addresses can I print at once?

There's no practical limit. OpenLabelMaker handles files with thousands of addresses, automatically creating as many 30-label sheets as needed.

Do I need special software besides a web browser?

No! OpenLabelMaker runs entirely in your web browser. You just need your Excel file and access to a printer with 5160® label sheets.

Can I add a return address to each label?

Yes, you can add a return address that appears on every label, or create a separate set of return address labels using the same template for 5160® labels.

Skip the frustration of Word's mail merge and print your 5160® labels the easy way. Upload your Excel spreadsheet, let OpenLabelMaker handle the formatting, and get perfect 30-labels-per-sheet results every time. It's the simplest solution for turning your address data into professional mailing labels.