To import data from a text file into Microsoft Excel, follow this step-by-step guide: First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC.

Unfortunately, Microsoft Excel doesn't include a one-step method for importing a file list from Windows Explorer, but Windows 7 offers an easy workaround.

Go to File > Save as. Save the file as XLS or XLSX. First, open the Microsoft Word app and click on the File > Open option to import the source DOC or DOCX file that you want to convert to Excel.

However, using workbooks in Excel, one would need to save each page of the workbook as a .csv file, then import it, which could get rather cumbersome when dealing with many large workbooks, as I am.