Published June 21, 2024 | Version v1
Software Open

Excel Files Merger

  • 1. University of Twente
  • 2. Universidade de São Paulo

Description

Excel Files Merger

This Python script merges multiple Excel files into a single CSV file. The Excel files must have the same structure (same columns).

Requirements

  • Python 3.x
  • pandas
  • openpyxl

Installation

Install the required libraries using pip:

pip install pandas openpyxl
Also available on GitHub.
 

Files

Files (1.6 kB)

Name Size Download all
md5:196ff1c8ea09b0f726a86adab24e358e
1.6 kB Download

Additional details

Funding

Fundação de Amparo à Pesquisa do Estado de São Paulo
A metadata model for interoperability of agricultural databases 21/15125-0

Software

Repository URL
https://github.com/Filipi-Soares/MergeDatasets/tree/main
Programming language
Python