Import Data into Excel

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.

Import Data into Excel

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Import Data into Excel (wallstreetmojo.com)

#1 – Import Data from Another Excel Workbook

You can download this Import Data Excel Template here – Import Data Excel Template

Lets start.

  1. Go DATA Tab.Under DATA, click on Connections.


    Import Data Example 1

  2. As soon as you click on Connections, you will see the below window separately.


    Import Data Example 1-1

  3. Now click on ADD.


    Import Data Example 1-2

  4. It will open up a new window. In the below window, select All Connections.


    Import Data Example 1-3

  5. If there are any connections on this workbook, it will show what are those connections here.


    Import Data Example 1-4

  6. Since we are connecting a new workbook, click on browse for more.


    Import Data Example 1-5

  7. In the below window, browse the file location. Click on Open.


    Import Data Example 1-6

  8. After Clicking on open, it shows the below window.


    Import Data Example 1-7

  9. Here, we need to select the required table to be imported to this workbook. Select the table and click on, OK.


    Import Data Example 1-8

    After clicking on Ok, close the Workbook connection window.

  10. Go to Existing Connections under the Data Tab.


    Import Data Example 1-9

  11. Here, we will see all the existing connections. Select the connection we have just made and click on Open.


    Import Data Example 1-10

  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.


    Import Data Example 1-11

  13. It will import the data from the selected or connected workbook.


    Import Data Example 1-12

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 excelRibbon In ExcelThe ribbon is an element of the UI (User Interface) which is seen as a strip that consists of buttons or tabs; it is available at the top of the excel sheet. This option was first introduced in the Microsoft Excel 2007.read more and select From Access.

Import Data Example 2

Step 2: Now, it will ask you to locate the desired file. Select the desired file path. Click on Open.

Import Data Example 2-1

Step 3: Now, it will ask you to select the desired destination cell where you want to import the data then, Click on OK.

Import Data Example 2-2

Step 4: It will import the data from access to the A1 cell in Excel.

Import Data Example 2-3

#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.

Example 3

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.

Example 3-1

Step 3: It will open up a Text Import Wizard.

Text Import Wizard - Step 1 of 3

Step 4: By selecting the Delimited, click on NEXT.

Text Import Wizard - Step 1 of 3

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.

Text Import Wizard - Step 2 of 3

Step 3: In the next window, also click on FINISH.

Text Import Wizard 3-5

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.

Example 3-6

Step 6: It will import the data from the text file to the A1 cell in Excel.

Example 3-7

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.

Recommended Articles

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 –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>