Merge Excel Files and Sheets

Merge Excel Files and Sheets combines records from selected XLSX worksheets into a unified table. It is designed for monthly exports, department reports, and other files whose rows belong in one dataset. The independent work here is selecting worksheets, interpreting their regions and headings, and aligning their fields before appending records. Simply copying every original tab into another workbook would produce a different kind of result.

Begin with files that represent compatible business records. Two sheets can share a column called amount while measuring different currencies or units. Matching column names does not establish semantic compatibility. Confirm the meaning of the fields and the intended reporting period before merging, and retain the source summary when reviewing the output with another person.

Choose files accepts unencrypted XLSX workbooks. The workbench lists each workbook's worksheets, visibility, effective range, hidden-row count, and hidden-column count. The 1900 or 1904 date system is also shown. This information helps distinguish a sheet containing the actual table from a cover sheet, instructions, or an internal calculation area.

Select all visible sheets is a convenience, not a substitute for reviewing each sheet. Hidden sheets are excluded by default. Select matching visible sheets selects an exact worksheet name across files, and the resulting selections still need their ranges and headers confirmed individually. Files with the same tab name can have different layouts or missing fields, so a shared name alone cannot approve their structure.

For every selected worksheet, set Range, Header row, and Data start row. These refer to worksheet coordinates for workbook merging. If a report has two introductory rows and headings on row three, choose row three as the header and row four as the start of data. The selected output should not contain the introductory text as business records.

Use the range endpoint to exclude a footer or total area when it is outside the table you intend to combine. The tool never deletes a record merely because a cell contains the word Total. A business record might legitimately have that value. Exclusion is based on the boundaries you confirm, and the source summary records those choices rather than presenting the output as every cell from every workbook.

Same column set requires each input table to have the same named fields, although their order can differ. The engine aligns values by field name rather than by visual position. This is appropriate for monthly exports with stable schemas. A missing or additional field blocks the strict merge until you select another rule or correct the schema.

Union includes every selected field and leaves an empty value where a source does not provide that column. Intersection includes only fields present in every selected table. Before intersection is accepted, the panel lists the fields that will be dropped and requires confirmation. Inspect those names carefully: an identifier available in only one department may be important even if most of the other fields are shared.

Map target column names manually lets you align known equivalents, such as customer_id and client_id, under a reviewed common output name. It does not guess that two differently named columns mean the same thing. Mapping is associated with the selected source columns, and changing a source structure can require another review.

Avoid mapping two columns from the same worksheet to one target name unless you first decide how their values should be reconciled using an appropriate separate operation. This merger rejects ambiguous duplicate target names. Mapping can also be useful when only one selected sheet needs a consistent schema before a later merge; the chosen mapping still applies to that single-sheet result.

XLSX can store a number as 123 while formatting it to display 00123. In the default data-value mode, the underlying representation is used. Preview selected area and value modes provides a separate report showing stored values, displayed text, formulas, saved-result states, and date interpretation where relevant. Inspect this report for identifiers, codes, dates, and formatted percentages.

Display-text column numbers selects specific worksheet columns whose visible text should be used. Those choices are recorded in the scope. They do not silently convert every column to its display spelling. All output data is represented without executing formulas; the new XLSX writer uses text cells so selected identifier spellings survive the data export. This is a data preparation tool, not a calculation or formatting-preservation engine.

A formula cell with a saved result can contribute that saved result. The workbook has not been recalculated by the tool, so its cache may be older than the source's current business state. If a selected formula has no usable saved result, the merge is blocked until you revise the selected region or provide a source workbook with a usable result.

Hidden rows and columns are separate from hidden sheets. Each selected table offers explicit inclusion settings for them. Review these settings even when every selected worksheet is visible. A visible sheet may contain hidden salary columns, old periods, or intermediate rows. The output is limited to your confirmed selection, and the source summary records the treatment of hidden content.

Suppose the first workbook has two records under id and value. The second workbook has three records under value and id, with its header on row three. Select the relevant Data sheet in each workbook, set the second header to row three and data start to row four, and choose Same column set. The output contains five records, with each identifier still paired with its own value.

Enable the source columns to include the originating workbook, worksheet, and source row. These generated column names are made distinct from user column names, so an existing _workbook field is not overwritten. The source summary gives the included record count for each table and the total can be checked as two plus three. An unselected hidden sheet contributes no data records.

Run complete input builds the selected result. Review the merged grid and Source summary, then choose an output scope and format. CSV is a single text table with a comma delimiter and optional UTF-8 BOM. XLSX is a new workbook containing the selected data representations as text cells. Neither output claims to preserve charts, original formulas, styles, comments, external connections, protection, or complex layout.

The CSV formula-protection option is explicit and its affected-cell count is shown during export verification. Disabling protection requires an acknowledgement because spreadsheet programs can interpret certain prefixes as formulas. Verify export and show summary reads generated data back before Confirm download new copy is enabled. Grid searches do not silently restrict the download; choose the intended report or main result in Export scope.

A reviewed result can continue to keyed comparison or duplicate removal. Merging itself does not remove duplicate records. If the same record appears in two source files, both occurrences remain unless you apply a separate deduplication rule. This preserves evidence when you need to determine whether repeated entries represent duplicate exports or legitimate separate transactions.

A schema error calls for reviewing target names and selected headers. An unresolved-cell error calls for reviewing formulas and error cells, not replacing them with blanks. A range or package error may require a smaller, valid XLSX export from the source application. Processing guards cover compressed and expanded size, worksheet count, declared ranges, cells, field length, and task duration. Cancel stops the worker; changes make old results stale; refreshing clears the local session.

Date interpretation follows Excel’s workbook date system. In the 1900 system, serial 60 is the historical Excel compatibility value shown as 1900-02-29, not a valid Gregorian date. Time-only cells should be reviewed using their displayed time; the tool does not convert serials into validated business dates or silently rewrite them.