Free Shipping on Every In-Stock Order in the USA!

How to Print Dymo LabelWriter Labels from an Excel Spreadsheet

Easily Create and Print Dymo LabelWriter Labels from an Excel Spreadsheet

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 compatible 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 from an Excel Spreadsheet in the article that follows:

TOP DYMO COMPATIBLE LABELS:

 

 

Step by Step Guide – printing from an excel spreadsheet:

Note: Click on an image within the step by step to enlarge and get a better look.

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 show 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.

*Did You Know? LabelValue.com offers a wide variety of DYMO compatible labels guaranteed to work in your DYMO printer. View our selection, here.

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 labeling 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 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 guaranteed to be compatible with your label printer.

Shop Dymo Compatible Labels Now



1