Chapter 39 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 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, in the form of a text file. In this chapter, I show you how you can import a text file into Microsoft Excel to use it for data analysis.
Answers to this chapter’s question
How can I import data from a text file ...
Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition 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.
