How to print labels from Excel, step by step

Import CSV, XLS or XLSX and select the real data range

1. Open LabelFlow Pro and choose Data → Load Data (Excel/CSV).
2. Select the worksheet that contains the label records—not the Instructions sheet in the sample.
3. Leave First row is headers enabled when row 1 contains field names.
4. Set Header Row, Start Row and, when needed, End Row. Use the preview table to confirm that headers and values line up.
5. Choose Confirm Data Mapping.

Configure physical label dimensions and DPI

Open Project Settings and enter the physical width and height printed on the label roll or sheet specification. Choose millimetres or inches, then match the printer resolution—commonly 203, 300 or 600 DPI. The sample project uses 76 × 50 mm at 203 DPI.

• For thermal rolls, the project size and printer-driver stock size must match.
• For A4 or Letter sheets, the individual label size, gaps, margins and page size all affect alignment.
• Do not compensate for a driver scaling problem by distorting the label design. Keep browser and driver scaling at 100% or Actual Size.

Bind text, barcode, QR and image elements to spreadsheet columns

Open the Data sidebar after import. Add or select a label element, then use the corresponding spreadsheet field as its dynamic value.

• Text: combine fixed words and fields, such as Batch: {{Batch Number}}.
• Barcode: select the required format and bind the content to a field such as {{Barcode}}. LabelFlow Pro exposes 23 selectable code types; the source value must still be valid for the chosen symbology.
• QR code: bind a URL, identifier or other QR-safe value from a worksheet column.
• Row-specific image: add an Image element and bind it to the column containing the image URL or file path. Test access to every image before a production run.

Choose fixed copies or a different quantity for every row

Return to Data → Data Mapping and choose one of three copy modes:

• 1 Copy Each prints one label for every imported row.
• Fixed Copies repeats every row by the same number.
• Dynamic from Column reads the quantity from a field such as Boxes, Pack, Cartons or Pallets.

In the sample, select Dynamic from Column → Boxes. The preview total changes from four records to ten print labels.

Build multi-field formulas and packaging counters

Choose Formula in the Objects sidebar. Formula Builder can combine fixed text, multiple spreadsheet columns, copy counters and simple numeric expressions in one text object. Start with a preset or enter a formula directly, then use the dry-run values to verify it before insertion.

For the sample, try:

Box {{BOX_NO}} of {{BOX_TOTAL}} — {{Product Name}}

Each copied label receives the current box number and the row total. A dynamic column named Pack, Carton or Pallet also enables the matching natural aliases. Supported helpers include round(), ceil(), floor(), min(), max() and abs(); for example {{ceil(QTY / BOX_TOTAL)}} pcs.

For a focused packaging example, continue with the Box 1 of 10 tutorial.

Preview the records most likely to fail

Use the previous and next record controls above the canvas and the Dataset Preview at the bottom of the editor. Do not review only row 1. Deliberately inspect:

• the longest product or recipient name;
• the longest barcode or QR value;
• a row with an empty optional field;
• values with accents, symbols or non-Latin characters;
• the row with the largest print quantity.

Print thermal labels or A4/Letter sheets—or download PDF

1. Choose Print Labels.
2. Select Thermal for one label per roll position or A4 Sheet for sheet layouts. Letter is available through the sheet page-size controls.
3. Confirm the generated-label total, label dimensions, margins, global copies and print range.
4. Use Print Now to continue through the browser and operating-system print dialog, or Download PDF to save the prepared output.
5. Print one test page or a short label range before releasing the full batch.

Save the reusable project JSON

Choose File → Save Project when the layout, mappings and settings are correct. Keep the downloaded project JSON with the approved source workbook and a printed test label. On the next run, use File → Open Project, load the new spreadsheet data, verify mappings and preview the changed records before printing.