Merge Multiple Excel Files Into One Sheet Online Free

  1. Excel Combine Data From Multiple Sheets
  2. Software To Merge Excel Files
  3. Merge Multiple Excel Files Into One Sheet online, free

Quickly merge / combine worksheets / workbooks or csv files into one workbook in Excel

You can refer to the steps mentioned by Rena to link the results of your three forms into one workbook using data connection. Data tab Get Data From File From WorkbookSelect the workbook that you want to connect the data fromImportSelect the sheet that you want to import data from (Data connection in not available in Excel Online). Merge Excel Free online. This page can merge excel workbooks into one new workbook with multiple worksheets.

Kutools for Excel

When it comes to merge or combine multiple worksheets / workbooks or csv files into one workbook, most of us will think about copying and pasting the worksheets into one workbook. But if there are lots of worksheets need to be merged by such way, it will waste much time.Kutools for Excel augments Excel this powerful feature – Combine. With this utility you can easily:

Merge / combine multiple worksheets or workbooks into one workbook

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

Click Kutools Plus >> Combine. See screenshots:

Merge / combine multiple worksheets or workbooks into one workbook

Supposing you have Workbook A, Workbook B and Workbook C, and you want to merge or combine all worksheets of those workbooks into one workbook. You can get it done as follows:

1. Please apply the Combine Worksheets utility by clicking Kutools Plus > Combine. Click OK in the following popping up Kutools for Excel dialog.

2. In the Combine Worksheets wizard, please select Combine multiple worksheets from workbooks into one workbook option, and then click Next button. See screenshot:

Merge multiple excel files into one sheet online, free pdf

3. All the opened workbooks and corresponding worksheets are listed in the Workbook list and Worksheet list boxes, you can click Add > Files… or Folder… button to add the workbooks that you want to merge. See screenshot:

Tips:

A. Add workbooks to merge

Click Files… under Add button, you can add one workbook or multiple workbooks into Workbook list. If you click Folder… and specify a folder, all workbooks in the specified folder are added into Workbook list at once.
If you click Folder…, it will automatically add all workbooks in a specific folder into Workbook list to merge.
If you click OneDrive Files or OneDrive Folder, it will automatically add one or multiple OneDrive files from one folder or different folders as you need.

B. Remove workbooks from the Workbook list box

Excel Combine Data From Multiple Sheets

You can click the button to remove a workbook from the Workbook list box.

Click the Remove all button can remove all workbooks from the Workbook list box at once.

C. Open workbooks which has been encrypted with password:

If you want to combine the workbooks which has been encrypted with passwords, please click the Password button.

In the Password Manager window, click the Add button, enter the workbook password into the Password textbox, fill in the label and click the OK button. Repeat the operation until all workbooks’ passwords are added to the manager, and then click the OK button to close the window. See screenshot:

D. Save or access one scenario of your operation:

If you want to save the settings of Step 2 in Combine Worksheets for future operations, click Scenario > Save… button, and then name the scenario in the popping up dialog. By doing so, you don’t need to add workbooks or specify the worksheets again and again in the future, you just need to click the Open button to choose the scenario item you have saved.
Besides, you can click the Manage button to get into the Manage Scenario window to manage the saved scenarios as you need.

E: Sort all listed workbooks and worksheets in the dialog:

From the Sort drop down lists, you can sort the listed workbooks or worksheets as your need.

F. What’s the Same sheet button? At the bottom of the Worksheet list, there is a Same sheet button. With this button, you can easily select all worksheets with same worksheet name across all the checked workbooks in the Workbook list. For example, there are 3 workbooks that have been checked in the Workbook list, if you click on the Sheet3 as shown in the below screenshot, it will immediately select all worksheets with same worksheet name across the 3 checked workbooks after clicking Same sheet button. See screenshots:


Every Sheet3 in each checked workbook has been checked

4. After adding and specifying the workbooks and worksheets you want to combine or merge, please click the Next button. In the Step 3, please configure following options:

1. To merge blank / empty worksheets or not:

If your workbooks contain blank or empty worksheets, you can keep or skip the blank worksheets.

2. Insert worksheet information:

If you check this option, the workbook information will be inserted at first row of each worksheets as comment in the combined workbook.

3. Rename worksheet names after merging:

If you want to insert or add the original workbook name into the worksheet names after merging, please check By inserting workbook name option and specify the location where you want to insert the workbook name. You can insert it before or after the original worksheet name. At the same time, you can specify a separator between the workbook name and worksheet name.

If you don't want to insert or add the workbook name into worksheet names, please uncheck By inserting workbook name option.

5. Click Finish button to merge the worksheets, after combining the sheets, a Specify the file name and location for the combined workbook window is popped out, you can specify a file name and location for your combined file, and then click the Save button. See screenshot:

Note: If you haven't saved the workbook and worksheet settings as scenario, a Kutools for Excel window will pop up to remind you to save the scenario. If you decide to save it, click the Yes button and name it in the next Save Scenario dialog. Otherwise, click the No button. See screenshot:

A new workbook is created and status of the combined workbooks are listed inside. You can click the Output file link to open the combined workbook directly.

Then multiple worksheets or workbooks have been combined into a new workbook. In the new workbook, there will be a worksheet which names Kutools for Excel, and it contains detailed information about the new workbook as shown in the below screenshot.

Note: If you think the Combine feature is useful, you can click button to share it to your friends.

Do you want to know how to merge or combine all same name worksheets from different workbooks into one worksheet? Please refer to Quickly merge / combine all worksheets of same name across workbooks into one worksheet.

Demo: Quickly merge / combine worksheets / workbooks or csv files into one workbook in Excel

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

EXMERG is online productivity tool for merging data from multiple worksheets or CSV files using Drag&Drop. You can combine tables into single master table or merge data by custom rules, all managed by simple and easy to use user interface.

“It worked perfectly! Seems like magic that one can do this on the web so easily!”

Eric Corning, COO at Seafair

Features

Combine tables into single master table

Merge multiple excel files into one sheet online, free printable

Merge data spread across tens or hundreds of files.

Merge data by custom rules

Create rules to join tables from different files and discover relations in your data.

Consolidate data across rows and columns

Detect duplicates or extract unique values using Drag&Drop.

Visualize and analyze your data

Get interactive insight into your data with dynamic charts.

Automatic XLS, XLSX and CSV files processing

Simply drag your Excel or CSV files to the browser and have them processed.

Instant paging, sorting and full text search

Works out of the box for all uploaded files.

Share selected workbooks

Make selected files available for your co-workers, or share whole workspace.

Export results

Download results or save them into your workspace for later.

Have Questions to ask?

EXMERG is an application for merging and consolidating data from Excel workbooks or CSV files. It transforms data into comprehensible structure and makes it easy to quickly perform tasks which could otherwise take hours.

Software To Merge Excel Files

We deeply respect the trust of our users who upload their precious data into our service. One of our main tasks is to make sure your data are protected and stored in highly secured environment. There is no 3rd party access to your data, ever. We carefully use sample data from our users to test algorithm improvements.
Please use our issue tracking system to submit bug or feature request.
Do you offer enterprise version of EXMERG (hosted in private network) ?
If customer requires complete control over the server which runs EXMERG, there is an option to have it installed into private enterprise network. The other possibility is private cloud hosting, in which EXMERG instance runs in the cloud, but with special setup which guarantees exclusive access for the customer. For more information please contact [email protected]

Our customers

Needing to merge four exported CRM csv worksheets, it was a daunting task and I would consider myself a power Excel user. Excel seemed to make it harder than it needed to be so a quick browse and I came upon Exmerg which brought together the fields easily. A quick “concatenate and sort” afterwards and I saved hours of painstaking copy and pasting. Thanks!
Really love that the site is user-friendly and easy to use but yet is really powerful under-the-hood!
The tool was exactly what I needed! It worked flawlessly and was extremely easy to use. Thank you!
I’ve always struggled with how to merge multiple Excel files into one without resorting to some sort of statistical program like SPSS. Your website did the job BEAUTIFULLY. I bookmarked it and will be returning the next time I need to do something like that.

Merge Multiple Excel Files Into One Sheet online, free

Did anything go wrong while merging your data? Call us today at +421 918 972 459 or Email us at [email protected]

Get in touch and let us know how we can help.