EN
Open the tool

Variable data printing: sequential numbering & Excel merge

Every label with a unique serial number, QR code, or name: Trimto generates a full batch of items from sequential counters or Excel/CSV spreadsheets, then imposes them onto print sheets for guillotine cutting or die-cutting.

Open variable data printing tool →Free · runs in browser · files never leave your device

Features

  • Sequential counter {{stt}} (the running-number placeholder, replaced by 0001, 0002… on each label): custom start number, step increment, and zero-padded digit length (e.g., 0001, 0002)
  • Data merge from Excel, CSV: insert {{column_name}} into text fields, QR codes, or barcodes
  • Dynamic QR codes, Code 128, EAN-13, UPC-A, ITF-14, GS1-128, PDF417 and Data Matrix codes updated for each individual item
  • Real-time record preview across individual merged items before imposing
  • Impose the generated batch onto press sheets for straight step & repeat cutting or die-cut nesting

How it works

  1. Open your base design file and click "Sequential numbering" on the top toolbar.
  2. Configure starting number, step increment, and digits, or upload an Excel / CSV spreadsheet.
  3. Insert {{stt}} or {{column_name}} placeholders into text, QR codes, or barcodes, then preview individual records.
  4. Click Continue to impose the entire dataset onto sheets and export print PDF.

What is variable data printing (VDP)?

Variable data printing means printing one design where every copy carries its own content: sequence numbers 0001, 0002…, customer names, product codes, QR codes that each point to a different address. Instead of building hundreds of pages by hand, you need one design plus sequential numbers or an Excel sheet.

Common uses: tickets, raffle coupons, warranty and anti-counterfeit labels, event name badges, product labels with batch numbers, personalized invitations.

Sequential numbering: start, step and digits

Click "Numbering" on the toolbar and a {{stt}} text box is placed on the page; move it into place and style it like normal text. In the "Numbering / VDP" tab, set:

FieldMeaningExample
Start fromNumber of the first label1
StepHow much each label adds1
DigitsLeading zeros to fill the width4 → 0001
Label quantityHow many labels (without an Excel sheet)500
Prefix / SuffixText before / after the numberSP-0001/2026
Sequential numbering / VDP tab: start from, step, digits, quantity, prefix, suffix
Sequential numbering / VDP tab: start from, step, digits, quantity, prefix, suffix

Data merge from Excel or CSV

  • Prepare an .xlsx, .csv or .tsv sheet: the first row holds column names, each following row is one label.
  • Pick the file, or select a range in Excel, press Ctrl + C and paste it into the data box.
  • Select a text box, QR code or barcode and click a column name to insert {{column}}; {{stt}} still works alongside.
  • The label count equals the number of data rows; a misspelled column name is flagged in the preview.

QR codes and barcodes that change per label

A QR code or barcode can contain {{stt}} or {{column}}, for example https://example.com/p/{{Code}}, so every label gets a different code.

Code typeUsed for
QRWebsite links, product info, warranty
Code 128Internal codes, batch and serial numbers
EAN-13Retail product codes (12-13 digits)
UPC-A, UPC-E, EAN-8Retail codes for the US, Canada and small packs
Code 39, ITF-14, GS1-128Asset tags, shipping cartons, logistics labels
PDF417Tickets and ID cards holding a lot of text
Data MatrixVery small codes on component labels
Labels with sequential numbering and a QR code that changes per label
Labels with sequential numbering and a QR code that changes per label

Several designs, each with its own numbering

In a multi-page file, each page is a design with its own number series: the "Numbering / VDP" tab edits the page you have open and leaves the others alone. The Excel data table is shared by the whole file.

Imposing the series, per sheet or cut and stack

Click Continue and the whole series goes to the imposition step, switched to "Print by quantity" to find the fewest sheets. Choose step and repeat or die cut, then export the PDF as with normal labels.

For tickets and coupons cut as a pile, choose cut and stack numbering: after cutting, each stack runs in sequence with no hand sorting.

Step-by-step guides

Further reading

FAQ

Can sequential numbering include leading zeros?
Yes. Set the "Digits" count; for example, setting 4 digits formats numbers as 0001, 0002, 0003…
Which spreadsheet formats are supported?
You can upload .xlsx, .csv, and .tsv files. The first row must contain column headers, and each subsequent row generates one item.
Is variable data printing on Trimto free?
Yes. Numbering, Excel data merge, QR codes, barcodes and PDF export are free with no watermark. Your data and design files are processed in the browser and never uploaded to a server.
Can I paste data straight from Excel?
Yes. Select the range in Excel including the header row, press Ctrl + C, paste it into the data box and click "Use pasted table".
Can each page of the file have its own numbering?
Yes. Each page is a design with its own start, step and count; the numbering you edit is always that of the page you have open.

Open variable data printing tool →