What is variable data and how do I set up a Microsoft Excel Variable Data sheet?

15/01/2015

Variable data gives you the flexibility to print different text on a single print run.

For example, if you have 500 different addresses to print on your design for a mailing project then all we need is an Excel spreadsheet database with the relevant information.

Order variable data poster image

To supply us with variable data, download our Excel database file, add your variable data text and send it to us.

Contact Name Address Line 1 Address Line 2 Address Line 3 Address Line 4 Address Line 5
Mr Andy Labels Handy Labels Label HQ Adhesive Street Labelsford LA8 3LS
Mrs Andi Tags Handy Tags Tag Towers Retail Road Taggleton TA9 5XX

 

Please supply the Excel database in the format shown above. The first row of your Excel database will need to be your

Title Headings, which can be named however you please, will need to be present to enable us to extract your information correctly.