Skip to content

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.

License

Notifications You must be signed in to change notification settings

zackha/Excel-Files-Merger

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 

Repository files navigation

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.

About

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.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages