Variable Data
Variable Data Guidelines
Variable data is when text or image on the product changes from sheet
to sheet. This can include text, images, or both. Each product page will
specify if variable data is available.
Products with variable text are easy to order; just provide the following:
• A mockup of what the finished product will look like
• All art or images (see “Electronic Guidelines”) and text to be printed
on the item
• A database file
There are two elements necessary in the file:
• The header, which is the first row of the spreadsheet that describes
each column
• The database, which is the information that varies as shown below.
For variable images, include the names of the relevant image files in the
spreadsheet and include an image placeholder in the proof. Be sure to
submit image files along with the rest of the order.
For more information on pricing, call for a quote.
The database file is the variable information to be printed on the
product, set up in a spreadsheet. Excel files are appropriate for most
product lines; CSV files are preferred for labels and specialty products
like badges, signs, gifts, and awards.
Variable Text Example
A
Variable Image Example
B
C
1
Name
Birth Day
Expiration Date
2
Sarah
September 4
October 4
2
YellowLab.eps
Kara
September 7
October 7
3
LoveBirds.eps
4
Abigail
September 14
October 14
4
Collie.eps
5
Jeannie
September 17
October 17
5
RedPuppy.eps
6
Rhonda
September 23
October 23
6
SiameseKitten.eps
Happy Birthday, Sarah!
Bring this card with you and receive 25%
your purchase!
Valid September 4th - October 4th.
phone: 661-555-0143 • fax: 661-555-0144 • dandelionsquare.com
GENERAL
INFORMATION
Animal Image
3
2019 dandelionsquare 2019
258
A
1