Excel 2016 Please return the "enable: all files" in the text import box so we can import files that have extensions other than .txt
Excel 2011 had the option at the bottom to switch to "all files" when importing text files so that files that had extensions other than .txt would not be greyed out. This is now gone in Excel 2016 so it is impossible to import text files that have other file extensions unless you rename them (which is very impractical for me).
Please put the option back! I want to be able to import .dat, .ici, .ocw and so on as I used to on Excel 2011.
I also work in bioinformatics and am unable to open files like I used to. Version 16 on Mac. I used to hit the button that enabled it to see all files. Why remove that? I'll simply figure out how to script what I needed from excel using a different method and forget about excel. Not a good approach for Microsoft.
Annemarie Honegger commented
For users who use EXCEL in a scientific context (bioinformatics) this change is extremly limiting, as the ASCII text files generated by countless UNIX programs use the file extention to indicate the type of data contained in the text file.
The windows version of EXCEL2019 allows to enter other extensions in the File name field of the "Open File" dialog, while at the same specifying a text file. Why can't the window version do the same
Also, probably linked, under visual basic, "Workbooks.OpenText" seems to be similarly broken, pretending that the file does not exist, while "line input" works fine with exactly the same list of filepaths, filenames and extensions
agreed, this is a very stupid downgrade
Microsoft please return the enable option in the Open Dialog also.
Ralph W Callaway commented
Not to mention a big industry standard on Pipe Separated Files ending with .psv
Royal Pain. Google spreadsheet and Mac Numbers understand and allow psv files...
Sometimes Microsoft DOES NOT KNOW WHAT IS BEST FOR THE USER.
how to open dat file in excel mac
same here. ridiculous excel is blinded by file suffix.
Bill Szymczak commented
A .dat file can be opened in Excel on a MAC.
A window will appear with all the .dat files grayed out.
2) Right Click on the file you want to open and select Rename from the popup window.
3) You will then see an "Open" button on the lower right of the window. (You do not need to actually rename the file.)
Vic Quinn commented
Many scientific programs export data into .dat files which previously could be easily imported into Excel for analysis or presentation. Restriction of file import to .txt files is cumbersome.
Please restore Excel's capability to import data from files with non .txt extensions as the user selects.
Do you know if there is a way to get around this problem ? this is really ****** not to be able to select a filetype of our own I agree
I agree. This is a BIG problem for my work
I fully agree. I need to import files that are not .csv or .txt and Excel does not allow that anymore.