O'Reilly logo

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14

Importing Data into Excel

Understanding External Data

External data is data that resides outside of Excel in a file, database, server, or website. You can import external data into an Excel worksheet for additional types of data analysis. A vast amount of data exists in the world, and most of it resides in some kind of non-workbook format. Some data exists in simple text files, perhaps as comma-separated lists of items. Other data resides in tables, either in Word documents or, more likely, in Access databases. There is also an increasing amount of data that resides in web pages and in XML files.

By definition, all this data is not directly available to you via Excel. However, Excel offers a number of tools that enable you to import ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required