Skip to content

Menu

Avery 5160 template

You do not need a Word or Google Docs template: paste your list or open a CSV or .xlsx file, and Picket prints it onto Avery 5160 labels (1" × 2⅝", 30 per US Letter sheet) already lined up to the sheet, as address labels or with a barcode. The same layout fits 8160, 18160, 5260, 5960 and the other 30-up 1" × 2⅝" sheets, and you can start on any label of a used sheet. It is free up to 100 labels per PDF with no sign-up; Pro (US$5 a month) prints up to 5,000 without the credit line in the margin. The layout is fixed: up to five left-aligned lines of text per label, with no logos, pictures or font choices.

  • 30 labels per sheet
  • Excel, CSV and Google Sheets
  • Nothing uploaded
Picket · Avery 5160 template
Paste a column or a table from Excel or Google Sheets, or type one value per line.

Turn off for address, name and file labels with text only.

For example New, a price or your shop name.
Quantity column: whole numbers 0–1000; 0 skips the row, blank uses the default.
1" × 2⅝", 30 per sheet. Also 5260, 5520, 5660, 8460, 18160 and the other 5160-family numbers. Address labels and Amazon FNSKU labels (30-up).
1 to 30, counting across then down. For a half-used sheet.

Print one sheet on plain paper first and hold it against a label sheet to check the fit.

Sample data · 0 labels on 1 page
Loading the barcode engine…

Print at Actual size (100%), not Fit to page, so the labels line up. Free PDFs carry a small credit line in the bottom margin.

Made in your browser with bwip-js and fflate; nothing you enter is uploaded. Open-source licenses

How to use the avery 5160 template

  1. 01

    Paste the addresses

    One address per row with the name, street and city in separate columns, from Excel, Google Sheets or a CSV file. A header row is detected automatically.

  2. 02

    Check the lines

    Each column becomes a line on the label. Turn on Print a barcode to make product, SKU or FNSKU labels instead.

  3. 03

    Print at Actual size

    Download the PDF and print it on Avery 5160 at Actual size or 100%. Try one page on plain paper first and hold it against a label sheet.

Questions

What are the Avery 5160 measurements?

Each label is 1" × 2⅝" (25.4 × 66.7 mm), 3 across and 10 down on US Letter. The top and bottom margins are ½", the side margins 3⁄16" and the gap between the columns ⅛", so the labels start 2¾" apart across and 1" apart down.

Is Avery 8160 the same as 5160?

Same size and layout: 5160 is made for laser printers and 8160 for inkjet, and 18160, 5260, 5960 and the other 30-up 1" × 2⅝" sheets share the template. Choose Avery 5160 / 8160 / 5960 for any of them.

Why not use the Word or Google Docs template?

A Word or Google Docs template needs a mail merge to fill 30 labels from a list. Here you paste the list and download a PDF that already fits the sheet. If you need your own fonts or a logo on the label, the template in Word is still the better tool.

Why do my labels not line up?

Print at Actual size or 100%, not Fit to page, and pick the exact sheet number printed on the label pack. Turn on Outline each label and print one page on plain paper first to check against the sheet.

Is my data uploaded?

No. Picket makes the barcodes, labels and the PDF in your browser. Your numbers, addresses and spreadsheet never leave your computer.

Do I need an account?

No. Everything on the Free plan works without signing up. You only need an account, with a verified email address, to subscribe to Pro (US$5 a month).

Barcodes and label sheets from a spreadsheet, made in your browser

The Free plan makes single barcodes and up to 100 labels per PDF, with a small credit line in the page margin. Pro is US$5 a month.