Connect to a Text file (Power Query)
Connect to a text file from Power Query
In the Power Query ribbon tab, click From File > From Text.
In the Browse dialog box, browse for or type a file path to import or link to a file.
After the connection succeeds, you will be able to preview the lines of text in the file.