How to Import Data in Excel?
Importing the data from another file or from another source file is often required in excel. Sometimes people need data directly from servers, which are very complicated in nature, and sometimes we may need to import data from a text file or even from an Excel workbook as well.
If you are new to excel data importing, then this article, we will take a tour on importing data from text files, from different excel workbooks, and from MS Access as well. Follow this article to learn the process involved in importing the data.
#1 – Import Data from Another Excel Workbook
Step 1: Go DATA Tab. Under DATA, click on Connections.
Step 2: As soon as you click on Connections, you will see the below window separately.
Step 3: Now click on ADD.
Step 4: It will open up a new window. In the below window, select All Connections.
Step 5: If there are any connections on this workbook, it will show what are those connections here.
Step 6: Since we are connecting a new workbook, click on browse for more.
Step 7: In the below window, browse the file location. Click on Open.
Step 8: After Clicking on open, it shows the below window.
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
Step 9: Here, we need to select the required table to be imported to this workbook. Select the table and click on, OK.
After clicking on Ok, close the Workbook connection window.
Step 10: Go to Existing Connections under the Data Tab.
Step 11: Here, we will see all the existing connections. Select the connection we have just made and click on Open.
Step 12: As soon as you click on Open, it will ask you where to import the data. You need to select the cell reference here; then, click on the Ok button.
Step 13: It will import the data from the selected or connected workbook.
Like this, we can connect the other workbook and import the data.
#2 – Import Data from MS Access to Excel
MS Access is the main platform to store the data safely. Whenever the data required, we can import the data directly from the MS Access File itself.
Step 1: Go to DATA ribbon in excel and select From Access.
Step 2: Now, it will ask you to locate the desired file. Select the desired file path. Click on Open.
Step 3: Now, it will ask you to select the desired destination cell where you want to import the data then, Click on OK.
Step 4: It will import the data from access to the A1 cell in Excel.
#3 – Import Data from Text File to Excel
In almost all the corporates, whenever you ask the data from the IT team, they will write a query and get the file in text format. TEXT file data isn’t the ready format to use in excel; we need to make some kind of modifications of work on it.
Step 1: Go to the DATA tab and click on From Text.
Step 2: Now, it will ask you to choose the file location on the computer or laptop. Select the targeted file then, Click on Import.
Step 3: It will open up a Text Import Wizard.
Step 4: By selecting the Delimited, click on NEXT.
Step 2: In the next window, select the other and mention comma (,) because, in the text file, each column is separated by a comma (,) then, click on NEXT.
Step 3: In the next window, also click on FINISH.
Step 5: Now, it will ask you to select the desired destination cell where you want to import the data. Select the cell and click on OK.
Step 6: It will import the data from the text file to the A1 cell in Excel.
Things to Remember
- If there are many tables, you need to specify which table data you actually need to import.
- If you want the data in the current worksheet, then you need to select the desired cell, or else if you need data in a new worksheet, then you need to choose the new worksheet as the option.
- In the TEXT file, we need to separate the column by identifying the common column separators.
This has been a guide to Import Data in Excel. Here we discuss how to import Data from 1) Excel Workbook, 2) MS Access, and 3) Text File along with practical examples and a downloadable excel template. You may learn more about excel from the following articles –