Import a Worksheet from One Workbook to Another in Excel

In Excel, you can quickly copy an entire worksheet from one workbook to another workbook.  This allows you to import data from other workbooks with ease and without having to copy/paste everything between the worksheets.

Steps to Import a Worksheet from Another Workbook in Excel

1. Make sure that you have both workbooks open, the one that has the data you want and the one to which you will import the worksheet.
2. Go to the Excel workbook that contains the worksheet that you want to export.
   
3. Right-click on the tab of the worksheet that you want to export and click Move or Copy...
   
   
4. In the window that opens up, select the workbook where you want the data to be from the To book: drop down menu:
   
5. Choose if you want the worksheet to be placed before a specific worksheet in the new workbook or at the end of all of the worksheets:
   
6. Make sure to check the option Create a copy so that the worksheet will be copied or imported into the new workbook instead of completely moved there, which would remove the worksheet from the original workbook altogether.
   
7. Hit OK and you will then be taken to the other workbook, the one to which the worksheet was imported.
   

Notes

This is a much better way of importing data between workbooks in Excel than just selecting all of the data and copy/pasting.  With the method above, you are assured of importing all of the data from the worksheet and having it look exactly the same, all the while only taking a few seconds.

Make sure you check the Create a copy check box so that you will not remove the worksheet from the source workbook.  This is an easy mistake to make and you might not notice it for a while.

Download the accompanying workbooks so you can test out this feature of Excel.