You might want to consider starting a new thread, but that workflow feels similar to how people manage with cameras that don’t have gps. The main difference is that you have a csv with (presumably) no date/time, but a photo name, so existing solutions probably won’t work as they rely on having a gpx track.
Not sure how familiar you’re with command line tools, but this feels like a scripting job
This is quite simple and straightforward scripting task. I think most portable way would be to use Python with piexif. If you could show a sample of the exact CSV, it would be quite simple to put together.
The important parts are:
- How are the coordinates set in CSV, decimal or DMS?
- Are the images referred to as absolute (/home/mapilllary/image1.jpg or c:\mapillary\image1.jpg) or relative (image1.jpg) paths?
- What is the order of the fields?
EDIT: Looks like there are working examples made already, such as this - How to geolocate drone imagery from a csv table with Python and Piexif - Tutorial — Hatari Labs
Well, you can do it in Excel and copy the result to command line window or .bat file.
Assuming you write the formula in M column, it would be something like this. You may need to replace the semicolons with commas, depending on your settings.
=“exiftool “&A2&”.jpeg -gpslatitude=”&ABS(E2)&" -gpslongitude=“&ABS(F2)&” -gpslatituderef=“&IF(E2<0;“N”;“S”)&” -gpslongituderef=“&IF(E2<0;“E”;“W”)&”-datetimeoriginal=“&CHAR(34)&text(l2;“yyyy-mm-dd hh:mm:ss”)&CHAR(34)&”"
Exiftool must be in same folder or in PATH or set with absolute path in the formula.