Avery® 5160®, 8160®, 5163®, L7160® and more
Avery®-Compatible Labels from Excel and Google Sheets
Create Avery®-compatible address labels, shipping labels, name badges, barcode labels, and custom sheets from Excel, CSV, or Google Sheets. Pick the layout, preview the sheet, and export a PDF that is ready to print without setting up Word mail merge.
Independent Avery®-compatible workflow. Not affiliated with Avery Products Corporation.
Watch: Make Avery®-Compatible Labels from Excel or Google Sheets
See how to turn spreadsheet rows into Avery®-compatible label sheets, preview the full page, and export a PDF for 100% scale printing without setting up Word mail merge.
Watch: Make Avery®-Compatible Labels from Excel or Google Sheets
Avery®-compatible labels from spreadsheets, without the Word mail merge setup
Use the spreadsheet you already have. Import rows, map columns into text, barcode, QR, or image fields, choose the matching Avery®-compatible sheet, and preview the full PDF before label stock goes into the printer.
Avery®-compatible labels from Excel
Upload an .xlsx file, map columns such as name, address, SKU, barcode, or quantity, and generate one label per spreadsheet row.
Avery®-compatible labels from Google Sheets
Paste a shared Google Sheets link or export your sheet as CSV when the live list is maintained in Drive.
Avery® 5160® from Excel
Choose the 5160-compatible 30-up US Letter layout for common address-label jobs, invitation lists, return labels, and CRM exports.
No Word mail merge required
Skip table templates, merge fields, and Next Record rules. The editor repeats your finished label across the selected sheet layout.
Popular Avery®-compatible label layouts
Start with the product code on your label package. If your exact code shares the same sheet size, rows, columns, margins, and gaps, the compatible layout will print the same way.
Avery® 5160® / 8160®
30 address labels per US Letter sheet. Best for mailing lists, invitations, and return labels.
Avery® 5163® / 8163®
10 larger labels per sheet for shipping, storage, product, and operations labels.
Avery® 5161®
20 labels per sheet when you need a wider address or product label format.
Avery® 5162®
14 labels per sheet for larger mailing blocks, badges, and longer text.
Avery® 5164®
6 larger shipping or organization labels per US Letter sheet.
Avery® 5195®
Name badge and event label layouts for attendee lists, classrooms, and check-in tables.
Avery® L7160®
A4 address label layout for UK, EU, and international label stock.
Custom sheet layout
Set your own label size, margins, gaps, rows, and columns when the package code is not listed.
Everything starts from the sheet you already have
Bring the list, choose the label stock, and let the editor repeat the design across the page. This keeps the workflow simple for one-off mailings and repeat batches.
Address labels
Print recipient labels from contact lists, wedding guest lists, CRM exports, or school rosters.
Barcode and QR labels
Turn SKU, asset, product, or URL columns into scannable labels on Avery®-compatible sheets.
Name badges
Create badge sheets from attendee names, class lists, volunteer rosters, or event registrations.
Shipping and storage labels
Use larger sheet labels for boxes, inventory bins, product packaging, and back-office jobs.
From spreadsheet to Avery®-compatible PDF in three steps
Keep the process practical: match the layout code, load real rows, then test the PDF before using label stock.
Step 1: Choose an Avery-compatible layout
Open the template gallery and choose the layout that matches your label package. For first-time users, a standard address label sheet is the easiest place to begin because it clearly shows how names and addresses repeat across the page.
Step 2: Import one row per label
Click Edit Data to open the Data Manager. Import Excel, CSV, XML, or Google Sheets data, paste rows, or add rows manually. A practical address sheet usually includes Full Name, Company, Address Line 1, Address Line 2, City, State, ZIP, and Country.
Step 3: Design one label
Use Single View to build the label itself. Add text, barcodes, QR codes, shapes, or images, then adjust position, size, font, color, alignment, borders, and spacing from the sidebar.
Step 4: Connect fields to columns
Select each element and decide whether it should show fixed content or data from a column. Static text repeats on every label. Dynamic fields change for each row, such as name, address, SKU, price, barcode value, QR URL, or image URL.
Step 5: Preview the full sheet
Switch to Print Layout or Sheet View to confirm how the design repeats across the page. Check paper size, label size, rows, columns, margins, gaps, page orientation, and start position.
Step 6: Export the PDF and print
When the sheet preview looks correct, click Export PDF to generate the final file. Print a test page first, then print at 100% scale or Actual Size so the labels stay aligned with the sheet.
Avery®-Compatible Label Maker FAQ
Quick answers before you print on real label stock.
Still have questions?
If you couldn't find the answer you're looking for, please feel free to ask us!
Make one test sheet before you print the batch
Import a few real rows, choose the matching Avery®-compatible layout, export a PDF, and check alignment at actual size.