Batch tagging using a spreadsheet

[Ficklelife]

I have a huge amount of photos and a spreadsheet that contains data about each photo, for example: lat, long, keywords, product category, city, etc

I'd like a way to automate assigning the data as xmp tags to jpgs/raws, ideally on a mac. Is there any tools out there which can perform batch tagging from a spreadsheet?

 

[pentaprison]

You could probably do this with exiftool. But you wouldn't be able to do it without a little work.

I'd probably do it like this...
1. Export the spreadsheet to a text file
2. Edit the text file to build a batch file (or whatever they're called on OS-X)
3. Run the batch file.

This may be a little more work than you have in mind, but I'm sure it can be made to work.