News:

2023-08-10 - ExifTool version 12.65 released

Main Menu

csv flag for each

Started by jacobverdesi, February 28, 2023, 01:25:25 AM

Previous topic - Next topic

jacobverdesi

Hello i just stumbled across this marvilous program but still learning some if its quirks and features

Im currently running the command 'exiftool -ee -n -GPS* filename' and I get all of the gps lat/long/speed/track/date/time information as follows
GPS Latitude                    : 42.887158203125
GPS Longitude                   : -71.3512858072917
GPS Speed                       : 104.026836608887
GPS Track                       : 139.979995727539
GPS Date/Time                   : 2023:02:26 12:31:57Z
GPS Latitude                    : 42.886962890625
GPS Longitude                   : -71.3510579427083
GPS Speed                       : 103.397163391113
GPS Track                       : 139.809997558594
GPS Date/Time                   : 2023:02:26 12:31:58Z
GPS Latitude                    : 42.886767578125
GPS Longitude                   : -71.350830078125
GPS Speed                       : 103.397163391113
GPS Track                       : 139.970001220703
GPS Position                    : 43.0183675130208 -71.4480061848958
I would like to put into csv format where each row is a new group of gps data so i use the -csv option but it only selects the last entry

Phil Harvey

Try using the -p option instead:

exiftool -ee -n -p "$gpsdatetime,$gpslatitude,$gpslongitude,$gpsspeed,$gpstrack" FILE

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

StarGeek

And in case you didn't see it, you can also turn it into a GPX or KML file.  See Inverse Geotagging.  You can find the needed FMT files on GitHub.
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).