GluecutPrivate document merger
Spreadsheet workflow

Merge Excel workbooks in your browser.

A spreadsheet can look correct while holding broken references underneath. This workflow treats sheet order, formulas, workbook names, data validation, and external links as separate things to verify.

Define what “merge” means

For Gluecut, combining compatible workbooks means assembling their worksheets into a single workbook in the chosen order. It does not mean appending every row into one normalized table or reconciling columns with different meanings. If you need a database-style union, clean the data with Power Query, a script, or another repeatable transformation and document the rules.

Audit source workbooks

Make working copies and open them in Excel or a compatible application. Record each workbook's sheet names, visible totals, named ranges, tables, charts, pivot tables, external connections, and macros. Rename duplicate sheet names in advance with short, meaningful identifiers. Refresh data only when you trust the connections, then save known values in the copies.

External formulas such as links to another workbook may break when sheets move into a new package. Formulas that use workbook-scoped names can also conflict. Check for hidden and very hidden sheets because a seemingly empty source can contain lookup tables or calculation logic.

Combine and preserve the originals

Open Gluecut, choose the compatible workbook copies, and arrange their worksheets in the desired order. Processing happens in your browser; the selected workbook contents are not uploaded to a Gluecut conversion server. Download the result under a new filename, leaving source and output files side by side for comparison.

Do not use a browser merger as a macro migration tool. VBA projects, ActiveX controls, external data connections, advanced charts, data models, and vendor-specific spreadsheet features may not be preserved by general JavaScript workbook libraries.

Validate numbers, not just appearance

Open the combined workbook in Excel and check for repair warnings. Confirm sheet count, names, visibility, tab colors, order, print areas, frozen panes, merged cells, conditional formatting, and data validation. Recalculate the workbook, then compare control totals and key outputs with the sources. Search formulas for #REF!, external workbook brackets, and unexpected errors.

Test a representative input cell and confirm that dependent formulas update. Inspect chart series and pivot sources. Check workbook-scoped and sheet-scoped names in Name Manager. If recipients use a different spreadsheet program, test there too; calculation engines can interpret dates, formulas, and unsupported functions differently.

Use a controlled alternative when needed

For financial reporting, regulated datasets, macros, signed workbooks, protected models, or repeatable monthly consolidation, use an approved desktop or scripted workflow with version control and reconciliation totals. Local browser merging is suitable for ordinary compatible sheets when a human will inspect the result.