Combine worksheets from many workbooks into one—in a few clicks
Stop the repetitive copy-paste. Kutools for Excel's Combine Worksheets feature gathers sheets from multiple Excel files and lets you choose the best way to combine them — into one worksheet for analysis or into one workbook for organization. Perfect for monthly reports, branch files, or team submissions.
Kutools for Excel
The feature above is part of Kutools for Excel — which is included in the Kutools for Office Suite.
- ⚡ 300+ powerful tools and an AI assistant for Excel
- 🌍 Easy to use, with support for 44 languages
- ⏳ Simplify repetitive tasks and boost productivity
$49
Kutools for Office Suite
All-in-one package with 500+ features across Excel, Word, Outlook, PowerPoint & Office Tab.
Office Tab Pro
Kutools for Excel
Kutools for Outlook
Kutools for Word
Kutools for PowerPoint
$196 → $129
How the Combine Worksheets feature works
The wizard walks you through three clear steps. Add your files, choose how to combine, and let Kutools do the work.
Launch & choose combine mode
Go to Kutools Plus > Combine and choose a mode:
- Most popular for analysis: Combine multiple worksheets from workbooks into one worksheet (get a single master sheet).
- Most common for organization: Combine multiple worksheets from workbooks into one workbook (gather all sheets as tabs).
Add files or folders
Import multiple workbooks at once—or an entire folder. All worksheets are listed, and you can freely include or exclude them.
- Bulk add workbooks and CSVs
- Select or exclude specific sheets
- Preview the list before proceeding
Finish & save your results
Click Finish, pick a save location, and Kutools instantly merges every sheet into one worksheet/workbook.
- Save to your chosen folder
- A new workbook summarizing original files is generated
- Click the hyperlink to open the combined workbook instantly
Most popular for analysis: Combine multiple worksheets from workbooks into one worksheet
Merge data from many sheets into a single master sheet. Ideal for building a consolidated list — best when column headers match across files.
- ✔ One consolidated sheet, ready for PivotTables and reports.
- ✔ Optionally keep headers; skip blank sheets automatically.
- ✔ Ideal for monthly logs or branch files.
- ✔ Handle hundreds of sheets without errors.
- ✔ Select workbooks, sheets, or ranges — no copy-paste.
- ✔ Preserve formatting (fonts, colors, row heights).
💡 When to use: You want a big, clean dataset for analysis — e.g., monthly sales, regional logs, or survey results.
Most common for organization: Combine multiple worksheets from workbooks into one workbook
The fastest way to gather dozens of files into one Excel. This option takes every selected worksheet from each workbook (or CSV) and appends them as separate tabs in a single, clean file. No need to copy-paste, no formulas lost.
- ✔ One clean file with all sheets as tabs (e.g., Jan, Feb, ...).
- ✔ Original formats retained—no broken formulas or lost styles.
- ✔ Custom sheet naming (file name prefix, separator).
- ✔ Add files one by one, or import entire folders (XLSX/CSV).
- ✔ Generates a log sheet listing all source paths for traceability.
💡 When to use: You have many workbooks and want to review them in one place without mixing the data—finance month-end, regional sales, or student submissions.
🔎 Other combine options in the Combine Worksheets feature
Combine all same name worksheets into one worksheet
Target sheets that share the same name across workbooks (e.g., all “Sales”) and combine them. Perfect for standardized templates and departmental reports.
- Auto-select same-named sheets across files
- Ensures consistent structure for easy analysis
- Works great with monthly/region templates
Consolidate and calculate values across multiple workbooks into one worksheet
Combine ranges and auto-aggregate across files (Sum, Average, Count, etc.). Ideal for finance roll-ups and KPI dashboards.
- Pick functions (Sum, Avg, Count, Max/Min…)
- Match by headers or by cell positions
- Get one calculated summary worksheet
Purchase Kutools for Excel — choose the license that fits your needs
From small teams to large enterprises, Kutools offers tiered volume discounts so you pay less per license the more you buy.
Enterprise (100+)
Volume licenses & invoice support.
From $9.80 to $24.50 per license
Buy for EnterpriseGet Started with Kutools for Excel — Free for 30 Days
Experience the full power of Kutools for Excel with no limitations. Save time, reduce errors, and boost productivity — all risk-free.
✔ Over 300+ powerful tools
Data processing, formatting, worksheet management, and more.
✔ Integrated AI Assistant
Generate formulas, VBA codes, and automate tasks intelligently.
✔ Full-featured FREE trial
Explore all features with no limitations for 30 days.
✔ One-click uninstall
Zero risk — remove anytime with no system residue.
✔ Frequent updates
New features and improvements are added regularly.