EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel Import Data
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Excel Import Data

By Ashwani JaiswalAshwani Jaiswal

Import Data In Excel

Excel Import Data (Table of Contents)

  • Import Data In Excel
  • How To Import Data In Excel?

Import Data In Excel

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

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

Many times we faced a situation where we need 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.

Start Your Free Excel Course

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

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

Those options are shown in the below screenshot.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,639 ratings)

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 a tab or excel columns.
  • From Web: Any website whose data can be converted to excel tables.
  • From Table/Range: Create a new query linked to the selected Excel table or named range.

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 which we link with our computer or excel or network, as shown below. From that list, select the required connection point and click on Open to access that database.

Import Data In Excel example 1-4

Now let’s import some data from any website. For that, we must have the link to that website from where we need to import the data. Here, for example, we have considered the link of 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 it will 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 where it will ask us to browse the file. Search and select the file and click on the Import button to process further.

Example 2-3

Just after that, a text import wizard will appear, which will ask us to delimit or separate the text. Select the Delimited option for a proper way to separate the data into columns or select the Fixed Width option to do it manually. 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

Like this, we can import the data from different sources or databases to excel to work on them.

Pros of Importing Data in Excel

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

Cons of Importing Data in Excel

  • Sometimes processing time is huge.

Things to Remember 

  • Make sure you are connected to a good internet connection when you are importing data from SQL Servers or similar databases.
  • Do not do anything while data is being 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 along with 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
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Import Data in Excel Template

EDUCBA

Download Import Data in Excel Template

EDUCBA

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

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more