Excel as default for .tsv files.
I used to be able to set Excel as the defaul application for opening .tsv files (which is the default format for exporting some of our finance files from other apps). Now I have to save as a WordPad file, and then open that file and copy/paste into Excel in order to get the data into columns for sums, etc. This is a huge waste of time when it can be done automatically. Please bring back this capability.
This is not Excel functionality, but rather Windows, and is doable already. To associate .TSV files with Excel, do the following:
1. Find a TSV file on your computer.
2. Right click on the TSV file and select “Open with…” (and if a menu appears, select “choose and app”)
3. Check the box to “Always use this app to open .tsv files”
4. Select Excel in the list of apps at the top of the dialog, or browse for Excel if it’s not listed there.
5. Click OK.
That should do it for you. In the future, answers.microsoft.com is a better place for questions like this.
Jeff that link fixed it for me, thanks mate!
Have you ever had it stay associated with "Pick an app" and not let you change it to Excel? I have tried to change the default association, every way I know how, and it still is associated with "pick an app" and will not change.
Has there been a fix for this issue? We're still having the problem.
Finally figured out how to get this to work. See here: https://superuser.com/questions/367913/why-cant-i-associate-files-with-excel-after-upgrading-to-2010/367936
The question title refers to Excel 2010, but the answer is relevant for 2016 as well.
It is possible to get Excel to show up in the list of applications after selecting it in the "Open with..." --> Browse dialog, but ONLY if you select excelcnv.exe. NOTE that selecting EXCEL.EXE does not work - after clicking "Open" in the dialog, Excel is populated into the options.
Annoyingly though, for *.tsv files, if you follow the procedure and choose excelcnv.exe, and then try to open *.tsv files, nothing happens.
The problem here seems to be with Excel after all. The analogous procedure works fine for WINWORD.EXE from Office 16 (but that is not what we want).
Can this please be fixed?
it doesn't work: Excel is not in the list of possible applications. I have searched the Excel.exe by browse functionality, but when I select and click Open, the association is not done. I have also tried by the Control Panel, but nothing ! This is incredible that in Excel 2016 it is also not possible to do "save as" .tsv format