DEV Community

Oddshop
Oddshop

Posted on • Originally published at oddshop.work

Spreadsheet File Merger for Reporting

We just released Spreadsheet File Merger for Reporting — merge multiple excel workbooks and sheets into a single report-ready file.

What it does

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)
Enter fullscreen mode Exit fullscreen mode

Requirements

Python 3.8+. Install dependencies:

pip install -r requirements.txt
Enter fullscreen mode Exit fullscreen mode

Get it

Download Spreadsheet File Merger for Reporting for $29 →

Buy once, use anywhere. ZIP includes the full script, README, and usage examples.


Originally published at oddshop.work
Built by OddShop — Python automation tools, one new release every week.

Top comments (0)