A Python tool for analysts and developers to combine Excel files for reporting. It merges data from multiple workbooks and sheets into a single, organized file, saving hours of manual copy-paste work.
Features
- Merge multiple .xlsx and .xls files into one workbook
- Combine all sheets or select specific ones by name
- Preserve original formatting and data types
- Handle large datasets with efficient memory usage
- Command-line interface for batch processing
Usage
import excel_merger
merged_df = excel_merger.merge(['sales_q1.xlsx', 'sales_q2.xlsx'])
merged_df.to_excel('annual_report.xlsx', index=False)
Requirements
Python 3.8+. Install dependencies:
pip install -r requirements.txt
Download
Buy once, download immediately. ZIP includes the full script, README, and usage examples.
License
Personal & Commercial Use. You may use this tool in your own personal and commercial projects. Redistribution or resale of the source code is not permitted.