How to Insert an Excel File into Another Excel File

To demonstrate how to insert one Excel file inside another, we’ll use the following two Excel files. The first contains Sales of Febuary for some Sales Reps.

Dataset1

In the other file, we have a dataset of Sales for January for the same Sales Reps.

Dataset2

Let’s insert one file into the other.

We used the Microsoft 365 version here, but you can use any other version at your disposal.


Step 1 – Use the Insert Tab

  • Select a cell where the Excel file will be inserted.
  • Go 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

  • In the Object dialog box that pops up, select the 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

Your folder opens.

  • Pick the Excel file to insert in the current Excel file.
  • Click on Insert.

Insert Excel File to another excel file

The file is now shown in the Object window.

  • Click OK.

Object window to insert an excel file into another excel file

The Excel file is inserted into the current Excel file at the specified location.

Insert excel file into another excel file


Download Practice Workbook


Related Articles


<< Go Back to Attach File in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Fahim Shahriyar Dipto
Fahim Shahriyar Dipto

Fahim Shahriyar Dipto is a graduate of Mechanical Engineering at BUET. With over 1.5 years of experience at Exceldemy, he authored 70+ articles on ExcelDemy. He has expertise in designing worksheets at You’ve Got This Math. Currently, He is a Team Leader at Brainor. Dipto's passion extends to exploring various aspects of Excel. Beyond tech, he enjoys creating engaging kids' worksheets using Illustrator. A dedicated employee and innovative content developer, He incorporates a commitment to academic excellence and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo