Skip to content

Address labels from a spreadsheet

Turn an Excel or CSV mailing list into a PDF that prints onto Avery 5160, 5163, L7160 and other label sheets, with a test page to line them up. No upload.

  • Runs in your browser
  • Nothing is uploaded
  • Free, no sign-up

or drop it here. Excel (.xlsx), CSV or TSV, up to 50 MB. Nothing is uploaded.

Paste from a spreadsheet instead

How it works

Open a mailing list saved from Excel, Google Sheets, Numbers, Outlook or Google Contacts as .xlsx or CSV, or paste the cells straight from a spreadsheet. The page reads the column names and guesses the label lines: the name, a company, the street lines, and the town line, written as {City}, {State} {ZIP} for US Letter sheets and line by line for A4 sheets. Change the lines as you like: put columns in braces, add plain text such as "Attn:", or take a line out. A line whose columns are all empty, such as a missing second street line, is left out of that label, so no label has a gap in it.

Each label's text is centred top to bottom and starts at the size you choose. Text that doesn't fit is set smaller or a long line is broken in two, and the page tells you how many labels that changed and which rows still have too much text. Skip the labels already used on a partly used sheet, print several copies of each label, and preview every sheet before you download the PDF.

Label positions come from each sheet's published template, to within a tenth of a millimetre, and the PDF is exactly the paper's size with nothing scaled. Most label trouble comes from the print dialog, so the PDF asks it not to scale the page, and the test page lets you check on plain paper before using a label sheet. Word's mail merge or a Google Docs add-on can do this too if you have them set up; this page needs neither, and the list stays on your device. To turn a CSV list into Excel or back, use CSV to Excel; to cut marketplace shipping labels out of a PDF, use the Shipping label crop.

Questions

How do I print address labels from Excel?

Open the Excel file (or a CSV) on this page, check the label lines it guessed from your column names, such as {First Name} {Last Name} on the first line and {City}, {State} {ZIP} on the last, and pick your label sheet, for example Avery 5160. Download the PDF and print it at 100% or Actual size onto the label sheets. There is no mail merge to set up and no Word needed.

Does this work like the Avery 5160 template?

Yes. The PDF puts 30 labels on a US Letter sheet, 3 across and 10 down, each 2⅝ × 1 inches, with the same 0.5 inch top margin and spacing as Avery's own 5160 template. Sheets with the same layout, such as 8160, 5260, 5960 and 18160, print the same way. The page also has 5161, 5162, 5163, 5164 and 5167, the A4 sheets L7160, L7159, L7161, L7163, L7173 and L7165, and any other sheet whose measurements you type in.

Why don't my labels line up when I print them?

Usually the printer scaled the page: choose 100% or Actual size, not Fit to page, and the right paper size, Letter or A4. Print the test page on plain paper first: its ruler line shows whether the page was scaled, and holding it against a label sheet shows where the text lands. If every label is off by the same amount, move everything right or down by that much, and the page keeps the setting in its address for next time.

Is my address list uploaded anywhere?

No. The spreadsheet is read and the PDF is made in your browser, so the names and addresses on your list never leave your device: not to kitkeeps, not to a label maker's website and not to a spreadsheet add-on. Nothing is kept once you close the page, and the page address holds only the label sheet and print settings, never the list.

Limits

The labels are plain text in one font, Liberation Sans (it measures like Arial), regular or bold: no pictures, logos, barcodes or colours. Latin, Greek and Cyrillic letters are real text in the PDF; other scripts, such as Chinese, Arabic or Hindi, print as sharp pictures of the text instead. A list can make up to 30,000 labels at once. Sort or filter the rows in your spreadsheet first; this page prints them in the order they come.

It reads .xlsx and .xlsm workbooks and CSV or TSV files, not old .xls, .ods or .numbers files: save those as .xlsx or CSV first. Formulas show the value the spreadsheet last saved. The sheet measurements were checked in the PDF against the published templates, not on every brand of label paper, and printers can feed paper a millimetre or so off, which is what the test page and the nudge are for.

Privacy

This tool runs entirely in your browser. The files you open and what you type are never sent to a server, and nothing is stored after you close the page. See the privacy page.

Related tools