Print labels from Google Sheets for free

Click the first header cell, then Shift-click the last cell of the last row, and copy. Selecting the whole sheet with Ctrl+A (⌘+A) works too: rows with nothing in them, and empty columns at the right-hand edge, are dropped when the cells are read.

Include the header row. The first row you paste is read as column names, and the tool uses those names to lay out the label: a list with Name, Address, City, State and ZIP columns becomes a US address label with city, state and ZIP code on one line. If you copied only the data rows, untick “First row holds column names” in step 1. The columns are then called Column A, Column B and so on, and you can place them on the label the same way.

To paste, click “Paste cells instead” under the file picker and paste into the box, or press Ctrl+V (⌘+V) anywhere on the page outside a text field. The preview updates as soon as the cells arrive. A single pasted row, such as one return address, is read as a label rather than as column names.

Copying is usually quicker than downloading a file, and it leaves nothing behind in your downloads folder. The cells go from your clipboard into this browser tab and no further.

Google’s own instructions for installing an add-on say that for most of them “a message will appear requesting access to data that the add-on needs to work”, which you accept by clicking Allow. For a label add-on that access is usually to your Docs and Sheets, and several of the popular ones ask for every document and spreadsheet in the account, not only the one you are printing from. For a list of names and home addresses, that is a lot to hand over for a job you may do once a year.

Not every add-on asks for that much. Some request access only to the file they are used in, and the consent screen says which before you click Allow, so read it. An add-on you no longer need can be removed under Extensions › Add-ons › Manage add-ons. Google also notes that some add-ons may not work correctly in a browser that blocks third-party cookies.

The most-installed label add-ons charge once you pass a trial or a label cap. The table below shows what two of them listed on September 28, 2026.

Pasting into Print Labels From Excel involves no sign-in, no consent screen and nothing installed. There is no account system and no server that receives your list: the cells are read by JavaScript in your browser tab, and the PDF is built in the same tab.

An .xlsx download keeps every tab in the spreadsheet. When the file has more than one, the tool shows a Worksheet menu so you can pick the tab with your list. A CSV file can only hold one tab, so open the tab you want before you download it.

A file is the better route when the list is long, when you want to keep a copy for next year, or when you print from a different computer from the one you edit on. The tool reads files up to 25 MB and the first 5,000 rows, and one PDF holds up to 10,000 labels. The .ods and .tsv downloads from Sheets are read as well, and so is a workbook from Excel, which works exactly as described in print labels from Excel.

Either way, the file is opened inside your browser and never uploaded.

Keep each part of an address in its own column: name, street, city, state and ZIP code. If yours are typed into a single cell with line breaks, split them first. A line break inside a cell prints as a space, so the whole address would come out as one long line. In Google Sheets, =SPLIT(A2, CHAR(10)) spreads a multi-line cell across the columns to its right, and Data › Split text to columns does the same for text separated by commas. The address labels guide covers the US layout in detail.

If the leading zeros have gone from your ZIP codes, the tool puts them back. In a column named ZIP, a three- or four-digit value is padded to five digits, so 2108 prints as 02108 (in a postal code column, only on rows with a US state), and the summary says how many it changed.

To print some rows more than once, add a column with the number of copies and choose it under “Copies of each row” in More options. A row with 0 is skipped. Rows with nothing to print are skipped too, so blank rows at the bottom of the sheet never turn into blank labels.

Avery used to offer its own add-on, Avery Label Merge. Avery’s help center now says it “is no longer available in the Google Workspace store”, and points people to its free Design & Print Online website, which can bring in a list from Google Sheets once you have a free Avery account. The same page says that marketplace apps called Avery Label Merge, Foxy Labels and Label Maker are not affiliated with or supported by Avery.

You can also draw a table in a Doc and type the labels into it, but a table is a poor stand-in for a label sheet. Its rows grow to fit their text, so one address that wraps onto an extra line pushes every label below it off its cut, and the page margins have to be matched to the sheet by hand.

A PDF from Print Labels From Excel places every label at a fixed position taken from the sheet’s measurements, and a line too long for its label is shrunk to fit, so one long address cannot move its neighbors. Step 3 of the tool can also download a blank template for your sheet, most with a 1.000 in reference line, so you can test alignment on plain paper. Every sheet is listed on the label templates page.

Print Labels From Excel is an ordinary web page, so it opens in a phone or tablet browser with the same steps: paste cells or choose a file. The hard part is getting a clean copy of the list out of the Sheets app, where selecting a few hundred rows by dragging is slow and easy to get wrong. If the list is already saved on the device as an Excel or CSV file, choosing that file in step 1 is simpler than copying.

For anything longer than a screenful, open the spreadsheet at sheets.google.com on a computer, copy it there, and print from the computer. You also get a larger preview to check before you print.

A Chromebook works like any other computer here: the spreadsheet in one tab, the tool in another, and nothing to install.