Appendix C. Importing Data for PivotTables

Understanding External Data

External data is data that resides outside of Excel in a file, database, server, or Web site. You can import external data into Excel either directly into a PivotTable or into a 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 nonworkbook 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 ...

Get Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.