Variable Data Printing 101

What variable data printing is

Variable data printing (VDP) lets every piece in a print run be different. Instead of 500 identical postcards, you get 500 postcards where the name, address, number, photo or QR code changes from one to the next, pulled automatically from a spreadsheet. The design stays the same; only the fields you choose change. Because variable data runs on our digital presses, there are no plates or extra press setups for each version, so personalizing a run of 100 or 10,000 pieces is practical for businesses, schools, nonprofits and event organizers in Doylestown and across Bucks and Montgomery County.

Common uses

How to prep your data file

The spreadsheet drives the whole job, so most variable data problems start (and are easiest to fix) here.

• Use Excel (.xlsx) or CSV. Google Sheets and Numbers can export either one. Please don't send the list as a PDF, Word table or email text.
• One row per piece. Row 1 is the header; every row after it is one printed piece. No blank rows, subtotals or notes at the bottom.
• Clean headers. Short, plain column names such as FirstName, LastName, Address1, City, State, ZIP and TicketNo. Avoid symbols and duplicate headers.
• One field per column. Split first and last names if the greeting uses only the first name, and keep each address line in its own column.
• No merged cells, hidden rows or columns, or formulas that might break. Copy and paste as values before you send the file.
• Protect leading zeros. Format ZIP codes and numbers like 0001 as text, or Excel will turn 08901 into 8901.
• Check spelling and capitalization. We print exactly what's in the file: "JOHN SMITH" prints in all caps and "mary jones" prints in lowercase. Fix names like McDonald and O'Brien by hand; automatic tools often get them wrong.
• Remove duplicates so nobody gets two pieces.
• Include a proof row. Add one clearly labeled test record at the top, such as your own name and address. It shows up on proofs, and you can tell us whether to print it as a file copy or leave it out.

Example: one header row, one row per piece and a labeled proof row (address columns left out to save space).

Setting up the design

• Leave room for the longest name. Sort your list by length (Excel's =LEN() function helps) and test your layout with the longest name, title and address. A line that fits "Ann Lee" may not fit "Christopher Montgomery-Fitzgerald." Keep all variable text inside the safe zone.
• Choose fonts carefully. Pick a clear, readable font for variable fields and make sure it includes accented characters (é, ñ, ü) and apostrophes. Script fonts look elegant but are hard to read in all caps or at small sizes.
• Mark the variable fields. Use obvious placeholders such as <<FirstName>> so everyone knows what changes and what stays the same.
• Adobe InDesign Data Merge: open Window > Utilities > Data Merge, select your CSV, drag the fields onto the page, then create the merged document and export a PDF.
• Microsoft Word mail merge: use Mailings > Start Mail Merge, choose your Excel file with Select Recipients, insert the merge fields, then use Finish & Merge and save the result as a PDF.
• Or let us merge it. Send your design with placeholder text plus the spreadsheet, and our prepress team will merge it for you. This is often the easiest route, and it keeps file sizes small.

If you merge the file yourself, send one PDF with one record per page, in the same order as your list, with bleed and no imposition. We arrange the pages on press sheets (see imposition basics).

Numbering

• Starting number: tell us the first number (1, 101, 5001, or whatever continues your last order) and either the quantity or the ending number.
• Leading zeros: decide how many digits you want. With four digits, 1 prints as 0001, so every number is the same width and sorts correctly. Add a prefix if you like, such as "No. 0001" or "A-0001."
• Sequencing: numbers usually run up by one. On tickets with stubs, the stub repeats the ticket number. We lay out the sheets so that, after cutting, the stacks come out in order, ready to bundle or bind into books. Need numbers skipped, repeated, or split into separate runs? Just tell us.

See our numbering and perforating services for tear-off stubs and numbered forms.

Images and QR codes for each record

• Images: add a column with the image file name for each row (for example maria-lopez.jpg), spelled exactly like the files in one folder, and send that folder zipped. Crop the images to the same shape and keep them at 300 ppi at final size (see our resolution guide). In InDesign Data Merge, start the image column header with @ (for example @Photo).
• QR codes: put the full web address or code for each record in its own column, and we generate a unique QR code for each piece. Shorter links make simpler codes that scan more easily; a tracking ending such as ?id=0001 works well. Print codes at least 0.75" square, dark on a light background, with clear space around them, and scan a few on the proof.

Proofing

Before the full run, we send sample proofs of several records: typically the first and last records, a few from the middle, the longest name and any entries with special characters. Check spelling, line breaks, numbering and whether every QR code scans. Once you approve, we print from that data exactly as supplied, so any later list changes need a new proof. For color-critical or high-value jobs, ask for a printed proof as well as a digital proof.

Variable data checklist

• Excel or CSV file, one row per piece, clean headers in row 1
• No merged cells, blank rows, hidden columns or broken formulas
• Spelling and capitalization checked; duplicates removed
• ZIP codes and numbers formatted as text so leading zeros survive
• Proof row added and labeled
• Layout tested with the longest name and address
• Starting number, digit count and quantity decided for numbered jobs
• Image files named to match the list, sent in one zipped folder
• QR code links checked and kept short
• Sample proofs reviewed and approved

Ready to personalize your next print job?

From numbered raffle tickets for a Doylestown fundraiser to name badges for a Montgomery County conference or a personalized mailer across Bucks County, send us your list and artwork and we'll merge it, proof it and print it. Request a quote online or call 215-244-0233 (Mon–Fri, 9am–4pm).

Frequently asked questions

What file format should my list be in?

Excel (.xlsx) or CSV, with one row per piece and simple column headers in the first row. Google Sheets can export either format.

Do I have to do the mail merge myself?

No. Send your design with placeholder text and your spreadsheet, and our prepress team will merge the data and send sample proofs before printing.

How do I make numbers print with leading zeros?

Tell us how many digits you want (for example four, so 1 prints as 0001). If the numbers are in your spreadsheet, format that column as text so Excel keeps the zeros.

Can every piece have its own QR code?

Yes. Put the unique link or code for each record in its own column and we will generate a different QR code on every piece.

Can you clean up my mailing list?

Yes. Our mailing list preparation service can help format addresses consistently, split names and address lines into columns, find duplicates and flag incomplete records.

Related services

• Variable data setup
• Numbering
• Raffle tickets
• Name tags
• Mailing list preparation
• Mailing services

Helpful customer tools

• QR Code Generator (test a single code) (available to customers with a free account)
• PreFlight Checker (available to customers with a free account)

Already a customer? Log in to use them.

More Printing 101 articles

• Bleeds, Trim & Safe Zone
• Envelope Sizes Guide
• Folding Types & Panel Sizes
• Imposition Basics
• Paper Weights & Finishes
• Standard Print Sizes
• Color: CMYK vs RGB vs Pantone
• Resolution, DPI & File Prep
• File Setup for White Ink Printing
• Binding 101