Free label maker for Avery 5160 and 904 other label sheets

How mail merge works here

Choose One label per row (mail merge) and paste your list straight from Excel, Google Sheets, Numbers or a comma-separated text file. The tool detects tabs, commas, semicolons and quoted fields on its own, and treats the first row as column names when it looks like one (Name, Street, City…). Each remaining row becomes one label, in the order of your list, filling the sheet left to right and top to bottom like Word and Avery do.

Instead of pasting you can press Open a file and pick a .csv or .txt export; files saved by Excel on Windows in the older Western encoding keep their accents. With Pro, an Excel .xlsx workbook opens directly: the first worksheet becomes the list, ZIP codes formatted as 00000 keep their leading zero, and dates are flagged because Excel stores them as day numbers. When the column names look like an address list (First Name, Last Name, Address, City, State, Zip and similar), the label layout is filled in from them, so the preview shows your own addresses at once.

Rows with an empty column close up: if a contact has no second address line, that line is dropped instead of leaving a gap. When the list is longer than a sheet, the status line tells you how many sheets the whole job needs; the free PDF holds the first full sheet and Pro puts every row in one file.

Column placeholders

Type a column name in curly braces to pull its value: {Name} on the first line, {Street} on the second and {City}, {State} {ZIP} on the third gives a classic US address label. Names are not case-sensitive, and a placeholder without a matching column prints empty (the status line warns you). Click a column chip under the paste box to insert it at the cursor. Plain text mixes freely with placeholders, so “Happy holidays, {First}!” works too.

Print at 100 %, on the right paper

The PDF uses the sheet's own paper size: US Letter (8.5 × 11 in), A4 (210 × 297 mm), A5 (148 × 210 mm) or A6 (105 × 148 mm). Every label sits where the gLabels template database places it; 114 sheets, the most-used codes among them, are also checked against the manufacturer's published size. In the print dialog choose Actual size or 100%; “Fit to page” shrinks the page by a few percent and the text creeps off the labels towards the bottom. Printing a Letter sheet on A4 paper (or the other way round) shifts everything too, so match the paper setting to the sheet.

Alignment test and printer offset

Before using an expensive sheet, download the alignment test sheet and print it on plain paper. It draws every label outline with its number, plus a 1-inch and a 25 mm ruler: if a ruler measures short, the printer is still scaling. Hold the test page over a label sheet against a window. If all outlines are off by the same amount, enter that shift under Printer offset (positive values move everything right or down, in millimetres) and the next PDF is nudged to match your printer.

The blank template PDF of each sheet is a static file with the label outlines and the size printed in the margin, handy if you design in another program and only need the layout.

What Pro adds

Free covers one full sheet per PDF with every design option. Pro is an unlock ($19 one-time, no subscription) for bigger jobs and repeat batches. Everything below works in the tool today:

• Unlimited mail merge rows and sheets. Every row of your list prints, over as many sheets as it needs (the free plan merges one full sheet).
• Open .xlsx files directly. Pick an Excel workbook and its first sheet becomes your list, no copy and paste.
• QR codes and Code 128 barcodes. Fill a QR code or barcode on every label from a column or from the serial number.
• Serial numbering. A running {Serial} number with your prefix, start, step and zero padding.
• Your logo or image on every label. Place a PNG or JPEG logo on each label; it stays in your browser.
• Saved designs. Keep your label designs in this browser and reuse them for the next batch.
• Saved printer calibration. Store the printer offset you measured with the alignment test so every PDF prints straight.
• No credit line. PDFs without the small "made with LabelGrid" line in the sheet margin.