Save 10% off your first LabelValue order | Use coupon: LABELFIRST at checkout

How to Print Labels From An Excel Spreadsheet Using A Dymo LabelWriter Printer

The Dymo LabelWriter printer and included software comes standard with a variety of additional features that makes for easy labeling. A great feature of the Dymo Printer and its software is the ability to set up and print entire Excel lists with just a few easy steps. Many of our customers take advantage of this great feature while using our LabelValue manufactured, Dymo LabelWriter labels. We carry a wide variety of USA-Made Dymo compatible products and can also create a wide range of custom sizes to exactly fit the application you need. View our top products below and learn how to use them to print labels from an Excel Spreadsheet in the article that follows.

Easily Create and Print Dymo LabelWriter Labels from an Excel Spreadsheet

STEP BY STEP GUIDE - How to Print Dymo Labels From an Excel Spreadsheet:

How to Print Dymo Labels from Excel: Step 1

1. Open Microsoft Excel and start with a blank document. Here we will create a list used to print multiple labels on the Dymo LabelWriter.

How to Print Dymo Labels from an Excel File - Step 2

2.When setting up your Excel document, each column should contain the unique information you need to print. As shown in the example, Column A contains first names, Column B contains last names, etc. Continue setting up the excel file in this manner until you have all the required information for your labels.

Note: Column headers (First Name, Last Name, Street, etc.) are not needed when setting up your print file as they will print on your first label.

How to Print Dymo Labels from an Excel File - Step 3

3. Once your list is set up, make sure you save and exit Excel. Now, navigate to your Dymo Label software. Select the type of label you will be using. For this example we will be using our Dymo Compatible 30256 large shipping label.

How to Print Dymo Labels from an Excel File - Step 4

4. The Dymo software makes it easy for you to input your own company name like we have done here in the heading of our label. Once you have input your desired name, navigate to the “Insert” tab within the Dymo LabelWriter software. Within this list of printable objects, select the “Address” box.

How to Print Dymo Labels from an Excel File - Step 5

5. Click, hold & drag the address box over to your label. Release your mouse to place the address box on your label.

How to Print Dymo Labels from an Excel File - Step 6

6. Now, resize your address box to the desired size for your Dymo label.

How to Print Dymo Labels from an Excel File - Step 7

7. Now, using your mouse, click the address box and select it.

How to Print Dymo Labels from an Excel File - Step 8

8. While still in the DYMO Print Software, Navigate to File > Import Data and Print > New.

How to Print Dymo Labels from an Excel File - Step 9

9. When you select "New" a Pop-up will appear for “Import Data and Print.” Click Next.

How to Print Dymo Labels from an Excel File - Step 10

10. Select your data file for your label by using the “browse” function.

How to Print Dymo Labels from an Excel File - Step 11

11. Choose the Excel file you just created and select “open.”

How to Print Dymo Labels from an Excel File - Step 12

12. Click next, which will bring you to the following step in importing your data. Here you need to select the address box you just created as the destination for your data fields.

How to Print Dymo Labels from an Excel File - Step 13

13. Now simply drag and drop your columns to your desired output by using your mouse and clicking on the field name (Field1, Field2, Field3, etc.) You can have more than one field on a line as shown in the preview. The DYMO software gives you a real-time preview to the right so you can see what your labels will look like when printed.

Note: To delete a field, click on the line with the field you want to remove and use your Backspace Key.

How to Print Dymo Labels from an Excel File - Step 14

14. Once you have your label set up how you like it, press next. This will bring up last step in the “Import Data and Print” process. Here you can select if you want to print your entire list, or a select few. To do so, use the check boxes on the left-hand side of your list to either select all or select specific entries.

How to Print Dymo Labels from an Excel File - Step 15

15. When you have selected all the entries you need to print, click on the “Print” button in the lower right hand corner. Your labels will now print with different information on each label depending on what was input into the Excel file.

Using a Label Printer around the office or home can greatly increase your organization and productivity. Use this simple tutorial on printing labels from Excel in combination with our DYMO compatible labels to address holiday cards, birthday invitations, even monthly invoices.

Check out LabelValue.com’s extensive inventory of Dymo Compatible Labels for virtually any application. Don’t see the size you’re looking for? Contact us today! We offer custom Dymo label sizes, as well as full-color labels that are compatible with LabelWriter printers.

Share: