Copying data from Excel

[Garethashenden]

I have a project I'd like to do, an I think ExifTool can do it, but I'm not sure how to set it up.
Between 1954 and 2004 my grandfather took about 34000 photographs on slides. He has scanned them all and they're now on my computer. He also made an Excel spreadsheet of all the information for the pictures, date, location, subject, etc.
I would like to find a way of taking the file, finding it in the spreadsheet, and then adding the relevant data to the exif data. I'm most concerned with date, latitude, and longitude.
If anyone has a suggestion of where to start, I would appreciate it.
Thanks,
Gareth

[Phil Harvey]

If you can output the spreadsheet in CSV format that is compatible with ExifTool, then you can set the metadata directly from the CSV file.  See FAQ 26 for details.

- Phil