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 ...