Part of Rollo labels. The sizes and the other how-tos for that printer start on that page.

← Rollo labels

Rollo 3 x 1.5 shelf labels from Google Sheets

Published: · 3 min read · How-to
Open it and print: this Rollo 3 x 1.5 shelf. No signup.

You can print Rollo 3 x 1.5 shelf labels from Google Sheets in the browser. Open the Rollo 3 x 1.5 shelf template. It is already 3 x 1.5 in. Change the words, or load a list, and print. No signup.

Good to know: Print from this computer with the Rollo driver. Pick this size and leave scaling off. A Rollo, Rollo Wireless, or Rollo X1040 prints up to 4 inches wide.

How to print Rollo 3 x 1.5 shelf labels from Google Sheets

A Google Sheet has to be published before it will load. File, Share, Publish to the web, then CSV. Paste that link. A normal share link will not load. The first row has to be the column names. Luis already has 24 rows, is labeling a pantry of jars, with Flavor, Size, and Price. Row 2 might read Peach jam, 8 oz, 7.

Paste the published link, then click those columns onto Rollo 3 x 1.5 shelf. The size is already 3 x 1.5 in. A view-only share link will not load, even if you can open it yourself.

One row becomes one Rollo 3 x 1.5 shelf label. Check the rows you want, then Print. Print this reprints only the label on screen. Unchecked rows stay in the list. The file stays in this browser. There is no account.

  1. Open https://app.mylabelmaker.com/?template=zebra-3x15. No signup.
  2. The label is already 3 x 1.5 in. Change the line that should differ, or click your column names onto it.
  3. If you have a list, like Luis's 24 with Flavor, Size, and Price, upload Excel or CSV, or paste a published Google Sheet.
  4. Check the rows you want. Print this is the label on screen. Print is the checked rows.
  5. Print from this computer with the Rollo driver. Pick this size and leave scaling off. A Rollo, Rollo Wireless, or Rollo X1040 prints up to 4 inches wide.

The other Rollo sizes are on the Rollo labels page. Open the number that matches the box in your hand. Check a short name and a long one, like Peach jam, 8 oz, 7, before you print the rest of the 24.

Questions people ask

How do I print Rollo 3 x 1.5 shelf labels from Google Sheets?

Open the Rollo 3 x 1.5 shelf template (3 x 1.5 in). Edit it or load your list, and print. No signup. Print from this computer with the Rollo driver. Pick this size and leave scaling off. A Rollo, Rollo Wireless, or Rollo X1040 prints up to 4 inches wide.

Do I need an account?

No. Open the label, edit it, and print. You do not pay to download it. A published Google Sheet is fetched from Google. The label itself stays in this browser.

Does a spreadsheet fill every label on a page?

A spreadsheet prints one label per row. Print this is the label on screen. Print is the rows you checked.

Open the Rollo 3 x 1.5 shelf label

The size is already set. You change the words.

Open this label