Chapter 27
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 I can analyze it?
Together with Jeff Sagarin, the creator of the USA Today basketball and football ratings, 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 ...
Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th 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.
