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

← Rollo labels

Rollo 1 x 1 square labels from Google Sheets

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

You can print Rollo 1 x 1 square labels from Google Sheets in the browser. Open the Rollo 1 x 1 square template. It is already 1 x 1 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 1 x 1 square 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. Owen already has 40 rows, is tagging bins in a small stock room, with Item, Price, and SKU. Row 2 might read Hex bolt, 0.40, HB-204.

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

One row becomes one Rollo 1 x 1 square 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-1x1. No signup.
  2. The label is already 1 x 1 in. Change the line that should differ, or click your column names onto it.
  3. If you have a list, like Owen's 40 with Item, Price, and SKU, 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 Hex bolt, 0.40, HB-204, before you print the rest of the 40.

Questions people ask

How do I print Rollo 1 x 1 square labels from Google Sheets?

Open the Rollo 1 x 1 square template (1 x 1 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 1 x 1 square label

The size is already set. You change the words.

Open this label