CSV With Multiple Rows Per Image?

[newoski]

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

[StarGeek]

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 for combining cells based upon duplicate entries in Google Docs.  There should be examples for other spreadsheets as well.