Exporting to csv

[user3386170]

I had used exiftool successfully a few months ago but now I seem to be getting nowhere. I remember an GUI interface where I saw a table format with all the image files in a given folder with columns for the properties (including GPS and tags). I could click "copy information from previous line" and it would take the latitude or longitude from another image. I have not managed to find that GUI interface. Any ideas for how to get there?
Otherwise, I want to export the properties (where I can choose which attributes to export ideally) from multiples images into a csv spreadsheet format. In the GUI that I downloaded recently, I could only export each images' properties into separate files where I want one single spreadsheet. I am open to use the command-line option but I get an error when I try the cmd "'exiftool' is not recognized as an internal or external command, operable program or batch file." or just never-end clicking down to see more when I open "exiftool.exe" or "exiftool (-k).exe".

[StarGeek]

Exiftool is a command line only program, it doesn't have a GUI built in.  Maybe you used the Exiftool GUI found in the Exiftool GUI sub board on this forum.  It has been unsupported for a long time so you may or may not be able to get it to work.  I have lots of problems with it on Windows 10.  There are a few other GUIs out there, though I'm not really familiar with them.

The basic command to get csv file (see FAQ #12)
exiftool -csv >/path/to/out.csv <FileOrDir>
Replace <FileOrDir> with the files and/or Directories you want to process.  This will dump all the data into the csv file.  You can limit the output to certain tags if you specify them in the command.  For example,
exiftool -csv >/path/to/out.csv -GPSLatitude -GPSLongitude <FileOrDir>
will list just those tags.  Or you can use a wildcard to get all the gps tags
exiftool -csv >/path/to/out.csv -GPS* <FileOrDir>

You mention getting a "exiftool is not recognized" error.  This means the command line can't find exiftool, it's not in a directory covered by the PATH environmental variable.  Make sure you follow the Windows Install Instructions in order for CMD to be able to find exiftool.

[user3386170]

Thanks for your tips. I was able to make it work!

I moved the exiftool executable to my desktop (my path) and it was able to find it correctly. I had missed on that important detail at the start.

For anyone else who might find this, I ran into a few (very basic!) difficulties and had to adjust slightly to make it work:
1. the path that shows up automatically at the start of each new line does not need to be repeated in the file path
C:\Users\user3386170>       #this shows up automatically
exiftool -csv >herbier_test/herbier3.csv -GPSLatitude -GPSLongitude herbier_test #this is the code that I typed and it worked
I didn't type C:\Users\user3386170\herbier_test/herbier3.csv
2. the path must not have any spaces in it (possibly a way to include spaces but I got it split into four paths when folder names that I had spaces).

[StarGeek]

2. the path must not have any spaces in it (possibly a way to include spaces but I got it split into four paths when folder names that I had spaces).

If the file path has spaces in it, then put double quotes around it so that way CMD knows it's a single argument, not two separate arguments.  For example, if the directory was "herbier test" with a space in it, your command would be:
exiftool -csv >"herbier test/herbier3.csv" -GPSLatitude -GPSLongitude "herbier test"