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.

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.