How to Convert a Text File Into a Spread Sheet
- 1). Log on to your computer and open the spreadsheet program. Click the "File" menu and choose "Open" from the list.
- 2). Locate the drop-down box next to "Files of Type" and change it to "Text Files." Browse to the text file you wish to convert.
- 3). Choose whether to import the text file in delimited or fixed-width format. Choose delimited if each field in the text file is separated by a comma, semicolon, colon, space, tab or other character. Choose fixed width if the fields in the text file are all the same width.
- 4). Click "Next." to continue and add field names if you wish. If the text file already contains field names, those field names will be filled in by default, but you can change them if you wish.
- 5). Verify that the field names are what you want, then click "Finish" to complete the conversion. Save the spreadsheet to your hard drive or network share.
Source...