“Word only filled in the first label.”
Mail merge, merge fields, Next Record, Update Labels: if you only do it once a year, you start from scratch every time.
With the tool: Choose the list, choose the sheet, done. Every address gets its own label.
ADDRESS LABELS · AVERY SIZES · NO UPLOAD
Drop in your address list, choose your label sheet and print the PDF. Every label lines up, even on a partly used sheet. No Word mail merge, free and without upload.
You addYour address list from Excel, one row per address
You getA print ready PDF that fits your label sheet
Drag an Excel, CSV or PDF file here, or choose one.
Excel (XLSX, XLS, ODS), CSV or a PDF with a table. Up to 5 MB, 10 MB for PDF, and up to 20,000 rows.
SOUND FAMILIAR?
“Word only filled in the first label.”
Mail merge, merge fields, Next Record, Update Labels: if you only do it once a year, you start from scratch every time.
With the tool: Choose the list, choose the sheet, done. Every address gets its own label.
“Everything is three millimetres off.”
The printer quietly shrinks the page to fit, and the bottom row ends up on the edge.
With the tool: The PDF has the exact size of your sheet. The test page lets you check it on plain paper first.
“Half a sheet is left over from last time.”
Partly used sheets usually end up in the bin, because Word always starts at the top left.
With the tool: You enter the first free label and printing starts right there.
The tool recognises company, name, street, postcode and town by the column headings and puts the address together the way it belongs on a letter. The country only appears for addresses abroad, in capitals. Long company names wrap instead of becoming tiny.
The common A4 address label sheets: 70 × 37, 70 × 36, 70 × 35 and 70 × 42.3 mm, 99.1 × 38.1 and 63.5 × 38.1 mm, and 105 × 57 mm. Sheets from other brands with the same sizes fit just the same. For anything else, enter the sizes from the pack under Other size.
Almost always because the printer scales the page to the paper. In the print dialog choose Actual size or 100 %. Print the test page on plain paper first and hold it against the label sheet.
Yes. Under Start at label, enter the number of the first free label. Labels are counted row by row from the top left, so on a sheet of 24 the first row is 1 to 3.
One row per address and headings such as Company, First name, Last name, Street, Postcode, Town and Country. Other names and extra columns are fine. Anything that is not recognised you assign yourself under Match the address fields. Excel, CSV, OpenDocument and PDFs with a table are read.
Excel likes to turn 01067 into 1067. For German addresses the tool adds the zero back. Austrian and Swiss postcodes have four digits and stay as they are. Old forms like A-1010 or D-80331 are recognised: the plain postcode is printed, and the country goes on the last line where needed.
Only for addresses abroad, in capitals on the last line. Codes like AT or DE are written out as ÖSTERREICH or DEUTSCHLAND, the form the Austrian and German post expect. The country where most addresses in your list are is left out. If the Country column is only filled in for addresses abroad, the tool recognises your country by the postcodes: five digits for Germany, four for Austria.
No. The file is processed right in your browser. Contents and results are not sent to our server. Visiting the website itself creates the usual technical connection data.
LET'S TALK ABOUT YOUR WORKFLOW
A question, an idea or a task that costs time every week? A few sentences are enough. You get an honest answer from the people who also build your office helper.
Ivan, Lukas & JanReply within 1–2 working days
