Skip to content

Avery and address label maker

Addresses or spreadsheets in, an aligned Avery or custom label sheet ready to print.

US Letter · 3 × 10 (30 per sheet) · 2.625 × 1 in · Margins 0.5 in top, 0.188 in side · Also fits 8160, 5260, 5960, 8460, 5520

First sheet. Click a label to start printing there, if some are used.

How to use Label maker

  1. Select your label sheet code. Pick from 27 US Letter or A4 presets using Find by code or size, or switch to Custom size for non-standard packs.
  2. Add your label text. Choose Type a list with blank lines between addresses, From a spreadsheet for Excel or CSV mail merge, or Same on every label for return stickers.
  3. Skip used cells if needed. Click any remaining blank sticker in the First sheet preview so printing begins at that exact cell.
  4. Adjust layout and test-print. Set Align, Text size, First line in bold, or Draw label outlines, then download the PDF and print at 100% Actual size.

Everything you type stays in this browser on your device. Nothing is uploaded, and your saved details are never sent anywhere.

Sheet presets, custom grids, and three label input modes

Matching a physical sticker pack starts with exact page geometry rather than guesswork. Every preset uses published US Letter (8.5 by 11 inches) or A4 (210 by 297 mm) coordinates converted at 72 points per inch, following the fixed-scale coordinate model in the Library of Congress PDF 1.7 (ISO 32000-1) Format Description.

Matching 27 US Letter and A4 Avery packs or building a custom grid

Use Label sheet or type into Find by code or size to filter 27 built-in die-cut templates, including 5160, 8160, 5163, 5167, L7160, L7163, and L7651. Selecting a preset updates the grid summary and interactive sheet map immediately.

When store-brand packs use non-standard spacing, choose Custom size from the dropdown. You can define paper size, columns across (1 to 50), rows down (1 to 100), label width, label height, and horizontal or vertical pitch in inches or millimeters.

Choosing Type a list, From a spreadsheet, or Same on every label

Pick Type a list when pasting quick addresses separated by a single blank line. For recurring return stickers or jar labels, switch to Same on every label and set How many from 0 (fill the remaining sheet) up to 5,000 labels.

For larger parcel runs that need separate sender and recipient blocks on 4 by 6 or 4 by 2 layouts, you can print full parcel labels with a return address instead of standard address grids.

Comparing US Letter and A4 Avery label dimensions

Regional paper standards dictate which template family fits your printer tray. US Letter sheets measure 612 by 792 points, while A4 sheets measure 210 by 297 mm, so mixing regional codes shifts every margin.

Horizontal and vertical pitch define the exact distance from the left or top edge of one sticker to the same edge of the next sticker. Most sheets include small gutters between columns, while some rows sit flush against each other with zero vertical gap.

Sheet code Paper standard Grid (Cols × Rows) Labels per sheet Label size Horizontal pitch
5160 / 8160 US Letter 3 × 10 30 2.625 × 1 in 2.75 in
5163 / 8163 US Letter 2 × 5 10 4 × 2 in 4.1875 in
5167 / 8167 US Letter 4 × 20 80 1.75 × 0.5 in 2.05 in
L7160 / J8160 A4 3 × 7 21 63.5 × 38.1 mm 66.04 mm
L7163 / J8163 A4 2 × 7 14 99.1 × 38.1 mm 101.6 mm
L7651 / J8651 A4 5 × 13 65 38.1 × 21.2 mm 40.64 mm

If you are printing shelf-edge retail pricing rather than mailing addresses, switch to the browser-based retail price tag maker for perforated price card grids.

Why do printed address labels drift out of alignment?

Printer drivers frequently apply automatic margins or Fit to page scaling that shrinks a full-page PDF by 2% to 4%. Over 10 vertical rows on US Letter or 7 rows on A4, that small percentage compounds into several millimeters of upward drift by the bottom sticker.

Preventing Fit to page scaling errors across 10-row sheets

