EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tools Excel Import Data
 

Excel Import Data

Ashwani Jaiswal
Article byAshwani Jaiswal
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 11, 2023

Import Data In Excel

 

 

Import Data In Excel

Microsoft has provided some functions that can be used to import data from different sources and connect them with Excel. We can import the data from different sources such as Access, Web, Text, SQL Server, or any other database. We can connect Microsoft Excel with many sources and import the data in many ways.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How To Import Data In Excel?

Let’s see how to import data in Excel by using some examples:

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

Import Data In Excel – Example #1

We often faced a situation where we needed to extract or import the data from other sources. And in Excel, we can use the function Get External Data to import the required fields to work from different sources.

We can extract the data in Excel by going into the Data menu tab, under getting and Transform data, select any required source as shown below.

Those options are shown in the below screenshot.

Import Data In Excel example 1-1

There are many different ways to import data in Excel.

  • From Text/CSV: Text files whose data can be separated with tab or Excel columns.
  • From Table/Range: Create a new query linked to the selected Excel table or named range.
  • From Web: Any website whose data can be converted to Excel tables.

Above mentioned ways of importing the data are majorly used. There are some other ways also, as shown in the below screenshot. For that, click on From SQL Server Database under From Database section. Once we do that, we will get a drop-down list of all the other sources from where we can import the data.

Import Data In Excel example 1-2

Once we import the data from any server or database, the connection gets established permanently till we remove it manually. And in the future, we can import the data from previously established and connected sources to save time. For this, go to the Data menu tab; under Get & Transform Data, select Existing Connections, as shown below.

Import Data In Excel example 1-3

Once we click on it, we will get a list of all existing connections we link with our computer, excel, or network, as shown below. Select the required connection point from that list and click Open to access that database.

Import Data In Excel example 1-4

Now let’s import some data from any website. We must have the link to the website from where we need to import the data. For example, we have considered the link to Wikipedia as given below.

Link: https://en.wikipedia.org/wiki/Fortune_India_500

Now, go to the Data menu; under Get & Transform Data section, select From Web as shown below.

Import Data In Excel example 1-5

Once we do that, we will get a Web Query box. There at the address tab, copy and paste the link and click on Go, as shown below.

Import-Data-In-Excel-example-1-6-2

It will then take us to the web page of that link, as shown below. Now click on the Import button to import the data.

Import Data In Excel example 1-7

The Import Data box will appear, asking for a reference cell or sheet to import the data. Here we have select cell A1 as shown below. And click on OK.

Import Data In Excel example 1-8

Then the query will run and fetch the data from the provided link, as shown below.

Import Data In Excel example 1-9

Import Data In Excel – Example #2

Let’s see another way of importing the data. For this, we have some sample data in Notepad (or Text) file, as shown below. As we can see, the data has spaces between the lines like columns in Excel has.

Example 2-1

Importing such data is easy as it is already separated with spaces. Now to import the data in the text file, go to the Data menu tab; under the Getting and Transform data section, select From Text option as shown below.

Example 2-2

After that, we will get a box asking us to browse the file. Search and select the file and click the Import button to process further.

Example 2-3

Select the Delimited option for a proper way to separate the data into columns, or select the Fixed Width option to do it manually. Just after that, a text import wizard will appear, which will ask us to delimit or separate the text. Here we have selected Delimited as shown below.

Example 2-4

Here we have delimited the text with Tab as shown below. Now click on Next to complete the process.

Example 2-5

Now select the way we want to import the data. Here we have selected cell A1 for the reference point and click on OK.

Example 2-6

We will see our data imported to Excel from the selected file.

Example 2-7

We can import the data from different sources or databases to Excel to work on them like this.

Pros of Importing Data in Excel

  • By importing the data from other sources, we can link different tables, files, columns, or sections and get the required data.
  • It saves time by manually copying and pasting the heavy data from one source to Excel.
  • We also avoid unnecessary crashing or handing off files if the data is huge.

Cons of Importing Data in Excel

  • Sometimes processing time is huge.

Things to Remember

  • Ensure you are connected to a good internet connection when importing data from SQL Servers or similar databases.
  • Do not do anything while data is imported from the source files or database. It may crash the opened files.
  • Always protect the previously established connection with a password.

Recommended Articles

This has been a guide to Importing Data in Excel. Here we discussed how to import data in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles to learn more –

  1. Auto Numbering in excel
  2. Watermark in Excel
  3. Enable Macros in excel
  4. Excel Uppercase Function

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Import Data in Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Import Data in Excel Template

EDUCBA

डाउनलोड Import Data in Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW