Connect To Text File Power Query. If it looks good press Edit. An X indicates that the connector is not.
![50 Things You Can Do With Excel Power Query Get Transform Microsoft Excel Excel For Beginners Microsoft Excel Tutorial](https://i.pinimg.com/originals/81/26/a8/8126a81a05f768418e294cb453753895.jpg)
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.