Label Sheet Maker (A4/Avery and thermal labels)

About the Label Sheet Maker (A4/Avery and thermal labels)

Design one label for a whole sheet of copies — or one label per row of a spreadsheet. Choose a US Letter sheet (Avery 5160 and other common Avery layouts), an A4 sheet (21, 24, 65 and the other usual sizes per sheet), a thermal label roll (50 × 25 mm, 4 × 6 in and more) or measure your own layout. Put up to six lines of text on it, with {Column} placeholders filled from each row of a CSV or Excel file, an optional logo and an EAN-13, UPC-A, EAN-8, Code 128 or QR code.

One label per row, a fixed number of copies, or the copies from a column of the sheet; numbered series for roll numbers and tickets; a start position for a part-used sheet; and a test page that shows exactly where every label prints, with offsets to correct your printer. In the free preview the sheets show as page images marked “MySmartCoPilot preview · not for use”, with every barcode made unscannable; a Premium pass unlocks the print-ready PDF. Your rows never leave this browser.

Common uses

• Shops printing shelf and price tags with barcodes for their own items.
• Online sellers printing SKU labels for stock bins and products on a thermal printer.
• Offices and societies printing address labels for letters and parcels from a member list.
• Laboratories and clinics labelling sample tubes with a sample number and a Code 128 barcode, without patient names.
• Schools printing roll-number labels for desks, answer sheets and notebooks.

Where the sheet sizes come from

The US Letter layouts follow Avery’s own template files (for example Avery 5160): where the first label starts, the label size, the distance to the next label and the corner radius. The A4 layouts use the measurements a UK label maker publishes for its A4 label templates. Sheets of the same size from different brands can differ slightly, and every printer shifts its print a little, so print the test page on plain paper first, hold it against a sheet of labels in front of a light and correct the offsets.

Barcodes for products

EAN-13 (and UPC-A in the US and Canada) is the barcode scanned at checkouts. The GS1 General Specifications ask, for retail point of sale, for bars at least 0.264 mm wide (0.330 mm at the nominal size, at most 0.660 mm) and, at the nominal size, 22.85 mm tall — shorter bars may not scan on scanners that read from any angle. The tool sizes the barcode to the room on the label and warns when it is smaller than that.

• Type 12 digits and the check digit is added; type 13 and it is checked.
• Product numbers (GTINs) for goods sold through other shops come from GS1. GS1 keeps the prefixes 20 to 29 for restricted-circulation numbers, whose use each country’s GS1 office defines.
• Code 128 holds letters, digits and keyboard symbols: SKUs, bin locations and sample numbers. QR codes hold links and longer text.

Printing so the labels line up

• Print the PDF at Actual size or 100%: “Fit to page” shrinks it and moves every label.
• Feed one sheet at a time and use the paper type the label pack recommends.
• If every label is off in the same direction, change the offsets (in millimetres: positive moves the print right and down).
• On a part-used sheet, set Start at label to the first unused position (counted left to right, top to bottom).
• Thermal printers: set the label size in the printer’s driver to the label size, and pick 203 or 300 dpi under Printer resolution so the barcode bars land on whole printer dots.

Limitations

• Up to 10,000 labels and 5,000 spreadsheet rows go into one PDF; split bigger jobs.
• Text in Latin scripts and Devanagari is embedded in the PDF as text; lines in other scripts are drawn with this device’s fonts as pictures, which print well but cannot be selected.
• GS1-128 barcodes with application identifiers (batch, expiry) are not made here; use the barcode generator for those and for single barcodes.
• The tool checks the barcode’s digits and size; it cannot check that a product number was really issued to you.

Privacy

Your spreadsheet is read in this browser and never uploaded. The design you are working on, the designs you save and — if you tick it — a small sheet are kept in this browser’s storage on this device.