Label Sheet Printer
Lays a CSV onto Formtec, AnyLabel or 3M label sheets (or a custom grid) with exact mm positions, a start slot and offset nudges, as a print-ready page.
Printing onto Formtec or AnyLabel sheets fails for one reason: the labels are at fixed millimetre positions and the browser’s “fit to page” moves everything by a few. This lays the grid out in absolute millimetres, offers a nudge for the drift your printer has, and says where its measurements came from.
Data
A CSV of addresses or names
Read in this tab. Nothing is uploaded. Files from Korean, Japanese, Chinese and Western Excel (CP949, Shift_JIS, GBK, Windows-1252) are recognised.
Label sheet
2×8 = 16 per sheet · top margin 12.90mm · left margin 4.65mm · gaps 2.5×0mm · source: formtec.co.kr 제품 목록
Label content
For a part-used sheet
Print (0 labels, 0 sheets)
Load a CSV and the preview appears here.
Set the margins to “none” and the scale to 100% in the print dialog. “Fit to page” shifts every label.
How to use it
Drop the CSV of addresses or names
One row becomes one label. There is a sample you can load if you just want to test the alignment.
Pick the label sheet
The list gives the brand, model and the label size in millimetres. If yours is not listed, type the measurements into the custom option.
Write the line template
Use {{column}} where a value goes. The address and name-badge presets fill it in from the first columns of your CSV as a starting point.
Test print with outlines, then nudge
Print onto plain paper with the outlines on, hold it against a label sheet, and set the horizontal and vertical nudge to match.
Common questions
Everything is shifted by a few millimetres.
Two causes. Set the margins to “none” and the scale to 100% in the print dialog — “fit to page” shrinks the whole sheet. If it is still out, that is your printer’s own drift: use the nudge fields.
Can I start halfway down a part-used sheet?
Yes — set the starting slot and the first labels are left blank. Slots are counted left to right, top to bottom.
Where do the sheet measurements come from?
The label size and count for Formtec LS-31xx, Printec AnyLabel and 3M 21321 come from the manufacturers’ own product lists, and the margins are calculated by centring the grid on A4. Polymail is not included because there is nothing verifiable to take it from — type its measurements in instead.
Feed it from
Barcode Generator
Generates EAN-13, UPC, Code128, Code39 and ITF barcodes with check digits and print-ready output.
Workbook Splitter
Splits a workbook into one file per sheet, or one file per distinct value of a chosen column.
Contact List Converter
Converts between vCard, CSV and Google or Outlook contact exports, merging duplicate entries.
Korean Postcode Search
Looks up the five-digit postcode for a road-name or lot-number address, with a bulk column mode.
Next
These accept what this tool produces, so the result can go straight in.
Barcode Generator
Generates EAN-13, UPC, Code128, Code39 and ITF barcodes with check digits and print-ready output.
CSV Viewer
Opens a large delimited file with type detection, column stats and sorting, without loading it all into memory.
Korean Postcode Search
Looks up the five-digit postcode for a road-name or lot-number address, with a bulk column mode.
Contact List Converter
Converts between vCard, CSV and Google or Outlook contact exports, merging duplicate entries.
CSV to Excel
Writes one or many CSV files into an .xlsx workbook with typed columns, a header row and filters.
Workbook Merger
Combines many workbooks or sheets into one, stacking rows or adding each source as its own sheet.