[SOLVED] How to import fast gps coordinates of lots of images in to Excel?

[rhcp89]

Hello,

I have hundreds of photos. They have gps coordinates which we can see in properties of each file. I would like to export that data to MS Excel in one column in efficient way. How to do it?

I have already tried softwares like "memento database", "easy database", "mobi db" with no effect. These are apps for android where you can make data base with images but they dont have access to meta data (properties/details ) of each file.

 

[kanewolf]

Hello,

I have hundreds of photos. They have gps coordinates which we can see in properties of each file. I would like to export that data to MS Excel in one column in efficient way. How to do it?

I have already tried softwares like "memento database", "easy database", "mobi db" with no effect. These are apps for android where you can make data base with images but they dont have access to meta data (properties/details ) of each file.

Have you googled "geotag inport to excel" or "exif import into excel" There are a number of options. I have not used any, so I can't speak from personal experience.

This tool -- https://exiftool.org/ Gets a lot of recommendations in the ACDSEE forum (I do use ACDSEE) ...

 

[Ralston18]

FYI:

https://devblogs.microsoft.com/scripting/use-powershell-to-find-metadata-from-photograph-files/

 

[rhcp89]

Have you googled "geotag inport to excel" or "exif import into excel" There are a number of options. I have not used any, so I can't speak from personal experience.

This tool -- https://exiftool.org/ Gets a lot of recommendations in the ACDSEE forum (I do use ACDSEE) ...

Yes I solved my problem with exiftool - it is completely free however UI may be hard too learn - however there good tutorials on the YT - see:

View: https://www.youtube.com/watch?v=S6v-Cg0fQbQ

FYI:

https://devblogs.microsoft.com/scripting/use-powershell-to-find-metadata-from-photograph-files/

Maybe it would work but probabaly it is not for free. Thanks for your interest!