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.

In the "Import Text Files to Excel Workbook," select "Tab" under the "Delimiters" section -- this allows you to specify between columns/rows.