MergeXL merges entire Excel workbooks and places their data into any number of new, merged workbooks without linking formulas, macros, or a database. The Excel workbooks are organized using a simple Explorer-like tree structure, and are edited using the mouse. Multiple structures can add up the same workbooks differently. There is no code or any macros placed into the workbooks at all. Reporting across Excel workbooks, input-level and merged, can be done by clicking check boxes. MergeXL features the ability to edit one workbook and have all of the workbooks changed. Editing workbooks is speedy, uniform, and minimizes errors from repetition. Data entry to multiple workbooks from a single text file is accomplished using the user's own account and entity codes. Data input errors can be all but eliminated. MergeXL can verify that all workbooks are the same, and can identify unauthorized changes. All the workbooks in an application can be conformed to a master workbook, while still having designated exceptions.