Teach Yourself VISUALLY Excel 2016

CHAPTER 8

Importing Data into Excel

Excel offers a number of tools that enable you to import external data into the program. Excel can access a wide variety of external data types. However, this chapter focuses on the six most common types: data source files, Access tables, Word tables, text files, web pages, and XML files.

Understanding External Data

Import Data from a Data Source

Import Data from an Access Table

Import Data from a Word Table

Import Data from a Text File

Import Data from a Web Page

Import Data from an XML File

Refresh Imported Data

Separate Cell Text into Columns

Understanding External Data

External data is data that resides ...