FREE · NO SIGNUP

URBANKIT/STUDIO · EST. 2026 · ONLINEFREE · BROWSER-ONLY · NO TELEMETRY · OPEN SOURCE

TOOL·002·CSV → AVERY 5160

Spreadsheet in,
print-ready labels out.

Upload any CSV mailing list — exported from Excel, Google Sheets, or your county's assessor portal. Map columns once, dedupe automatically, walk away with a 30-up Avery 5160 PDF that lines up on the first sheet.

Format

Avery 5160 · 30/sheet

Per Label

1″ × 2⅝″

Dedup

Automatic

Status

Upload a CSV to generate labels.

Upload CSV

Column mapping

Minimum required: Address 1

Name (line 1)

Address 1

Address 2

City

State

ZIP

Unique labels: 0

Preview

Upload CSV and map columns to see preview.

Quick Tips

Make sure your CSV has a header row.
Address 1 should be a street address (line 2 on the label).
If you already have a pre-formatted "City, ST ZIP" column, set it as City and leave State/ZIP blank.

How to Create Mailing Labels from a CSV

Step-by-Step Guide

Prepare your CSV file — Ensure it has a header row with column names like "Name", "Address", "City", "State", "ZIP"
Upload the file — Click "Upload CSV" and select your file
Map your columns — Match each dropdown to the corresponding column in your data
Review the preview — Check that labels look correct (first 10 shown)
Export — Download as CSV for mail merge, or as a print-ready Avery 5160 PDF

What are Avery 5160 Labels?

Avery 5160 is the most popular mailing label format in the United States. Each 8.5" × 11" sheet contains 30 labels arranged in a 3×10 grid. Individual labels measure 1" × 2⅝" (25.4mm × 66.7mm).

These labels work with both inkjet and laser printers and are available at any office supply store. Generic "5160-compatible" labels work identically and are often more affordable.

Common Use Cases

Public notice mailings — Notify property owners of zoning hearings, variances, or permits
Bulk mail campaigns — Send newsletters, announcements, or marketing materials
Event invitations — Address wedding invites, party announcements, or reunion letters
Holiday cards — Quickly address annual greeting cards from your contact list
Business mailings — Invoices, statements, catalogs, or promotional materials

Quick FAQs

What CSV format is required?

Standard comma-separated values with a header row. UTF-8 encoding is recommended. Most spreadsheet exports (Excel, Google Sheets) work out of the box.

Does this upload my data anywhere?

No. All processing happens in your browser. Your data never leaves your computer—we don't store or transmit any information you upload.

How do I print the PDF correctly?

Print at "Actual Size" (100%)—do not select "Fit to Page" or any scaling option. Use US Letter paper (8.5" × 11"). Test on plain paper first by holding it up against a label sheet.

What if I have duplicate addresses?

Our tool automatically deduplicates addresses before generating labels, so you won't waste labels or postage on duplicates.

View all FAQs →

Spreadsheet in,print-ready labels out.