A small program that takes two excel files with similar structure and allows for extending of the 'main' file with data from the other.
The program utilises a fork of PySimpleGui -> FreeSimpleGui for the frontend GUI The Backend is written in Python and uses Pandas library for some data manipulation.
Upon starting the program, the user is presented with an interface to select the files that need to be update and a save location:
After the needed locations are selected the "Confirm" button must be pressed in order for the backend to execute the nessesary checks. If all is good a confirmation message is displayed.
Next by pressing "Execute" another window is presented to the user showing column matches between the two files:
If multiple sheets are present in the files, multiple tabs are displayed each suggesting the possible merges. The user then can select which or all columns he wants to update and press "Submit"
In the end a new file with the merged columns is saved at the specified location.
Just download and run the provided binary executable for a windows OS.
or alternatively:
download and run the python script directly or compile your own executable.