Printing labels from Google Sheets

Method 1: copy and paste the cells

1. In Google Sheets, select the cells you want — including the header row, so the columns can be identified.
2. Copy them (Ctrl+C, or ⌘C on a Mac).
3. Open the label tool, click into the text box, and paste.
4. The columns are recognised and mapped to label lines. Check the preview and download your PDF.

Best for a list you can select in one go. Nothing is downloaded and nothing is installed.

Method 2: download the sheet, then upload it

1. In Google Sheets, choose File → Download → Microsoft Excel (.xlsx).
2. Open the label tool and click Upload Excel or CSV, or drop the file onto the page.
3. Check the header row was found correctly, adjust what prints on each line, and download.

Choose .xlsx rather than .csv. The xlsx file records which rows are hidden, so a filtered list stays filtered. A CSV loses that, and it also loses the distinction between a ZIP code and a number.

How to set the sheet up

The column names do not have to be exact — the usual variations are recognised — but the structure matters:

• One address per row. No blank rows in the middle, and no addresses split across two rows.
• A header row with names like Name, Address, City, State, ZIP. A title above it is fine; it will be skipped.
• No merged cells. Merging breaks the row-to-label mapping, and it is the one thing that cannot be recovered.
• Format ZIP columns as plain text (Format → Number → Plain text) before typing, so 02134 stays 02134.

Exports from Google Contacts work directly too — their column names, such as "Address 1 - Street", are recognised without renaming anything.

Check for duplicates before you print

A Google Sheet that several people have added to almost always has duplicates, and Sheets' own Remove duplicates only catches rows that match character for character — "12 Oak St" and "12 Oak Street" both survive it.

Duplicates are found automatically when you import, and listed so you can check them. To clean the list without printing anything, use Remove duplicate addresses and download a tidied CSV.