Question: how to extract data from text file in excel?
Answer: Open the Excel spreadsheet where you want to save the data and click the Data tab.
In the Get External Data group, click From Text.
Select the TXT or CSV file you want to convert and click Import.
Select "Delimited". ... 
Click Next.