How to Batch Geotag Photos with ExifTool


If you are geotagging your own images, one method is using the Exiftool to create a .csv file with latitude/longitude/altitude to upload with your survey data.

Please note that this is for advanced users who are familiar with executing applications via the command line.

Things you’ll need:

  1. exiftool.exe properly installed

  2. A comma-separated value (CSV) file with your geotags

  3. Photos that need to be geotagged

Installing Exiftool

Exiftool can be downloaded here. Extract the file, remove the (-k) from the name, and place it in the Windows folder on the computer’s hard drive.



CSV with the geotags

Ensure the CSV file has the headings shown in the screenshot below. The last three columns are optional. Those in the US will need to use N and W in the gpslatituderef and gpslongituderef columns rather than S and E.



Note that the file extension is included on each photo (column A). This is a requirement for Exiftool to function properly. If your CSV does not include the photo file extensions, you can add them using Excel.


To add the file extension:

  1. With your file names in column A, insert two extra columns to the right of column A with the original file names
  2. In the new column B, enter the file extension (for example, ".JPG" if the file extension is JPG)
  3. In the new column C, enter "=CONCAT(A1, A2)"
  4. Copy column C
  5. "Paste Special" into column C selecting the text-only option. This will replace the formulas in column C with the concatenated text
  6. Rename column C "Sourcefile"
  7. Delete the original column A and column B
  8. Save the file as a CSV
  9. Name the file FlightLog.csv

Running Exiftool

  1. Create a folder on your computer and name it "exifrun" (In this example, the folder was created in the Documents folder).
  2. Within that folder, create another folder called "georef"
  3. In the exifrun folder, place all the photos that need to be geotagged, and the FlightLog.csv file
  4. Launch the command prompt and “cd” to the exifrun folder

5. Run the following command. exiftool -csv=FlightLog.csv -o ./georef .

(Do not forget the "." at the end).


Tip: right-clicking at the command line will paste whatever you have copied to the clipboard.


6. The geotagged photos will exist in the georef folder

Troubleshooting

Ensure C:\Windows is in your PATH by following the below steps.


1. Go to Settings and choose Edit the system environment variables.


2. Select Environment Variables


3. Click Path and then Edit



4. Check to see if C:\Windows exists. If it does not, add it by going to New.



I still can't do it!

We wrote these articles to arm you with everything you need to get the job done on your own, but we understand that sometimes this isn't sufficient.

If you're stuck, you can connect with our support team by clicking the support button on the top right corner of your user portal.