把Excel資料批量填入Photoshop模板 (Image - Variables - Define - Data Sets)

Video tutorials

Special thanks to the video below!!
About how to batch import Excel data into Photoshop template.

YouTube: How to use Variable data, text and images - Adobe Photoshop CC tutorial | Primo Graphics

Wrote this article just for myself be able to quick reference in the future.
快速筆記，中英夾雜。

---

1. Prepare the Excel data & Photoshop template

ATTENTION

1. Export Excel data as csv (UTF)
   特別是如果資料中有中文字，一定要選UTF，不然會亂碼。
   
2. MUST BE THE SAME (Excel columns & Photoshop - Define Layer)

• name of columns
• number of columns 不能多不能少
• order of columns 順序

Otherwise, it will pop up the error below:

Could not parse the file contents as a data set. There were too many variable names in the first line of the text file.
or
Could not parse the file contents as a data set. There were not enough variable names in the first line of the text file.

*For images, input their file path in Excel.

Method to copy the file path of all the files in the same folder

Windows

create a .bat file

bash

dir /s /b> ouput.txt

生成的 txt 內容類似這樣

Code

C:\Users\helloword.docx
C:\Users\hello.xlsx
C:\Users\folder-1
C:\Users\folder-2

Mac
Command Option C to copy file path, then Command V to paste.

To do it in batch,

1. Open terminal.
2. Type cd and press space.
3. Then, drag the folder into the terminal, hit Enter.
4. In terminal, type:
   bash

   ls -d "$PWD"/* > output.txt

生成的 txt 內容類似這樣

Code

~/Users/helloword.docx
~/Users/hello.xlsx
~/Users/folder-1
~/Users/folder-2

2. Photoshop - define variables

2.1 Image → Variables → Define...

2.2 Choose the layer that you would like to import Excel data.

2.3 The Name field must be the same as the column name in Excel.

for text - Text Replacement

for image - Pixel Replacement

2.4 Click OK.

3. Photoshop - import dataset

3.1 Image → Variables → Data Sets... or shortcut Command 2

3.2 Import... → Click Select File... to select the csv file
** remember to select the encoding as Unicode(UTF-8)

3.3 Remember to fulfill the criteria stated in step 1. Then, click OK OK. If no error pops up, it means it works.

4. Export (psd files)

4.1 File → Export → Data Sets as Files...

4.2 Click Select Folder... to select the place you would like to save the psd files. You can set rules to name the files.

4.3 Click OK. Done! You could find all the psd files in your selected folder.

Batch convert psd files to jpg

Multiple psd files to multiple jpg files (1 psd → 1 jpg)

1. File → Scripts → Image Processor..
   

2. Put all the psd files (that you would like to make conversion) into the same folder. To explain it easier in the following steps, let’s call this folder as FOLDER-A.

3. Click Select Folder... to select FOLDER-A.
   

4. Click Run. Done! A folder called JPEG will be auto-generated in FOLDER-A. You may find all the jpg files there.

Batch convert psd files to PDF

Multiple psd files to one PDF

1. File → Automate → PDF Presentation...
   

2. Tick Add Open Files.

3. Click Browse to select all psd files that you would like to combine into one PDF.

4. You may sort them.

5. Click Save. Done!
   

---