/Excel-Files-Merger

This Python script allows you to merge multiple Excel files from a selected folder into a single Excel file. The script uses a graphical user interface (GUI) to let you select the folder containing the Excel files and the location to save the combined file.

Primary LanguagePythonMIT LicenseMIT

Excel Files Merger

This Python script allows you to merge multiple Excel files from a selected folder into a single Excel file. The script uses a graphical user interface (GUI) to let you select the folder containing the Excel files and the location to save the combined file.

Features

  • Select a folder containing Excel files.
  • Combine all Excel files in the selected folder into one.
  • Save the combined Excel file to a specified location.

Requirements

  • Python 3.x
  • pandas
  • openpyxl
  • tkinter

Installation

  1. Clone the repository:

    git clone https://github.com/zackha/excel-files-merger.git
    cd excel-files-merger
  2. Install the required Python packages:

    pip install pandas openpyxl

Usage

  1. Run the script:

    python merge_excel_files.py
  2. A window will appear:

    • Click "Select Folder" to choose the folder containing your Excel files.
    • Click "Select Save Location" to choose where to save the combined Excel file.
    • Click "Combine and Save" to merge the files and save the combined file.

License

This project is licensed under the MIT License. See the LICENSE file for details.