How to Import Data in Excel?

Importing the data from another file or another source file is often required in Excel. For example, sometimes people need data directly from very complicated servers, and sometimes we may need to import data from a text file or even from an Excel workbook.

If you are new to Excel data importing, then in this article, we will take a tour of importing data from text files, different Excel workbooks, and MS Access. Follow this article to learn the process involved in importing the data.

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

#1 – Import Data from Another Excel Workbook

Like this, we can connect to the other workbook and import the data.

  • First, we must go to the “DATA” tab. Then, under the “DATA” tab, click on “Connections.” As soon as we click on “Connections,” we may see the below window separately. Now, click on “Add.” It will open up a new window. In the below window, select “All Connections.” If there are any connections in this workbook, it will show what those connections are here. Since we are connecting to a new workbook, click on “Browse for more.” In the below window, browse the file location. Then, click on “Open.” After clicking on “Open,” it shows the below window. 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 Connections” window. Then, go to “Existing Connections” under the “DATA” tab. Here, we will see all the existing connections. Select the connection we have just made and click on “Open.” Once we click on “Open,” it will ask us where to import the data. First, we need to select the cell reference here. Then, click on the “OK” button. It will import the data from the selected or connected workbook.

After clicking on “OK,” close the “Workbook Connections” window.

#2 – Import Data from MS Access to Excel

MS Access is the main platform to store the data safely. We can import the data directly from the MS Access File itself whenever the data is required.

Step 1: Go to the “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.“

Step 2: Now, it will ask us to locate the desired file. Select the desired file path. Then, click on “Open.”

Step 3: Now, it will ask us to select the desired destination cell where we 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 corporations, whenever we ask for the data from the IT team, they will write a query and get the file in TEXT format. But unfortunately, TEXT file data is not the ready format to use in Excel; we need to make some modifications to work on it.

Step 1: Go to the “DATA” tab and click on “From Text.”

Step 2: Now, it will ask us 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 5: 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 6: In the next window, click on “Finish.”

Step 7: Now, it will ask us to select the desired destination cell where we want to import the data. Select the cell and click on “OK.”

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

Things to Remember

  • If there are many tables, we must specify which table data we need to import.If we want the data in the current worksheet, we need to select the desired cell. Else, if we need data in a new worksheet, we must choose the new worksheet as the option.We need to separate the column in the TEXT file by identifying the common column separators.

This article is a guide to Import Data in Excel. Here, we discuss how to import data from 1) Excel Workbook, 2) MS Access, 3) Text File, practical examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –

  • KPI Dashboard in ExcelInsert Image in Excel CellHow to Insert New Worksheet In Excel?Create a Dashboard in ExcelPage Numbers in Excel