Keywords From CSV
Script for Adobe Photoshop
Latest update 6/27/2021, version 2.3.1
The script reads CSV spreadsheet data for file names and keywords, searches a selected folder for the files, and updates the keywords.
- Update unique keywords for each file
- Add, replace, or remove keywords
- Process any number of images
- Include subfolders
- Match name exactly or without extension
How to use the script
The interface has three sections: Data file (CSV), Images folder, and Options. Select the data file, the columns to use, and the images folder. Enable the desired options, and click the OK button to begin. A progress bar is displayed while processing. When complete, the number of images processed is reported and a log file is written at the location of the data file.
Section 1: Data file (CSV)
File — select the CSV data file, a spreadsheet of at least two columns and any number of rows. The minimum columns are one for file name, and another for keywords. There is no harm in extra columns. Which columns are the file names, and which are the keywords, are chosen next. If file names are only base name (file name without extension), be sure to check the option (below) Match file name only, without extension.
Once the data file is selected, it is parsed to determine the columns and rows it contains. The next step is to select the column for file name, and the column for keywords.
Column file name — the header of the column containing the file names.
Column keywords — the header of the column containing the keywords.
In the column for keywords, multiple keywords may be delimited with a comma or a semicolon. If comma, the cell must be wrapped in quotes otherwise the comma signals another column. For CSV saved from popular spreadsheet applications (i.e. Excel), this is handled automatically by the application.
Section 2: Images folder
Folder — select the folder of images to process. For any found in the folder that also appear in the file name column, the file is processed.
Match file name only, without extension — enable to match any file extension, or if the file name column lists only the base name (file name without extension). When enabled, file names with different extensions are considered a match, and are processed.
Include subfolders — files within subfolders are included in the search for images to process.
Section 3: Options
Add keywords — preserves current keywords and appends to them keywords in the keywords column.
Replace keywords — current keywords are removed and keywords in the keywords column are added. Keep in mind when using this option, for any row (image) in which the keywords cell is empty, keywords are replaced with nothing, so in that case, existing keywords are removed.
Remove keywords — current keywords that appear in the keywords column are removed. Any existing keywords that do not appear in the keywords column remain untouched.
Keywords From CSV
License details included in download
For help installing scripts, see How to Install and Use Scripts in Adobe Creative Cloud Applications.
IMPORTANT: by downloading the script you agree that the software is provided without any warranty, express or implied. USE AT YOUR OWN RISK. Always make backups of important data.