You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Extract Photo Data of GPS TIME and Image Characters to Microsoft Excel

I am trying to figure out a way to extract imbedded and image data from an iPhone photo. I need to extract the following:

  1. Actually Characters in the Photo - i.e. Picture of numbers and put the numbers in the spreadsheet
  2. Put the GPS Data in the same spreadsheet
  3. Put the time of the photo in the same spreadsheet


Is there any process to do this?

I would also be good if this same info can be extracted to Apple Numbers.


Thank you!

Posted on Oct 16, 2024 8:14 AM

Reply
4 replies

Oct 16, 2024 11:05 AM in response to cajunsteeler

If you are interested about only image .jpg, .jpeg and .heic you could use this as a start to export EXIF datetime and GPS as .csv. Fine-tune for other suffixes, tags ands movies.


exiftool -a -G1 -s -n -r -csv -ext jpg -ext jpeg -ext heic --ext csv -DateTimeOriginal -GPSPosition . > out.csv


LibreOffice Calc imports that as comma separated as:




Extract Photo Data of GPS TIME and Image Characters to Microsoft Excel

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.