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.

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.