Chapter 38. Importing data from a text file or document

Question answered in this chapter:

  • How can I import data from a text file into Excel so that I can analyze it?

Jeff Sagarin, the creator of the USA Today basketball and football ratings, and I have developed a system to rate NBA players that several NBA teams have used, including the Dallas Mavericks and New York Knicks. Every day during the season, Jeff’s FORTRAN program produces a multitude of information, including ratings for each Dallas Maverick lineup during each game. Jeff’s program produces this information in the form of a text file. In this chapter, you see how you can import a text file into Microsoft Excel to use it for data analysis.

Answer to this chapter’s question

This section ...

Get Microsoft Excel 2013: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.