Frequently Asked Questions
I have 325 Excel files and I need all the data to be merged into one Excel file. Each file has a different row heading. Can they be combined?
Yes. Each file's data will be joined vertically (top to bottom). You will be able to rearrange the Excel files in the application window.
Is there a maximum file size or max row count when merging Excel files?
If you are merging .xls files, the maximum row count allowed per file is 65,536. If your merged file needs to exceed that, you will need to use the .xlsx file format, where the maximum row count can be close to 1 million. Bulk File Merger does not restrict file sizes.
How are the files combined/appended into the master merge file?
For Excel files, data in each row is inserted below each other and this is done for all selected files. Files are combined according to the order in the source folder. The same pattern of merging applies to doc, csv, powerpoint, and text files.
How does Bulk File Merger handle files containing multiple Excel sheets?
The standard version of Bulk File Merger merges data from each sheet tab, file by file without issues. In the Pro Version (Windows), you will be given the choice to include worksheet tabs in the merge.
Do all Excel spreadsheet files need to have the same row heading?
No, Bulk File Merger will take care of files with different row headings. In fact, you can have any number of columns or rows in each file. Blank spaces and special characters do not affect the file merge.
I have formulas in some of my cells, is that a problem?
Not at all. The cell's values are carried over in the merge but the formula statement will not be available.
If I open a merged csv or txt file, it looks garbled, why?
Csv and txt files are flat files. To make some sense out of them, the files need to be opened in Excel. Excel will recognize these files as binary, flat files and the text import wizard in Excel will assist you in opening and viewing the file in the proper format.
I'm a Writer and I have 38 chapters (38 doc files) in Microsoft Word. Can Bulk File Merger merge all the chapters into one book/file in the same order? What happens to the format?
Yes, the Word doc files can be merged in the order you choose. In most cases, the formatting will be intact during the merge; a section break is inserted between each file.
...I was faced with an absolute mountain of CSV files that needed to be combined and analyzed. After attempting to merge a few files manually and even programming an Excel macro to do some of the work, I did the math...14 hours of manual process. Bulk File Merger did the job in a few minutes!
-Richard Palarea, CEO, PA & Associates Transportation Spend Management
We just reached 15,000 users worldwide — Thank you for your support!
