Importing data from a Text file

Many a times we get data in the form of a simple .TXT file as shown in the below figure.



The data from a text file which is in proper format can be imported in Excel file very easily.

STEP 1: Save the Text file on your local machine.

STEP 2: Navigate to Data tab in the ribbon and click on 'From Text' option in 'Get External data' section. Provide the path of the file.

STEP 3: Navigate through the pop-up window and select right delimiters. Data will be shown in Excel as below.