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.
Works well with
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