Any way to batch label/"watermark" photos from an Excel spreadsheet?

hi everyone! work @ testing lab takes photos of tested specimens clients part of test program. flat painted metal panels automotive parts, fabrics, led screens, etc. , everything.

 

currently, time take photos have label each 1 individually test information. have attached example below. have ps file white header bar, logo, , test info text layer, , copy , paste each photo , change info. can time consuming! not if test has 10 samples labelled 1 through 10, when have 80 samples/photos , each id different , long can take hour copy , paste each id spreadsheet.

 

so company wants change this, see if can simplify more. there way photoshop cs can pull info spreadsheet , somehow attach each image? have 10 photos, 1 photo per sample, , excel spreadsheet 10 ids. if it's watermark text (sans logo), possible ps pull spreadsheet?

 

somehow need add test number, hours/months of exposure, , specimen id.

 

any ideas tremendously! if not, we'll go different route altogether. in advance!

 

take @ link below describes how use variables - think you

 

creating data-driven graphics in photoshop

 

dave

More discussions in Photoshop

adobe