Spreadsheet

  • Provide a CSV or XLS spreadsheet that contains the variable data.

Variable Data Printing

  • The first row should contain the Variable Name of each column, eg “FirstName”.

  • Your spreadsheet needs the same number of rows as your print run, eg 1,000 rows for 1,000 copies.  If your spreadsheet only has 500 rows, then only 500 copies will be printed.

  • When referring to an artwork layer to be visible, use a Variable Name prefix “Layer-“, eg Layer-Colour.

  • For variable text data, the name of each column must match the Variable Name used in your artwork.

  • To make a layer in your artwork visible, use the name of the Artwork Layer, eg fashion – will make the Artwork Layer named “fashion” visible.