How to Insert an Excel File into Another Excel File

Get FREE Advanced Excel Exercises with Solutions!

Sometimes, we may deal with a lot of data in our worksheets. So it became very hard to maintain one worksheet for all the data. Maintaining two or more worksheets can meet our necessity. Inserting an Excel file into another is an easy task to do. In this article, we have discussed how to insert an Excel file into another Excel file. So, let’s get started.


How to Insert an Excel File into Another Excel File: with Easy Steps

Let’s introduce the two separate Excel files first. Here we have taken one Excel file of Sales of January of the Sales Rep.

Dataset1

In the other Excel file, we have taken a dataset of Sales for February for the Sales Rep.

Dataset2

Not to mention, we have used the Microsoft 365 version. You can use any other version according to your preference.

Now, let’s grasp the 3 simple steps to insert an Excel file into another Excel file.


Step 1: Use the Insert Tab

  • First of all, select a random cell where you can put an Excel file to your current Excel file.
  • Secondly, move to the Insert tab >> click on the drop-down option of the Text command >> pick Object from the options.

Use the Insert Tab to insert an excel file into another excel file

Read More: How to Attach Documents in Excel


Step 2: Apply the Object Command

  • An Object dialog box pops up. Then select Create from File option and pick Browse.

Apply the Object Command to insert an excel file into another excel file

Read More: [Fixed!] Cannot Insert Object in Excel


Step 3: Insert Excel File

  • Consequently, your folder opens. Now, pick the exact Excel file that you want to input in the current Excel file. Click on Insert.

Insert Excel File to another excel file

  • The file is now created in the Object window. Hit OK.

Object window to insert an excel file into another excel file

Finally, you have added your Excel file to the current Excel file!

Place anywhere on the sheet that seems suitable for you. See the below image to get a proper idea.

Insert excel file into another excel file


Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.


Conclusion

That’s all about today’s session. Please let us know in the comments section if you have any questions or suggestions. For a better understanding please download the practice sheet. For any further queries, comment below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Fahim Shahriyar Dipto
Fahim Shahriyar Dipto

Hello! Welcome to my Excel blog! I am a big fan of MS Excel. I am learning new and exciting things in Excel and writing the process here. I think this will be helpful for you to get used to Excel. Keep visiting our website for new and updated Excel methods.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo