Neither Google Sheets nor Excel has a simple "print this list as labels" button. Google Sheets can't print labels at all. If you choose File → Print, it prints the grid of cells, and there is no built-in label maker. Word's mail merge will do the job, but it has a lot of steps. Here is a plainer route, plus a couple of alternatives if you'd rather stay in tools you already use.
Disclosure: I make LabelPeel, so I'm not neutral. Every step below also works with other tools, and the tips apply whichever one you pick.
Step 1: Tidy the sheet
Most label problems start in the spreadsheet. Before you copy anything:
- Keep one heading row (Name, Street, City, State, ZIP) and one row per label.
- Put each part of the address in its own column. A whole address in one cell is hard to split later.
- If someone has a second address line, give it its own column (Address 2). An empty cell just leaves that line out.
- Delete blank rows, which can produce blank labels, and unmerge merged cells, which copy badly.
- Format the ZIP column as Plain text. Sheets treats ZIP codes as numbers, so 01234 turns into 1234. Format first, then retype or paste the codes.
Step 2: Get the list out of Sheets
You have two choices:
- Copy and paste. Select the whole list including the heading row and press Ctrl+C (Cmd+C on a Mac).
- Download a file. Use File → Download → Comma-separated values (.csv). This saves the current tab only. Other file types work too: the tool I use accepts .xlsx, .xls, .ods, .csv, .tsv and .txt.
- Starting from Excel instead? The same tidy-up rules apply (format the ZIP column as Text before typing codes). Copy the cells, or use the .xlsx file as it is.
Step 3: Load it into a label tool and pick the sheet
In LabelPeel, paste the rows into the box (keep the headings, since they name your columns) or drop in the CSV. Then pick your label sheet by typing the code printed on the pack:
- US Letter: Avery® 5160 is the common address label: 1" × 2⅝", 30 labels per sheet, 3 across and 10 down. 5163 is the larger 2" × 4" shipping size.
- A4: A4 sheets use the codes that start with L, such as L7160 or L7163.
If your pack is from another brand, many print the matching Avery® code. For anything else, use a custom size and type in the measurements from the pack.
Step 4: Check the columns
This isn't a separate "mapping" screen. The tool guesses which columns belong on the label, and you tick or untick them. You can also type your own wording with placeholders such as {Name} on one line and {Address} on the next, so each row fills in its own details. You don't need every column on the label; leaving out the state is fine.
Step 5: Preview before you print
Look at the preview before you spend a sheet. Check that the longest name and the longest address fit, that nothing is cut off, and that blank cells didn't leave gaps. Click a label to fix a typo directly.
To be clear about accounts: previewing is free, and the homepage has a box where you can try it without signing up. Printing, or downloading the PDF, needs a free LabelPeel account. It's free while the tool is in beta, with no card needed.
Step 6: Test-print on plain paper
Print one page on plain paper first. Hold it against the label sheet in front of a window or lamp. If the text sits in the wrong place, you've lost a sheet of paper instead of a sheet of labels.
Printer settings that matter:
- Scale at 100%, or "Actual size". Turn off "Fit to page" and "Shrink to fit". This causes most alignment problems.
- Paper size: Letter for US sheets, A4 for the L-codes. A mismatch shifts everything.
- If the page is slightly off, use a small nudge setting if your tool has one rather than rescaling.
- On a half-used sheet, start printing at the first free label so you don't waste the rest.
Then print on the real sheet.
Alternatives
- Word mail merge. Download the sheet as an Excel file (File → Download → Microsoft Excel), then use Mailings → Start Mail Merge → Labels, choose your label brand and number, connect the list, insert the merge fields, update labels, preview and finish. It works and gives you plenty of control, but it's slow, and the Excel file is a one-time copy: if the Sheet changes, download again.
- A Google Docs table. For a handful of labels, size a table to match your sheet and fill in each cell. This is slow for long lists.
Quick troubleshooting
- Blank labels: blank rows in the sheet. Delete them and copy again.
- Names split across two labels: a stray line break in a cell. Remove it and copy again.
- Drifting alignment down the page: scaling isn't at 100%.
- Labels don't match the sheet: check the code on the pack, because 5160 and 5163 look similar but are different sizes.
Test one page, check the preview, and the rest is mostly paper.
Avery® is a registered trademark of Avery Products Corporation. This article is not affiliated with or endorsed by Avery.


