Import your file, build your label from the columns you choose and print one label per row, on any label sheet.
Each row of the file will produce one (or more) labels. The first row should contain the column names (Name, Address, City…). The file is read in your browser: it is never uploaded to a server.
Type the product code printed on the box (for example 5160, L7160, J8163): the dimensions fill in automatically. Otherwise, measure one label and enter them by hand.
For each line of the label, choose a column from your file, the text size and its position. You can put two fields on the same line (for example city and ZIP code).
This tool replaces Word's mail merge for labels: it reads your Excel spreadsheet (or LibreOffice, or CSV) directly and produces one label per row. Use it for address labels for a mailing, product and price labels, jar labels, file folders and binders, moving boxes or name badges.
| Code | Labels | Size |
|---|---|---|
| L7160 / J8160 | 21 per A4 sheet (3 × 7) | 63.5 × 38.1 mm |
| L7159 / J8159 | 24 per A4 sheet (3 × 8) | 63.5 × 33.9 mm |
| L7163 / J8163 | 14 per A4 sheet (2 × 7) | 99.1 × 38.1 mm |
| L7165 / J8165 | 8 per A4 sheet (2 × 4) | 99.1 × 67.7 mm |
| L7651 / J8651 | 65 per A4 sheet (5 × 13) | 38.1 × 21.2 mm |
| 3475 / 3490 | 24 per A4 sheet (3 × 8) | 70 × 36 mm |
| 3427 | 8 per A4 sheet (2 × 4) | 105 × 74 mm |
| 5160 / 8160 | 30 per US Letter sheet (3 × 10) | 66.7 × 25.4 mm (2⅝ × 1 in) |
Other common codes (L7161, L7162, L7166, L7169, L7173, L7654, L7167, L7168, 3422, 3474, 3652, 3425, 3483, 3478, 5161 to 5164, 8161 to 8164…) are recognized too. Codes starting with J (inkjet) have the same dimensions as their L (laser) equivalents.
No. The file is read and laid out directly in your browser. No data (addresses, names, prices…) ever leaves your computer.
Excel workbooks (.xlsx, .xls, .xlsm), LibreOffice / OpenOffice (.ods) and CSV files separated by commas or semicolons.
First check that the scale is set to 100% and the margins to “None” in the print dialog. If a small offset remains, untick “Center the labels on the sheet automatically” in step 2 and adjust the top or left margin by a few tenths of a millimeter.
No: the “Hide empty lines” option (on by default) removes the space of a line whose cell is empty, so the address stays compact.
Yes. In a field's drop-down menu, choose “Free text” to write the same text on every label, or fill in the “Text before” box to put something in front of a column's value (for example “Ref.” before a product code).
No. In step 4, give your layout a name and click “Save”: the label sheet and label content are kept. Next time, choose this configuration in step 1 before opening the new file, then click “Go straight to printing”. Only the data changes; the file just needs the same column names (their order can change). If you have only one configuration for these columns, “Automatic” mode recognizes it on its own.
Configurations are saved in your browser and stay available from one day to the next, even after you close it. They are lost in private browsing or if you clear the site's data; Safari (Mac, iPhone, iPad) may also delete them after 7 days without a visit.
To be sure to find it months from now, bookmark the page right after saving the configuration (Ctrl+D): the bookmark contains the configuration, and opening it restores it, in any browser. You can also send this link to a colleague. The settings are written into the link itself, after the # sign, a part of the address that is never sent to our server. Another option: “Download” creates a small .json file, which you open again with “Import a configuration file” in step 1.
With your consent, cookies may be used to show ads (Google AdSense). You can accept or refuse; you can change your choice at any time. Learn more