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.

How to open a .csv file in Excel Opening a .csv file is as easy as opening a .txt file, and usually, you won’t have to clean up the data before doing so because the save task inserts the delimiter.

Import data 1. Open a blank Excel spreadsheet and use the instructions from “Excel pro tips: Importing and parsing data.” Note that all the information imports into one field, so you must ...

You can click "CSV" to export the file into a comma separated text file, or you can click "XLS" to export the data to a file you can open with Excel without importing the file into the application.

Excel carries out text recognition and displays the data found in the right-hand side of your spreadsheet. There you can check the data or insert it directly into the spreadsheet.