Combine Multiple Excel into one - Python GUI Tool

Combine Multiple Excel into one - Python GUI Tool

Excel Merger is an open tool developed on Python which allows users to merge multiple excel files into a single file.

The tool is powered by a Graphical user interface, which makes the life easy for the ones using the same. The GUI is quite simple with only 2 options.

1.Source Folder of the excels to be Merged.

2.Destination and name of the new merged excel.

The source code of the tool has been uploaded to Github. Anyone can access the code and make necessary changes as per their requirements.

Excel Merger GUI The major packages used in the code are Pandas (for extracting the excel sheets as dataframes) and tkinter (for the GUI for the tool).

Code snippets:

      #read the excel files
      excels = [pd.ExcelFile(name) for name in excel_names]

      #turn them into dataframes
      frames = [pd.read_excel(excel_name, ) for excel_name in excel_names]

      combined = pd.concat(frames, sort=False)

Check out the GitHub for the full code. You can clone the repository and modify the code as per your requirement.

comments powered by Disqus