Print Rollo printer labels from Excel or Google Sheets

You can print a stack of Rollo labels straight from a spreadsheet: one order row becomes one 4 x 6 packing label, and one product row becomes a 3 x 2 or 2 x 1 label with its own barcode. Upload the Excel file or CSV, connect the columns once, tick the rows you need, and print the batch through the Rollo driver on your computer. 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

Make a Rollo batch

Open the 4 x 6 packing label with five sample orders, then swap in your own export.

Make a Rollo batch →

Turn an order export into packing labels

Say your shop exports the morning's orders as a CSV. Before the carrier label goes on, you want a big label on each box or tote that says which order it is, who it's for and how many items should be inside. That's what the first example does. It is an internal packing label, not postage. The carrier label still comes from your carrier or your shipping software.

Here is the fictional order list behind the 4 x 6 example. The names and order numbers are made up:

Each row fills one label: the order number big at the top, the name and item count under it, and a barcode of the order number so you can scan the box at the bench. Your export probably has twenty columns. You only connect the three or four you want on the label, and the rest are ignored.

An order export has customer names in it. Download it as a CSV and upload the file. Don't publish it to the web just to get it into a label tool.

Rollo label examples from a spreadsheet

These are real renders from the editor. Each one opens with the same layout and its sample sheet loaded, so you can step through the rows before you use your own. The orders and products are fictional.

4 x 6 internal packing labels4 x 6 in roll. Order, Name, Items, Packed columns. Not postage. 3 x 2 variant labels from the same list3 x 2 in roll. Product, Variant, Batch and SKU columns. 2 x 1 SKU labels from a product list2 x 1 in roll. Product, Variant and SKU columns, CODE128 of the SKU.

Choose a 4 x 6 packing label or a smaller product label

The 4 x 6 is the roll most Rollo owners already have loaded. It suits anything that rides on a box: the order, the packer's date, a big scannable number.

Product labels go on the item, not the box, so they come from a different list. The 3 x 2 and 2 x 1 examples read this fictional product sheet, the same one you can download as a CSV or Excel file:

The 3 x 2 has room for the product, the variant, the batch and a CODE128 of the SKU. The 2 x 1 keeps just the product, the variant and the barcode. These layouts are the same ones the Zebra pages use, because a 4 x 6 is a 4 x 6 whichever printer feeds it. For the plain sizes, see the Rollo 4 x 6, 3 x 2 product and 2 x 1 barcode templates.

Excel, Google Sheets or CSV: three ways in

• Excel: upload the .xlsx, .xls or .xlsm file in Data as it is. You don't have to convert it to CSV first. More on this in printing labels from Excel.
• CSV: most shop platforms can export orders or products as CSV. Upload it in Data. See printing labels from a CSV.
• Google Sheets: for a product list with nothing private in it, the Google Sheet tab takes a link published as CSV. For an order list with customer names, use File > Download > Comma-separated values and upload that file instead. The Google Sheets labels page has both routes.

Keep SKUs as text. If Excel already turned 00123 into 123, the zeros are gone from the file and the barcode will say 123. Format the column as Text and type the codes again.

Print a Rollo batch from your spreadsheet, step by step

1. Open https://app.mylabelmaker.com with the 4 x 6 packing sample, or pick the 3 x 2 or 2 x 1 card above. No signup.
2. Click Data and upload your Excel file or CSV. Keep the column names in the first row. The mode should read Each row: one label per row.
3. Click a text box on the label, click Variables, and pick the column that belongs there. It turns into {{Order}}, {{Name}} and so on. Do the same for the barcode, so each label's bars hold that row's order number or SKU.
4. Use the next and previous arrows to step through the rows. Stop on the longest name. If it wraps into the barcode, make the text a size smaller.
5. Open Edit row. Every row starts unticked, so nothing prints until you choose it. Search for an order number or a product name, then tick the rows you're packing now.
6. In the top bar, choose This computer as the printer.
7. Click Print and set Copies. With two rows ticked and Copies at 3, the app says each of the 2 checked rows prints 3 times: six labels.
8. In your computer's print dialog, pick the Rollo and the paper size that matches the roll. Print one label first, then the rest.

Need just one more label for a box you missed? Print this prints only the label on the screen, with its own copy count.

Match the Rollo driver to the roll

The Zebra Printer choice in the top bar uses Zebra Browser Print, and that only talks to Zebra printers. A Rollo prints through This computer, which hands the label to the Rollo driver installed on your Mac or Windows PC. If the Rollo isn't installed there, it won't show up in the print dialog either.

Most misprints on a thermal roll are a size mismatch, not a design problem. A 2 x 1 layout sent with yesterday's 4 x 6 paper size leaves a long blank tail, and a 4 x 6 sent to a 2 x 1 paper size gets cut off. Set the paper size in the print dialog to the label you loaded, keep the scale at 100%, and check the first label against the roll before you send fifty. The Rollo label sizes page lists the rolls you can open.