How to Use Avery Templates in Excel

Creating and printing Avery labels doesn't mean you have to leave your trusty spreadsheet behind. If your address lists, product SKUs, or contact information already live in Excel, you can use that data to create perfectly formatted labels without tedious copy-pasting. This guide will walk you through exactly how to set up and use Avery templates with Microsoft Excel.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Use Excel for Avery Labels?

While Microsoft Word is often the go-to for mail merges, starting in Excel has some serious advantages, especially when it's already your home base for data.

• Your Data is Already There: If you manage your contact lists, inventory, or event attendees in an Excel sheet, you can connect it directly to a label template. This avoids exporting and importing files or retyping information, saving time and reducing errors.
• Powerful Data Management: Excel is built for sorting and filtering data. Before you even begin the label-making process, you can easily filter your list for specific customers, sort contacts by zip code for bulk mailings, or hide rows you don't want to print.
• Central Source of Truth: When you update a contact’s address in your main Excel file, that change is automatically pulled into your labels the next time you print. This ensures you’re always working with the most current information.

The most common and reliable method involves using Excel to prepare your data and then using Microsoft Word's Mail Merge feature to format and print the labels. We'll also cover a manual method for simpler jobs directly within Excel.

Method 1: The Mail Merge Approach (Excel + Word)

This is the industry-standard method and by far the most powerful and reliable way to print Avery labels from a list in Excel. It connects your spreadsheet to Word, letting Word handle the layout while Excel handles the data.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Prepare Your Spreadsheet in Excel

Clean data is the foundation of a successful mail merge. Before you even open Word, make sure your Excel file is properly organized.

• Use Headers: The first row of your sheet should contain clear column headers, such as FirstName, LastName, Address_Line1, City, State, and ZipCode. Try to keep them simple and avoid spaces or special characters (e.g., use "FirstName" instead of "First Name").
• One Record Per Row: Each row below the header should represent a single record - for example, one person's complete address information.
• Break Out Data: Separate data into distinct columns. Instead of one column named "Full Name," have separate "FirstName" and "LastName" columns. This gives you more flexibility when arranging your label.
• Formatting: Make sure data like ZIP codes and phone numbers are formatted as text to prevent Excel from dropping leading zeros. You can do this by selecting the column, right-clicking, choosing "Format Cells," and selecting "Text."
• Save Your File: Save your completed Excel sheet in an easy-to-find location.

Step 2: Set Up the Label Template in Word

Now, open a blank document in Microsoft Word to begin the mail merge process.

1. Navigate to the Mailings tab on the ribbon.
2. Click Start Mail Merge and select Labels from the dropdown menu.
3. The "Label Options" dialog box will appear. Under "Label vendors," select Avery US Letter (or the appropriate region for your product).
4. Scroll through the "Product number" list and find your specific Avery template number (e.g., 5160 Address Labels). Select it and click OK.

Word will now display a page that looks like a blank sheet of labels, laid out in a table format.

Step 3: Connect Your Excel Spreadsheet

It's time to tell Word where to pull the data from.

1. On the Mailings tab, click Select Recipients and choose Use an Existing List...
2. Browse to the location where you saved your Excel file, select it, and click Open.
3. A "Select Table" window will appear. If you have multiple sheets in your workbook, select the one containing your address data. Make sure the box for "First row of data contains column headers" is checked. Click OK.

Your document won't look much different, but you will see entries like «Next Record» appear in the label cells after the first one. This confirms Word is connected to your data source.

Step 4: Arrange and Insert Merge Fields

Now, you'll design the layout of your label by telling Word which data to put where.

1. Click your cursor into the first label cell in the top-left.
2. On the Mailings tab, click Insert Merge Field.
3. Select a field from the list, for example, «FirstName».
4. Press the spacebar, then go back to Insert Merge Field and select «LastName».
5. Press Enter to move to the next line.
6. Continue inserting fields - like «Address_Line1» and a block for city, state, and ZIP - until the first label is formatted exactly how you want it. Don't forget to add spaces and punctuation (like the comma after the city) where needed.

Step 5: Replicate the Layout Across All Labels

Once your first label is perfect, you need to apply that format to all the other labels on the sheet.

• While still on the Mailings tab, click the Update Labels button. Word will copy the field arrangement from the first label to every other label on the page. This is a critical step that’s easy to miss!

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 6: Preview, Finish, and Print

The final step is to preview the results and send them to your printer.

1. Click Preview Results on the Mailings tab. You should now see your actual data from Excel filling out the labels.
2. Use the arrow buttons next to the Preview Results button to cycle through a few records to make sure everything looks correct.
3. When ready, click Finish & Merge and then Print Documents...
4. You can choose to print all records, just the current record, or a range.

Always print a test page on plain paper first. Hold it behind a blank Avery sheet and check the alignment against a light source before printing on your actual label sheets.

Method 2: Manual Setup in Excel

This method skips Word entirely but requires more manual measurement and adjustment. It’s best suited for very simple labels that don't need complex formatting, such as return address labels where the content is identical on every label, or when you only have a few labels to create.

Step 1: Find Your Label's Dimensions

First, get the exact specs for your Avery product. Go to the Avery.com website and search for your product number. Look for a template page that lists the technical specifications. You’ll need the following info:

• Label Height and Width
• Top and Left Margins
• Horizontal and Vertical Pitch (distance from start of one label to the start of the next)

Step 2: Set Page Layout in Excel

Open a new Excel sheet and go to the Page Layout tab.

• Click Margins > Custom Margins. Enter the exact top, bottom, left, and right margins from the specifications.
• Under the Page tab within the same menu, set the "Print quality" and orientation correctly. A page view might help here: click View > Page Layout.

Step 3: Adjust Cell Sizes to Match Labels

This is where the manual work comes in. You need to adjust your column widths and row heights to match the label dimensions.

1. For Column Width: Right-click a column header (e.g., A) and choose Column Width. The measurement is in characters, so you may need some trial and error. Alternatively, click and drag the column boundary while holding the Alt key to see measurements in inches or centimeters. Set the column widths to match the horizontal dimensions and spacing.
2. For Row Height: Right-click a row number (e.g., 1) and choose Row Height. Adjust to match your label height.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 4: Enter and Print Your Data

Once your grid looks like a sheet of labels, you can type or paste your data into the cells. You can also use a formula to concatenate data from other sheets, like:

=Sheet1!A2 & " " & Sheet1!B2

When printing, ensure your printer settings are set to 100% (Actual Size) or turn off scaling to maintain precise measurements.

Tips for Flawless Labels Every Time

• Check Your Data: For mailings, make sure ZIP codes are five digits and check for missing entries. Clean data ensures smooth printing.
• Use the "Address Block" Helper: In Word's Mail Merge (Method 1), the "Address Block" button helps format addresses automatically.
• Always Print a Test Page: Verify alignment on plain paper to avoid wasting labels.
• Printer Settings are Crucial: Use settings appropriate for label sheets, such as "Labels" or "Heavy Paper," to prevent jams.

Final Thoughts

Creating Avery labels from Excel is manageable once you understand the process. The Mail Merge approach offers the most power and flexibility for large lists, while a manual setup works for simple cases. Starting with clean, organized data is essential for perfect labels.

While working with label data in spreadsheets is a specific task, it reflects a broader challenge many teams face: manually gathering data for reports. When your marketing and sales data are scattered across Google Analytics, HubSpot, and Shopify, generating reports becomes as repetitive as making labels by hand. At Graphed, we simplified this process. You can connect all your data sources and create real-time dashboards simply by asking questions in plain English—no complex formulas or lengthy setup. To gain instant insights without data-wrangling, try Graphed.