Label Sheet Maker with CSV Mail Merge

What it is for

You have a list — addresses, jars, asset numbers, conference names — and a pack of label sheets. This tool merges CSV rows into a label template and lays the labels out on the sheet, as a true-size PDF with SVG and PNG previews. Each label can also carry its own QR code, Code 128 or EAN-13 barcode built from the row.

Sheets are chosen from generic layouts named only by their measurements (for example A4 · 3 × 8 · 70 × 37 mm) or entered by hand. The tool does not know brand product numbers; read the measurements from your package.

Worked example

The default run uses the A4 · 3 × 8 · 70 × 37 mm sheet and two address rows. The template {Name} / {Street} / {Postcode} {City} fills 2 labels on 1 sheet with 24 positions; no text was cut.

The jam-jar example uses the A4 · 3 × 7 · 63.5 × 38.1 mm layout, a CSV with the columns Product, Date and Code, the text {Product} / Best before {Date} and QR code with the code content {Code}. It starts at label 4, because the first three labels of the sheet were used before: 2 labels, 21 per sheet, each with its own QR code linking to the product page.

For name badges we entered custom measurements: 2 × 3 labels of 90 × 80 mm, top margin 18.5 mm, left margin 12 mm, pitch 96 × 88 mm, centred text at 8 mm. Result: 3 labels on a sheet of 6.

How to read the result

• Labels and CSV records: how many labels were printed and how many data rows were read (copies multiply the rows).
• Labels per sheet and Sheets: the layout; skipped start positions count towards the first sheet.
• Labels with cut text: labels where the text did not fit. Reduce the font size or the number of lines.
• missingFields: placeholders that are not CSV columns — they print literally.
• codeErrors: rows whose code content could not be encoded (for example letters in an EAN-13).
• Open in the app loads the layout into Printshop; the CSV rows are left out of that link for privacy.

Tips and common mistakes

• Print one page on plain paper with outlines and hold it over the label sheet against a window before using the real sheet.
• Pitch is edge-to-edge distance to the next label, not the gap. A 63.5 mm label with a 2.5 mm gap has a 66 mm pitch.
• Column names are case-sensitive: {city} does not match a column City.
• Use startAt for half-used sheets instead of deleting rows.
• Spreadsheets in many European locales export semicolons; the tool detects comma, semicolon and tab.
• Long QR content makes small modules on small labels — keep code text short.

FAQ

How many labels can I print at once?

Up to 5,000 CSV rows; the PDF grows with each sheet.

My text is slightly off on the real sheet. What can I adjust?

Measure the top and left margins of the first label and the pitch on the sheet and enter them as custom measurements. Printers can also shift the page by a millimetre.

Can I use round labels?

Yes — the round 40 mm and 2 in layouts, or tick round in the custom measurements.

Are my addresses uploaded?

The tool runs on the server for API calls; in the Printshop app the merge runs in your browser and share links never contain the rows.