How to Merge Multiple Excel Sheets Into One Workbook

Quick Answer

To merge multiple Excel sheets into one workbook, pick the path that matches your starting point. Path A: If all sheets already live in one open file, use Move or Copy on sheet tabs to reorder or duplicate tabs inside that workbook. Path B: If sheets sit in separate .xlsx files, open the target workbook in WPS Spreadsheets, then copy each sheet from the source files into that target using Move or Copy. WPS Office is described as a free all-in-one suite to edit Word, Excel, and PPT per WPS Academy—WPS Spreadsheets is the primary desktop path for managing multiple sheet tabs in one .xlsx workbook. Save the result as .xlsx and verify formulas and layout against your source files before relying on the merged workbook in production.

Key Facts

Two Ways to Merge Sheets (Overview)

Spreadsheet "merge" means consolidating worksheet tabs into one .xlsx workbook—not combining PDF files or converting document types. Most editors use the same core idea: each sheet is a tab at the bottom of the window, and you copy or move tabs until everything sits in one file.

Path A — within one workbook: You already have multiple tabs in a single file and want to reorganize them, remove extras, or duplicate a tab before renaming it.

Path B — from multiple files: Each source file has one or more sheets you need in a single target workbook—for example, monthly reports stored as separate .xlsx files that should become one annual file.

Both paths rely on the Move or Copy sheet command found in WPS Spreadsheets, Excel for the web, and LibreOffice Calc. The difference is whether the source sheet stays in the same file or comes from another open workbook.

Before You Merge: Sheet Names, Formats, and Compatibility

A smooth merge starts with a short checklist:

1. Rename duplicate sheet names. Excel-class workbooks cannot keep two tabs with identical names. If both files contain a tab called Sheet1, rename one before or immediately after copying.

2. Confirm .xlsx format. This guide covers native Excel workbook merge. PDF merge, PDF-to-Excel conversion, and other document workflows are out of scope.

3. Verify compatibility on your files. WPS pricing page states 100% Compatible with Microsoft File Formats for Office Tools—treat this as a starting point and verify merged .xlsx workbooks against source files before relying on formulas, charts, or layout. The same caution applies when opening merged files in Excel for the web or LibreOffice Calc.

4. Note advanced features. Macros, VBA, pivot tables, and Power Query connections may not transfer identically across apps or after copy operations. Test the merged workbook rather than assuming full parity.

How to Merge Sheets in WPS Spreadsheets

WPS Office is described as a free all-in-one suite to edit Word, Excel, and PPT per WPS Academy. For sheet merge tasks, open WPS Spreadsheets—the spreadsheet module where you manage workbook tabs. WPS is available on Windows, macOS, Linux, iOS, and Android per WPS Academy download banner; desktop offers the most straightforward tab-management workflow for multi-file merges.

Path A: Reorder or Copy Tabs Within One Workbook

1. Open the workbook in WPS Spreadsheets.

2. Right-click the sheet tab you want to move or duplicate.

3. Choose Move or Copy (wording may vary slightly by platform).

4. Select the destination position in the tab list. Check Create a copy if you want a duplicate tab instead of moving the original.

5. Click OK and rename the new tab if needed.

Path B: Copy Sheets From Separate .xlsx Files Into One Workbook

1. Open WPS Spreadsheets and open (or create) your target workbook—the file that will hold all merged sheets.

2. Open each source .xlsx file in a separate window or tab so both workbooks are accessible.

3. In the source workbook, right-click the sheet tab you want to bring over.

4. Choose Move or Copy.

5. In the To workbook list, select your target workbook.

6. Check Create a copy so the original source file keeps its sheet.

7. Pick the tab position in the target workbook and click OK.

8. Repeat steps 3–7 for every sheet you need from each source file.

9. Rename any duplicate tab names and delete tabs you no longer need.

10. Save the target workbook as .xlsx.

   

