✦Template Printable Ideas Insights

Learn How to Print Avery Labels from Excel

By

Do you need to print Avery labels from your Excel data? You're in the right place! This guide will walk you through the process of exporting your data from Excel and printing it on Avery label templates, ensuring a professional finish every time.

Before we get started, ensure you have the Avery software installed on your computer. If not, you can download it for free from the Avery website. Now, let's dive in and explore the two main methods to accomplish this task: Using Avery Design & Print Online and Exporting Data to Avery Disk Label Template (ADLT) format.

Method 1: Avery Design & Print Online

Avery Design & Print Online is a web-based application that allows you to design and print labels directly from your web browser. It's a convenient option if you don't have the desktop software installed or want to avoid additional steps.

an image of a computer screen with the names and numbers on it in microsoft's office window
an image of a computer screen with the names and numbers on it in microsoft's office window
Use Excel's Power to Print Labels in No Time
Use Excel's Power to Print Labels in No Time
Creating Labels from a list in Excel
Creating Labels from a list in Excel

To get started, go to the Avery Design & Print Online website (https://www.avery.com/en/label-printing/design-and-print-online) and follow these steps:

Step 1: Select Your Avery Label Template

Choose the Avery label template that matches your label size (e.g., 5160, 5161, etc.). Ensure that the template is compatible with your label printer.

How to Print Avery Labels in Microsoft Word on PC or Mac
How to Print Avery Labels in Microsoft Word on PC or Mac
Word help & learning
Word help & learning
How to Create Address Labels in Microsoft Word from an Excel File (PC & Mac)
How to Create Address Labels in Microsoft Word from an Excel File (PC & Mac)

Tip: You can find the perfect template for your needs by browsing the Avery website or using the helpful template finder tool.

Step 2: Customize Your Labels

Once you've selected your template, click on the 'Customize Labels' button to enter the design studio. Here, you can upload your Excel data by clicking on the 'Add Your Data' button and selecting the 'CSV' or 'Excel' file format.

Warning: Make sure your data is in the correct format – a single column for each label field. If not, you may need to pre-process your Excel data or use a spreadsheet tool like Microsoft Excel or Google Sheets to prepare your file before uploading.

two screenshots of the same window in windows xp and vista, each with different options
two screenshots of the same window in windows xp and vista, each with different options
Design Templates for Christmas Cards | Free & Customizable
Design Templates for Christmas Cards | Free & Customizable
Avery Template 6871 Print-to-the-Edge Address Labels 1-1/4
Avery Template 6871 Print-to-the-Edge Address Labels 1-1/4
How to Download Free Avery Label Templates
How to Download Free Avery Label Templates
someone holding up a avery address label on a white wall with the words how to make address labels
someone holding up a avery address label on a white wall with the words how to make address labels
Avery Template 5163 Shipping Labels 2
Avery Template 5163 Shipping Labels 2

Method 2: Exporting Data to Avery Disk Label Template (ADLT) Format

The ADLT method involves exporting your data from Excel and then printing it using the Avery Design & Print or Averyratim software. This method is more versatile, as it allows you to fine-tune your label design using the full feature set of the desktop software.

Note: This method requires you to have the Avery Design & Print or Averyratim software installed on your computer.

Step 1: Prepare Your Excel Data

Ensure your data is properly formatted for the Avery disk label template. This typically involves having a single column for each label field. You may need to use Excel's 'Text to Columns' or 'Flash Fill' features to achieve this.

Free PDF Label Templates for Graphic Designing
Free PDF Label Templates for Graphic Designing
How To Print Labels From An Excel List - SlashGear
How To Print Labels From An Excel List - SlashGear
How to create and print Avery Labels straight from home | Business Tip |
How to create and print Avery Labels straight from home | Business Tip |

Tip: Add a header row with field names (e.g., First Name, Last Name, Address) to make it easier to map your data to the label fields.

Step 2: Export Your Excel Data as ADLT

To export your data as an ADLT file, follow these steps:

  1. Select the data range containing your header row and data.
  2. Click on the 'File' menu, then 'Save As'.
  3. In the 'Save As' dialog box, choose 'Avery Disk Label Template (.ADLT)' from the 'File Format' dropdown menu.
  4. Enter a filename and choose a location to save your new ADLT file, then click 'Save'.

Now that you've exported your data as an ADLT file, you can print your labels using the Avery Design & Print or Averyratim software. Open the software, select your Avery template, and import your ADLT file to print your labels.

Congratulations! You've now mastered the art of printing Avery labels from Excel. By following these methods, you can efficiently create and print professional labels for your projects, saving time and maintaining a polished image. Happy labeling!