Question: how to extract data from text file?
Answer: Copy and paste the raw text file into your spreadsheet. Select the entire column. Move the ribbon to “Data” and look for the Data Tools section. Click Text to Columns. ...  Select original data type “Delimited – Characters such as commas or tabs separate each field” and click Next.