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.

Quick tip: Excel files can only be opened by Excel or Google Sheets whereas CSV files can be opened by any text editing program, such as Notepad or TextEdit. How to open a CSV file in Microsoft ...