> labels address
Address labels
Paste addresses, choose a sheet, print the PDF. For Christmas cards, invoices and your moving announcement. No mail merge.
A blank line separates the addresses. The lines go on the label the way you set them here.
In Excel or Numbers, select the columns, copy, paste here. Or the content of a CSV file. The first line holds the column names. The tool detects the separator itself.
Column names in curly braces, every line here is one line on the label. If a column is empty, its line is dropped.
Sizes as stated on the package. Margin = from the edge of the sheet to the first label (if left empty: the grid is centered). Gap = distance between two labels, 0 on most sheets. Columns and rows are whole numbers, at most 20 × 40.
This many labels stay empty on the first sheet, counted from the top left.
If an address does not fit, it is set smaller until it does. The preview then tells you.
Paste addresses on the left.
The preview appears right away.
When printing, choose “Actual size” or “100%”, not “Fit to page”. Otherwise the printer shrinks the page a little, and from the second row on the addresses sit next to the label.
Related: Mail merge from the same list (German) · QR code for a bank transfer (German) · Barcode for goods · Business cards
Your addresses stay on this device. The PDF is made here in your browser.
How it works
- 01Type or paste addresses: one per paragraph, a blank line in between. Or copy the table from Excel and set a pattern like “{First name} {Last name}”.
- 02Choose the sheet that is in your printer: width × height and number are on the package. If yours is not there or the sizes differ, enter them under “Custom grid”.
- 03Download the PDF and print with “Actual size”. Try it once on plain paper first.
The sheets. All grids are calculated for A4 and sit in the middle of the page. That way the usual sheets get exactly the margins stated on the package (for example 4.5 mm at the top for 70 × 36 mm). I do not name brands because I cannot check what is in your package: just compare the sizes. The sheet with 65 labels (38.1 × 21.2 mm) is the only one with a gap of 2.5 mm between the columns.
Partly used sheet. If some labels are already gone from last time, enter how many: counting goes row by row from the top left, and the first address then lands on the next free label.
Tables. Columns copied from Excel or Numbers come with a tab, CSV files with a semicolon or comma. The tool detects that. Values in quotation marks may contain separators. The pattern says which column goes where: “{Postal code} {City}” puts both in one line. If the tool recognizes column names such as First name, Last name, Street, Postal code, City, it suggests a pattern. Columns such as email or phone are left out. It also uses exactly these known names to decide whether the first line is column names at all. If your columns are named differently, it takes the first line for an address and prints it too. Then you flip the switch “First line is column names”.
Font and characters. The text is set in Helvetica, the standard font of every PDF. It does not have to be embedded, so the file stays small. Umlauts, ß, é, ñ, ø and the euro sign work. Letters from other Latin spellings (ł, ș, ğ) become the nearest base letter. The font cannot show emojis and other scripts (Cyrillic, Greek, Arabic) and leaves them out. The preview shows both so you know beforehand. The same applies to the sender, where the note is at the field. If an address does not fit on its label, it is set smaller step by step down to 5 pt. If even that is not enough, lines are missing, and that is noted too.
Limits. Only A4, only portrait, one font, no images or logos on the labels. Whether your printer hits the labels at exactly the right spot depends on its feed accuracy. Half a millimeter of offset is normal, which is why every label has some space inside to the edge.