Working with Data in Text Files
Excel can read data in fixed-width as well as delimited text files. (A delimited file is one that uses some particular character or combination of characters to mark the boundaries between fields. In fixed-width files, fields are the same size in each record; space characters are added to fill blanks.) You can open a text file (by clicking File, then Open) or import it (by clicking the Data tab and then clicking From Text in the Get External Data group). If you want to be able to maintain a refreshable link to the source file, you need to do the latter.
When you open a comma-separated-values (.csv) file, Excel parses the data immediately into columns. If you open or import any other kind of text file, Excel presents ...
Get Microsoft® Excel® 2010 Inside Out 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.