Always set your browser or PDF viewer print dialog to 100% or Actual size before feeding adhesive sheets. Disable any borderless or shrink-to-fit checkboxes, and verify that the printer tray paper size matches your selected US Letter or A4 sheet.

When CSV mailing lists contain street addresses with commas or apartment units, quoting rules under the IETF RFC 4180 Common Format for CSV Files keep each field aligned to the right column during import.

Testing on plain paper and applying 0.5 mm fine-tune nudges

Tick Draw label outlines and print one copy on ordinary office paper first. Hold that test sheet over a blank sticker sheet against a window to inspect cell alignment across all four corners.

If mechanical tray rollers pull every row slightly left or high, open Fine-tune position and enter positive or negative offsets in Right (mm) and Down (mm) in 0.5 mm steps. For full-page correspondence using the same CSV or Excel list, you can generate full-page personalized PDF letters from the same spreadsheet.

Spreadsheet mail merge formatting and local privacy

Mail merge templates use {Column} placeholders inserted directly from your uploaded spreadsheet header row. Text sizes range from 8 to 24 pt, and long lines automatically scale down to prevent clipping outside the sticker boundary.

Collapsing missing apartment lines and handling Western Latin fonts

When a row leaves an optional {Address2} or {Company} cell blank, the template parser removes that empty line instead of printing a blank gap. Enable First line in bold and toggle Align between Left and Centre to emphasize recipient names.

Excel workbooks follow the ZIP-compressed XML structure described in the Library of Congress Office Open XML (.xlsx) Format Description, allowing the worker to extract rows locally. If you also need event passes from the same spreadsheet, open the Name badge maker for lanyard-ready layouts.

Tip: Click any cell on the First sheet diagram to skip already-peeled stickers on a partial sheet, saving expensive label stock without re-indexing your spreadsheet.

Keeping customer mailing lists inside browser memory

Spreadsheets, typed addresses, and rendered PDF bytes stay inside your local Web Worker with 0 bytes transmitted over the network. Once downloaded, closing the browser tab clears your mailing list from memory immediately, making the workflow safe for private customer directories and donor rosters.

Questions

Why do printed address labels drift out of alignment?

Most alignment drift happens when a PDF viewer or printer driver defaults to Fit to page or Shrink to fit instead of 100% Actual size. Even a 2% scale reduction compounds across 10 rows on US Letter or 7 rows on A4, shifting bottom labels upward. Print one test sheet on plain paper and use Fine-tune position in 0.5 mm steps if your paper tray feeds slightly off-center.

How do I print labels from Excel without Microsoft Word?

Switch Where the text comes from to From a spreadsheet and choose your .xlsx, .csv, or .tsv file directly in the browser. Click the detected column buttons to arrange placeholders like {Name} and {Street} inside Layout. The worker merges every row locally into an aligned PDF without opening Word or uploading your mailing list.

Can I print on a partially used Avery label sheet?

Yes. Look at the First sheet preview diagram and click the first remaining blank sticker cell on the page. Every cell before your selected start position is skipped, letting you finish partially peeled sheets without wasting sticker stock.

What is the difference between Avery 5160 and L7160?

Avery 5160 fits US Letter paper (8.5 by 11 inches) with 30 labels arranged in 3 columns by 10 rows, measuring 2.625 by 1 inches each. Avery L7160 fits A4 paper (210 by 297 mm) with 21 labels arranged in 3 columns by 7 rows, measuring 63.5 by 38.1 mm each.

What happens if an apartment or second address line is empty in my spreadsheet?

Empty placeholder lines collapse automatically during mail merge so your labels never show awkward blank gaps between the street and city. You can inspect the result directly in the First sheet SVG preview or Full preview link before downloading the final PDF.

Are non-Latin characters supported in the exported label PDF?

The built-in PDF Helvetica font covers the Western Latin character set. Any character outside that set is replaced with a question mark, and the result summary reports the exact count of replaced characters so you can spot and adjust unsupported symbols before printing.

Updated