If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Import text as range in excel 2019

Thread starter Diolu
Start date Feb 20, 2020
Tags

import .txt

Diolu

New Member

Feb 20, 2020

I used to import tab separated text files as a range in previous version of Excel. I can still do it by enabling the "legacy" import wizard in Excel 2019; I can't find an easy way to achieve my end with the new power query of Excel 2019. I systematically get an Excel table which is not what I want. Although it is possible to convert the table as a range afterwards (In Design -> Convert as range); this will break the connection to the text file and so it won't refresh if the file change. Anyone has a solution? There are lots of options in this new power query I may have missed something.