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

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language