WPS Spreadsheets shows blank workbook options and ready-to-use templates when you start a new file per the official spreadsheet guide—the same environment where you manage sheet tabs during a merge.

Learn More About WPS Spreadsheets

• Spreadsheet guide: How to use WPS Office Spreadsheet

• What is WPS Office: WPS Office overview

• Compatibility details: WPS pricing and compatibility

How to Merge Sheets in Excel for the Web

Word, Excel, and PowerPoint for the web are free with a Microsoft account and include 5 GB OneDrive storage per Microsoft's free Office online page. Excel for the web supports organizing data and collaborating online in the browser.

To merge sheets in Excel for the web:

1. Sign in with a Microsoft account and open the target workbook in Excel for the web.

2. Open each source workbook in another browser tab if needed.

3. Right-click the source sheet tab → Move or Copy.

4. Select the target workbook from the list, choose Create a copy, and confirm.

5. Repeat for each sheet, then rename duplicates and save to OneDrive.

Excel for the web runs in a browser on any OS. Editorial check: web Excel may lack macros/VBA and some advanced features—test merged workbooks before production use.

How to Merge Sheets in LibreOffice Calc

LibreOffice Calc is the spreadsheet module in the free, open-source LibreOffice suite. LibreOffice Writer is compatible with Microsoft Word (.doc, .docx) per the official Getting Started guide; the suite is free and open source. Calc uses the same suite-level format support—verify merged .xlsx files before migration.

To merge sheets in Calc:

1. Open the target workbook in LibreOffice Calc.

2. Open each source .xlsx file.

3. Right-click the source sheet tab → Move/Copy Sheet.

4. Choose Copy, select the target document, and set the insert position.

5. Repeat for each sheet, rename duplicates, and save the merged file.

Calc runs on desktop Windows, macOS, and Linux. There is no official mobile or web Calc editor from The Document Foundation for on-the-go sheet merging.

Save and Verify Your Merged Workbook (.xlsx)

After all tabs sit in one workbook:

1. Save As .xlsx if the file is not already in Excel format.

2. Close and reopen the merged workbook to confirm every expected tab is present.

3. Spot-check formulas, named ranges, charts, and filters on a sample of sheets—especially if source files used different Excel versions or features.

4. Verify against source files per WPS compatibility guidance: open the original sources side by side and compare key totals or pivot outputs.

WPS states Microsoft Office file format compatibility on its pricing page. No spreadsheet app guarantees identical behavior for every macro, pivot, or third-party add-in—per-file verification remains the safe workflow.

FAQ

What if two sheets have the same name?

Rename one tab before saving. Every sheet tab in a workbook must have a unique name. Most editors append a suffix like Sheet1 (2) when a conflict occurs—you can rename it to something meaningful such as March_Sales.

Will formulas update correctly after I merge sheets?

Cell references that point within the same sheet usually carry over. References to other sheets may break if sheet names change during merge. After copying tabs, click through critical formulas and confirm cross-sheet links resolve to the intended tab names.

Can I merge sheets on WPS mobile or iPad?

WPS is listed for Windows, macOS, Linux, iOS, and Android per WPS Academy. Mobile surfaces may offer limited tab-management options compared with desktop. For multi-file merges involving several source workbooks, desktop WPS Spreadsheets is the more practical path.

Should I use WPS Spreadsheets or Excel for the web?

Choose WPS Spreadsheets when you want a free desktop spreadsheet editor to open, edit, and save .xlsx workbooks locally across major platforms. Choose Excel for the web when you already use a Microsoft account, prefer browser editing, and store files in OneDrive. Both support basic sheet-tab copy workflows; verify your specific merged file in the app you plan to use daily.

Does merge preserve Excel macros and VBA?

Do not assume macro or VBA preservation after copying sheets between files or apps. Test macro-enabled workbooks in your target editor. This guide does not cover macro migration or VBA parity.

Sources and Last Reviewed

Last reviewed: 2026-06-30