• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Get External Data in Excel

August 18, 2021 by Andrew Childress
How to get external data in Excel

When you work with Excel, it’s often useful to pull in data from other sources. Let’s learn how to get external data in Microsoft Excel.

When you work with Excel, it’s often useful to pull in data from other sources. These may include other spreadsheets, databases, text files, and more. Fortunately, this is easy to do, and saves you the effort of retyping existing data. Let’s learn how to get external data in Microsoft Excel.

How to Get External Data in Excel

External data may take a variety of forms and exist online, or in storage on your computer. Excel’s Data features offer you an easy way to import and access this data, so that you can use it in new spreadsheets. Imagine, for example, that you want to pull in data from another spreadsheet or HTML file.

To get external data in Microsoft Excel, begin by opening a new spreadsheet file, or one that you’re working in already. Then, find the Data tab. This sits on Excel’s ribbon, the list of tabs and menu options across the top of your screen.

Get external data in Excel

On the far left side of the Data tab, you’ll see the Get External Data dropdown menu. Click on it, and you’ll see a list of three options: From HTML, From Text, and New Database Query.From HTML lets you open data found in HTML files, along with Excel and .CSV files. From Text handles data contained within text files. And New Database Query lets you open data contained in databases or SQL servers.

Import external data Excel

To open an existing spreadsheet and pull data from it, click on From HTML. A Browse window will open. Find your file containing the other data, then click Open. The file will launch. Pull in the data by using cell references, or simply by copying and pasting it over to your working spreadsheet.

How to get external data in Excel

As you can see, it’s easy to get external data in Microsoft Excel. This lets you pull data from a variety of sources, with no need to retype or repeat work.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:typed accrued interest ExcelAccrued Interest in Excel
Next Post:Print Titles in ExcelSet print area menu Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top