Variable data

Variable data printing from Excel: badges, certificates and cards

PrintFiles is variable data printing software for everyday jobs: upload a template and an Excel or CSV sheet, place the text and picture boxes once, and get a page for every record — imposed on the print sheet. Name badges, certificates, invitations and ID cards without mail merge.

Files are processed in your browser and never uploaded.

What the data merge tool does

  • Excel (.xlsx) and CSV; the first row names the fields
  • Text boxes with {{Name}} placeholders, font, size and alignment
  • Picture boxes: a photo or logo per record (PNG or JPEG), fit or fill
  • QR codes and Code 128 barcodes per record, for badge check-in, tickets and certificate verification
  • Shrink-to-fit so long names still fit their box
  • Fallbacks for empty cells ({{Title|Guest}}) and conditions to show or hide text
  • Front and back templates
  • A page per record, or imposed straight onto the print sheet
  • Per-record fixes before you export

Why print shops use it

No typing
Three hundred names go from the spreadsheet to print without one typed by hand.
Every record fits
Text shrinks within limits you set, so a long name never spills out of its box.
Print-ready in one go
Merged pages come out imposed on the sheet, with crop marks.

Who it is for

  • Event printers producing name badges and lanyards
  • Schools and colleges printing certificates
  • Print shops making invitations, place cards and staff ID cards

The problems it removes

  • Typing 300 names into a design file by hand.
  • A text box nudged on one card but not the others.
  • Names that do not fit the box.

Instead of Word mail merge, InDesign Data Merge or FusionPro

Word mail merge was built for letters; InDesign Data Merge needs InDesign and a careful template; FusionPro, XMPie and HP SmartStream Designer are full VDP suites for high-volume presses. PrintFiles covers the everyday badge, certificate and card jobs of a digital shop, straight from Excel.

Data merge: questions

Which files can I use?
.xlsx and .csv. The first row is the column names; write {{Name}} in a box to print that column.
What about long names?
A box can shrink the text down to a minimum size you choose, so every record fits.
Can each badge have its own photo?
Yes. Put the picture file names in a column, upload the PNG or JPEG files, and each record gets its own picture.
Can a line disappear when a cell is empty?
Yes, with a fallback such as {{Title|}} or a condition on the box.
Can each badge carry its own QR code?
Yes. Add a barcode or QR box and point it at a column — a ticket number, a registration ID or a verification link. PrintFiles draws it as sharp vector shapes and warns when a code would be too small to scan.
Does it make PDF/VT?
No. It produces a regular print-ready PDF, which every digital press accepts; PDF/VT is for dedicated VDP workflows.

See all nine prepress tools

Try data merge on your next job

Try all nine tools free for 7 days, then pay by M-Pesa or card, monthly or yearly.

Start free trial