Hi,
I have a huge list of images to add keywords to and unfortunately, the keywords are stored in the spreadsheet that has the keywords placed one per row. So for example, if a SourceImage is supposed to get 4 different tags added, there would be 4 lines with the same SourceFile and then a total of 4 unique keywords, one per line.
Is there anyway to use this data structure with ExifTool?
SourceFile Keywords
path-to-image\image1.jpeg keyword1
path-to-image\image1.jpeg keyword2
path-to-image\image1.jpeg keyword3
path-to-image\image1.jpeg keyword4
path-to-image\image2.jpeg keyword1
path-to-image\image2.jpeg keyword2
path-to-image\image2.jpeg keyword3
path-to-image\image2.jpeg keyword4
No, exiftool will only use the last row listed for a file. You'll need to edit the spreadsheet.
A quick search pulls up these instructions (https://www.ablebits.com/office-addins-blog/combine-duplicates-google-sheets/#find-join-unique) for combining cells based upon duplicate entries in Google Docs. There should be examples for other spreadsheets as well.