Excel Merger

Excel Merger is a tool designed to combine multiple Excel files into one. It supports XLS, XLSX, and CSV formats. The tool is available at PDF Excel Converter.

★★★★★

4.5(2 ratings)

• File merging. The main function lets you join several Excel files into one. Data is merged into a single sheet or kept on separate sheets, depending on the selected settings.
• Multi-format support. Works with XLS, XLSX, and CSV files. No prior file conversion is required for processing.
• Specific sheet selection. Lets you choose particular sheets from each file for merging. Unselected sheets are ignored during the process.
• Duplicate removal. Detects and removes repeated rows in the merged data. Comparison is done by values in specific columns or across the entire row.
• Data filtering. Applies filters before merging the files. Criteria include specific values, numeric ranges, or text matches.
• Custom sorting. Organizes the resulting data by columns in ascending or descending order. The setting is applied after the merge.
• Format preservation. Keeps the original cell formatting, including fonts, colors, and borders. Styles are not lost during the merge.
• Column-based merging. Combines files by adding columns instead of rows. Data is aligned according to the specified key values.
• Header settings. Defines how the first row is treated as headers. Includes an option to keep only the headers of the first file.
• Batch processing. Handles large numbers of files in a single operation. There is no predefined limit on the number of files to merge.
• Version compatibility. Works with all versions of Microsoft Excel from 2003 to the present. Generates files compatible with earlier versions.
• Multilingual interface. Available in Spanish, English, French, German, and other languages. The interface language follows the system settings.

The Excel Merger tool was developed by PDF Excel Converter in 2018. The program is written in C++ with additional Python components for data processing. The developers specialize in office productivity tools with a focus on file manipulation. The first version supported only basic sheet merging, with advanced features added in later updates. The team releases regular updates for bug fixes and performance improvements.

Alternatives to Excel Merger: