Chapter 39. Importing data from a text file or document

Question answered in this chapter:

Image 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 has been used by several NBA teams, including the Dallas Mavericks and New York Knicks. Every day during the season, Jeff’s FORTRAN program produces many bits of information, including ratings for each Dallas Mavericks lineup during each game. Jeff’s program produces this data in the form of a text file. In this chapter, I show you how you can import ...

Get Microsoft Excel 2016 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.