Print DYMO labels from Excel or Google Sheets, in batches

You can print DYMO labels from Excel or Google Sheets a whole batch at a time. Load your product or address list, connect its columns to a label the size of your LabelWriter roll, then search for the SKU you're restocking and print just those rows, as many copies as you need. It works with the LabelWriter 450 and 550 through your computer's DYMO driver. No signup.

How it works

Every row in your spreadsheet becomes a label

sample-products.csv5 rows

	A	B	C
1	SKU	Product	Variant
2	00123	Linen tea towel	Natural
3	00124	Linen tea towel	Sage
4	A-203	Stoneware mug	Ash
5	A-204	Stoneware mug	Moss
6	A-205	Stoneware mug	Clay

5 rows5 labels

Restock labels for your LabelWriter

Open the 30252 textile label with the sample list, search for a SKU, and print two variants at three copies each.

Make a DYMO batch →

A restock list, not twenty repeated print clicks

Say you run a small knitwear shop (made up for this page) and your whole range lives in one spreadsheet:

Three beanies come back in Charcoal and three in Oat. You don't want labels for the scarves and socks, and you don't want to click Print six times. So you search for TX-110, tick the two beanie rows, set three copies, and get six labels: three per colour. The rest of the list stays where it is for next time.

That "find one product, print a few copies" job is exactly what Nick from Huisman Tricot asked for, working from his own Google Sheet. His story is a good read on why picking rows matters more than printing the whole list: How mylabelmaker helped me make product labels from Google Sheets. The shop, list and printer on this page are our example, not his.

DYMO label examples you can open

Real renders from the editor with fictional data. Each card opens that exact layout with its sample list loaded, so you can step through the rows and see how a long article name or address fits.

DYMO 30252 textile variantsDYMO 30252, 3.5 x 1.12 in. Article, Colour, Size and SKU columns. DYMO 30252 addressDYMO 30252, 3.5 x 1.12 in. Name and address columns. DYMO 30334 barcodeDYMO 30334, 2.25 x 1.25 in. Product, size, SKU columns.

Match your LabelWriter 450 or 550 and the roll

Read the number on the roll first, then open the same size. The two used most for batches:

• 30252 is the 1-1/8 x 3-1/2 inch address label. The textile and address examples above are both 30252, laid out differently: one for an article and a barcode, one for a ship-to block. See DYMO 30252.
• 30334 is 2-1/4 x 1-1/4 inches, a good shape for a product name over a barcode. See DYMO 30334.

Neither the LabelWriter 450 nor the 550 takes a 4 x 6 shipping roll. They're narrow printers. For 4 x 6 you need a wide model like the 4XL or 5XL. The DYMO label sizes page lists the other rolls.

About DYMO compatible labels: DYMO says the LabelWriter 550 series works only with genuine DYMO LW labels. The rolls carry a chip the printer reads, and a roll it doesn't recognize won't print. The older LabelWriter 450 doesn't have that check, so people do run compatible rolls in it. Whichever you use, the label size in the editor has to match the roll exactly.

Upload Excel, load a Google Sheet or paste CSV

In the editor, Data has three ways in. Upload takes your Excel workbook (.xlsx, .xls or .xlsm), a CSV or a TXT file as it is. Google Sheet takes a published CSV link. Paste takes rows copied from any spreadsheet. Put the column names in the first row: SKU, Article, Colour, Size.

A word on private lists: publishing a Google Sheet makes it readable by anyone with the link. For customer addresses or anything you'd rather keep in-house, download the sheet as CSV and upload that instead. And if your SKUs start with zeros, format that column as Text in Excel before you type them, because the editor can only keep the zeros the file still has.

Connect the article, SKU and barcode once

1. Open https://app.mylabelmaker.com with the 30252 textile label. The knitwear list is already loaded. No signup.
2. Click Data and bring in your own file or sheet.
3. Click the article name on the label, then Variables, and pick Article. It becomes {{Article}}. Do the same for the colour and size line.
4. Click the barcode, then Variables, and pick SKU. Leave the Format on CODE128 (alphanumeric) so a SKU like TX-1101 encodes as written.
5. Step through the rows with next and previous. "Merino rib beanie" is the longest name here. If yours crowd the barcode, shorten them on the label or drop the type size a little.

You only do this once. Next restock, upload the updated sheet and the label fills itself. For a click-by-click import with screenshots of the sheet side, see printing DYMO labels from Excel or Google Sheets.

Find one product or tick a batch

Open Edit row. There's a search box at the top: type a SKU, an article or a colour and the list narrows to matching rows. Every row has a checkbox, and they all start unticked after an upload, so a 300-row sheet never prints 300 labels by mistake. Tick what you need and the bar shows the count, for example "2 of 5 selected".

Copies per checked row, and Print this

Click Print and type a number in Copies. It counts per ticked row: with two rows and Copies 3, the editor says "Each of the 2 checked rows prints 3 times", so six labels come out. Every ticked row gets the same number. If the Charcoal beanie needs five and the Oat needs two, run them as two prints.

Print this is for the one-off. It prints only the label on the canvas, with its own copy count, and ignores the ticks.

Print through your computer with the right roll size

DYMO printers go through This computer, the printer choice in the top bar. That uses the DYMO driver on your computer, which installs along with DYMO Connect for Desktop. In the print dialog, pick your LabelWriter, choose the paper size that matches the roll (30252 Address, for example), and print at 100% with fit-to-page off. Print one, check it, then print the batch.

Setting up a new printer? The LabelWriter 550 setup guide covers the install order and loading the roll.