Connect To Text File Power Query. If it looks good press Edit. An X indicates that the connector is not.

The Import Data window will open. Power Query will open a new window and display a sample of the data. From the Data ribbon Click Get Data - From File - From TextCSV.
Example of how to import data from a text file with Power Query.
Then go I to power pivot and select existing connections and find the query. Extract the latest file from the folder. To import data from a text file to Excel with Power Query follow these 5 steps. Open a new workbook and create a new query using a CSV file.