PHP Classes

PHP Merge Excel Files Merge Excel Files To One Per Column: Create an Excel file from other spreadsheet values

Recommend this page to a friend!
  Info   View files Example   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog (1)    
Last Updated Ratings Unique User Downloads Download Rankings
2023-05-29 (3 months ago) RSS 2.0 feedNot enough user ratingsTotal: 70 All time: 10,170 This week: 101Up
Version License PHP version Categories
mergeexcelfilestoone 1.0.0GNU General Publi...5Files and Folders


This package can create an Excel file from other spreadsheet values.

It provides a script that uses Excel reader classes to parse multiple Excel spreadsheets in XLSX format to extract the values of their cells.

The script can combine the values of all the parsed spreadsheets and generates a single spreadsheet file in Excel XLSX format that merges the importance of all spreadsheets into one with a sheet with the values of other spreadsheets in multiple columns.

Innovation Award
PHP Programming Innovation award winner
June 2023
Excel is a popular tool for creating spreadsheets. It saves spreadsheet data in XML-based format, which usually is called XLSX.

This XML format makes it easy for PHP developers to process and create spreadsheet files in Excel XSLX format.

This package provides a script that uses an Excel parser and generator classes to show how to parse several Excel spreadsheet files and combine their values to generate a new spreadsheet that merges the importance of all spreadsheets in a single spreadsheet.

This way, other developers can learn to process multiple spreadsheets and combine them in a way that is convenient for their application purposes.

Manuel Lemos
Picture of Max Base
  Performance   Level  
Name: Max Base <contact>
Classes: 5 packages by
Country: United States United States
Age: ???
All time rank: 2627361 in United States United States
Week rank: 388 Up39 in United States United States Up
Innovation award
Innovation award
Nominee: 3x

Winner: 1x


Merge Excel Files to single excel file per columns


Set your directory name at, and number of files at

Your directory should look like: 1.xlsx, 2.xlsx, 3.xlsx, 4.xlsx, etc....

Now convert all excel files to a single file by running:

php parser.php

Next open res.xlsx file in your excel or libreoffice...

Copyright 2021 Max Base

  Files folder image Files  
File Role Description
Plain text file excel-create.php Class Class source
Plain text file excel.php Class Class source
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file parser.php Example Example script
Accessible without login Plain text file Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:10,170
This week:101Up