Making an ExifTool GUI in Excel

Started by berliner_ffm, April 06, 2020, 02:18:14 PM

Previous topic - Next topic



over the past weeks I tried to work my way through the most important functions in ExifTool and although I just scratched the surface I already found out that I need something that helps me creating the Commands I want. Thats when I startet to build a Excel-Workbook that helps me define the parameters for ExifTool.
After some work a first alpha version is now ready and I wanted to see what you think about it.

Beware that this is a first version and it might still have some bugs in it. I am planning to make it Donation Ware at some point but for know I will only provide it here, seeking for Feedback, Bug Report and Feature Suggestions. Also suggestions in Terms of Usability are valued.

The Workbook contains 3 Sheets:

  • Config => here you create your ExifTool Command
  • Rename Template Builder => here you can make filename-Templates
  • Date_Time Template Builder => here you can make Time/Date-Templates

The config sheet sections can be expanded by the "+" sign on the side.
The last "+" in the config sheet reveals the created exifTool statement and the button "Run ExifTool" will execute the statement in the windows commandline (I have only a windows system, so I cannot speak for Mac).
To make it work make sure to enter your exifTool path and filename in the "ExifTool Configuration" area.

So far the sheet contains the most basic functions, like
-reading Metadata
-write Metadata to file
-change Metadata
-Rename/Copy and Move Files

I am planning to extend functionalities once these things are working stable.

Ok, I that's enough for now. I hope you like it!

Phil Harvey

Very interesting.  I didn't know you could do that sort of thing in Excel.

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


New Version
  -fixed 2 value lists
  -added output option for binary data (e.g. thumbnail extraction)


Over the past days I threw away my approach of making the userinterface a spreadsheet. Instead I went with a userform.
Also I added some more functions:
-Criterias (if-Tag)
-User defined parameters
-%c and %C-Option when renaming files
-Reading Tags from csv-files (-csv-Option)
-json-format for output
-Execution in Powershell instead of Commandline (which gives more options for future expansions)
-Save Command (inkl. Userprompts) into a powershell script
-Save Settings as Templates for future use

Also I fixed some bugfixes and explored with possibilities of combining ExifTool with Google's Cloud Vision API (Auto-keywording) and Google-Translate API. Both will be part of later updates.

Beware that this still a very early version, so bugs may still appear here and there.
Thanks for any feedback!