Photoshop – Data Driven Graphics

Step 3

Press the “Horizontal Type Tool”

Capture

Create four different text layers: “Name”, “Surname”, “Street” and “Country”

Capture

Step 4

Now we need to link the database with Photoshop. To achieve this go to:

Image -> Variables -> Define

Capture

Step 5

Choose the layer ‘Name’ and in the “Text Replacement” field type “Name” which is the same column header as in the Excel database.

Capture

Step 6

Now choose the layer ‘Surname’ and in the “Text Replacement” field type “Surname” which is the same column header as in the Excel database.

Capture

Step 7

Now choose the layer ‘Country’ and in the “Text Replacement” field type “Country” which is the same column header as in the Excel database.

Capture

Step 8

Now choose the layer ‘Street’ and in the “Text Replacement” field type “Street” which is the same column header as in the Excel database and press the “Ok” button.

Capture

Step 9

Now we need to attach the database to Photoshop. Navigate to:

Image -> Variables -> Data Sets

Capture

Step 10

Press the “Import” button and select the database file and press the “OK” button.

Capture

Capture

Step 11

We need to export our database rows as a separate Photoshop file. Navigate to:

File -> Export -> Data Sets as Files…

Capture

Step 12

Press the “Select Folder” and press the “Ok” button. Photoshop automatically will create a different Photoshop file for every row in the database.

Capture

Result:

Capture

Step 13

Now we need to convert every PSD file to JPEG. This can be done automatically using a script. Go to:

File -> Scripts -> Image Processor…

Capture

Step 14

Select the folder where you previously exported the PSD files and select the folder where you want your JPEG files. Then press the “Run” button.

Capture

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s