Connect to a Text file

  1. In the POWER QUERY ribbon tab, click From File > From Text.
  2. 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.

Formula Example

= Table.FromColumns({Lines.FromBinary(File.Contents("C:\sample.txt"),null,null,1252)})

Applies to:
Excel 2013, Excel 2010