File Association .tsv to excel












1














Im sorry i know this question gets asked alot but i have tried many diffrent things and nothing seems to work. But i am trying to get .tsv files to open with Microsoft Excel. I created a .tsv file on my desktop and at first it showed "test.tsv" with a blank icon. I run the following commands.



assoc .tsv=tsvfile
ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%1"



Now the file has changed, but all that changed is it now shows "test" wnd when i try to open it it want me to choose a program.



I am curently on a windows 8.1 Pro machine if that makes any diffrence.










share|improve this question



























    1














    Im sorry i know this question gets asked alot but i have tried many diffrent things and nothing seems to work. But i am trying to get .tsv files to open with Microsoft Excel. I created a .tsv file on my desktop and at first it showed "test.tsv" with a blank icon. I run the following commands.



    assoc .tsv=tsvfile
    ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%1"



    Now the file has changed, but all that changed is it now shows "test" wnd when i try to open it it want me to choose a program.



    I am curently on a windows 8.1 Pro machine if that makes any diffrence.










    share|improve this question

























      1












      1








      1







      Im sorry i know this question gets asked alot but i have tried many diffrent things and nothing seems to work. But i am trying to get .tsv files to open with Microsoft Excel. I created a .tsv file on my desktop and at first it showed "test.tsv" with a blank icon. I run the following commands.



      assoc .tsv=tsvfile
      ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%1"



      Now the file has changed, but all that changed is it now shows "test" wnd when i try to open it it want me to choose a program.



      I am curently on a windows 8.1 Pro machine if that makes any diffrence.










      share|improve this question













      Im sorry i know this question gets asked alot but i have tried many diffrent things and nothing seems to work. But i am trying to get .tsv files to open with Microsoft Excel. I created a .tsv file on my desktop and at first it showed "test.tsv" with a blank icon. I run the following commands.



      assoc .tsv=tsvfile
      ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%1"



      Now the file has changed, but all that changed is it now shows "test" wnd when i try to open it it want me to choose a program.



      I am curently on a windows 8.1 Pro machine if that makes any diffrence.







      microsoft-excel






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Dec 8 at 11:34









      Kory Davids

      84




      84






















          2 Answers
          2






          active

          oldest

          votes


















          0














          Excel will not accept file-associations without a previous manipulation
          of the registry:




          • Start regedit

          • Navigate to the key
            HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations

          • Right-click FileAssociations and select New > String Value

          • Name it .tsv

          • Double-click it and set its value to Excel.SLK


          Alternatively, you may do the same with a reg add command:



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f


          Now you may associate Excel to .tsv files by right-click of any such file
          and Open with > Choose another app, or by using the Default Programs app.



          If you are executing the commands in a batch file, remember to escape
          the % character, like this:



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f
          assoc .tsv=tsvfile
          ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%%1"





          share|improve this answer























          • i have been able to associate it before this with the open with. But i need command line cause i got a machine that keeps changing the association back to notepad. I want to make a script to run daily to ensure this never happens again.
            – Kory Davids
            Dec 8 at 12:28










          • I added the reg command for batch.
            – harrymc
            Dec 8 at 12:35










          • THANK YOU SO MUCH. Mission accomplished.
            – Kory Davids
            Dec 8 at 16:44



















          0














          Ok, here is the current update. Making a little bit of progress. Here is my current code. The icon now changes to excel, but it only opens excel like a fresh worksheet. Not the info that is in the file.



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f
          assoc .tsv=tsvfile
          ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%1"


          Ok, i think i got the biggest part figured out now. Now my only issue is when i run the above command as a .bat file. that very last "%1" does not get added. After the script runs all that is there is "". so for some reason it is dropping that last peramiter off. so just need to figure out a way to keep it there.






          share|improve this answer























          • Solution in my answer.
            – harrymc
            Dec 8 at 16:04











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "3"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1381868%2ffile-association-tsv-to-excel%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          2 Answers
          2






          active

          oldest

          votes








          2 Answers
          2






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          Excel will not accept file-associations without a previous manipulation
          of the registry:




          • Start regedit

          • Navigate to the key
            HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations

          • Right-click FileAssociations and select New > String Value

          • Name it .tsv

          • Double-click it and set its value to Excel.SLK


          Alternatively, you may do the same with a reg add command:



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f


          Now you may associate Excel to .tsv files by right-click of any such file
          and Open with > Choose another app, or by using the Default Programs app.



          If you are executing the commands in a batch file, remember to escape
          the % character, like this:



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f
          assoc .tsv=tsvfile
          ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%%1"





          share|improve this answer























          • i have been able to associate it before this with the open with. But i need command line cause i got a machine that keeps changing the association back to notepad. I want to make a script to run daily to ensure this never happens again.
            – Kory Davids
            Dec 8 at 12:28










          • I added the reg command for batch.
            – harrymc
            Dec 8 at 12:35










          • THANK YOU SO MUCH. Mission accomplished.
            – Kory Davids
            Dec 8 at 16:44
















          0














          Excel will not accept file-associations without a previous manipulation
          of the registry:




          • Start regedit

          • Navigate to the key
            HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations

          • Right-click FileAssociations and select New > String Value

          • Name it .tsv

          • Double-click it and set its value to Excel.SLK


          Alternatively, you may do the same with a reg add command:



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f


          Now you may associate Excel to .tsv files by right-click of any such file
          and Open with > Choose another app, or by using the Default Programs app.



          If you are executing the commands in a batch file, remember to escape
          the % character, like this:



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f
          assoc .tsv=tsvfile
          ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%%1"





          share|improve this answer























          • i have been able to associate it before this with the open with. But i need command line cause i got a machine that keeps changing the association back to notepad. I want to make a script to run daily to ensure this never happens again.
            – Kory Davids
            Dec 8 at 12:28










          • I added the reg command for batch.
            – harrymc
            Dec 8 at 12:35










          • THANK YOU SO MUCH. Mission accomplished.
            – Kory Davids
            Dec 8 at 16:44














          0












          0








          0






          Excel will not accept file-associations without a previous manipulation
          of the registry:




          • Start regedit

          • Navigate to the key
            HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations

          • Right-click FileAssociations and select New > String Value

          • Name it .tsv

          • Double-click it and set its value to Excel.SLK


          Alternatively, you may do the same with a reg add command:



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f


          Now you may associate Excel to .tsv files by right-click of any such file
          and Open with > Choose another app, or by using the Default Programs app.



          If you are executing the commands in a batch file, remember to escape
          the % character, like this:



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f
          assoc .tsv=tsvfile
          ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%%1"





          share|improve this answer














          Excel will not accept file-associations without a previous manipulation
          of the registry:




          • Start regedit

          • Navigate to the key
            HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations

          • Right-click FileAssociations and select New > String Value

          • Name it .tsv

          • Double-click it and set its value to Excel.SLK


          Alternatively, you may do the same with a reg add command:



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f


          Now you may associate Excel to .tsv files by right-click of any such file
          and Open with > Choose another app, or by using the Default Programs app.



          If you are executing the commands in a batch file, remember to escape
          the % character, like this:



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f
          assoc .tsv=tsvfile
          ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%%1"






          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Dec 8 at 16:04

























          answered Dec 8 at 12:01









          harrymc

          253k12259562




          253k12259562












          • i have been able to associate it before this with the open with. But i need command line cause i got a machine that keeps changing the association back to notepad. I want to make a script to run daily to ensure this never happens again.
            – Kory Davids
            Dec 8 at 12:28










          • I added the reg command for batch.
            – harrymc
            Dec 8 at 12:35










          • THANK YOU SO MUCH. Mission accomplished.
            – Kory Davids
            Dec 8 at 16:44


















          • i have been able to associate it before this with the open with. But i need command line cause i got a machine that keeps changing the association back to notepad. I want to make a script to run daily to ensure this never happens again.
            – Kory Davids
            Dec 8 at 12:28










          • I added the reg command for batch.
            – harrymc
            Dec 8 at 12:35










          • THANK YOU SO MUCH. Mission accomplished.
            – Kory Davids
            Dec 8 at 16:44
















          i have been able to associate it before this with the open with. But i need command line cause i got a machine that keeps changing the association back to notepad. I want to make a script to run daily to ensure this never happens again.
          – Kory Davids
          Dec 8 at 12:28




          i have been able to associate it before this with the open with. But i need command line cause i got a machine that keeps changing the association back to notepad. I want to make a script to run daily to ensure this never happens again.
          – Kory Davids
          Dec 8 at 12:28












          I added the reg command for batch.
          – harrymc
          Dec 8 at 12:35




          I added the reg command for batch.
          – harrymc
          Dec 8 at 12:35












          THANK YOU SO MUCH. Mission accomplished.
          – Kory Davids
          Dec 8 at 16:44




          THANK YOU SO MUCH. Mission accomplished.
          – Kory Davids
          Dec 8 at 16:44













          0














          Ok, here is the current update. Making a little bit of progress. Here is my current code. The icon now changes to excel, but it only opens excel like a fresh worksheet. Not the info that is in the file.



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f
          assoc .tsv=tsvfile
          ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%1"


          Ok, i think i got the biggest part figured out now. Now my only issue is when i run the above command as a .bat file. that very last "%1" does not get added. After the script runs all that is there is "". so for some reason it is dropping that last peramiter off. so just need to figure out a way to keep it there.






          share|improve this answer























          • Solution in my answer.
            – harrymc
            Dec 8 at 16:04
















          0














          Ok, here is the current update. Making a little bit of progress. Here is my current code. The icon now changes to excel, but it only opens excel like a fresh worksheet. Not the info that is in the file.



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f
          assoc .tsv=tsvfile
          ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%1"


          Ok, i think i got the biggest part figured out now. Now my only issue is when i run the above command as a .bat file. that very last "%1" does not get added. After the script runs all that is there is "". so for some reason it is dropping that last peramiter off. so just need to figure out a way to keep it there.






          share|improve this answer























          • Solution in my answer.
            – harrymc
            Dec 8 at 16:04














          0












          0








          0






          Ok, here is the current update. Making a little bit of progress. Here is my current code. The icon now changes to excel, but it only opens excel like a fresh worksheet. Not the info that is in the file.



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f
          assoc .tsv=tsvfile
          ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%1"


          Ok, i think i got the biggest part figured out now. Now my only issue is when i run the above command as a .bat file. that very last "%1" does not get added. After the script runs all that is there is "". so for some reason it is dropping that last peramiter off. so just need to figure out a way to keep it there.






          share|improve this answer














          Ok, here is the current update. Making a little bit of progress. Here is my current code. The icon now changes to excel, but it only opens excel like a fresh worksheet. Not the info that is in the file.



          reg add "HKEY_LOCAL_MACHINESOFTWAREClientsSpreadsheetMicrosoft ExcelCapabilitiesFileAssociations" /v ".tsv" /t REG_SZ /d "Excel.SLK" /f
          assoc .tsv=tsvfile
          ftype tsvfile="C:Program FilesMicrosoft Office 15rootoffice15excel.exe" "%1"


          Ok, i think i got the biggest part figured out now. Now my only issue is when i run the above command as a .bat file. that very last "%1" does not get added. After the script runs all that is there is "". so for some reason it is dropping that last peramiter off. so just need to figure out a way to keep it there.







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Dec 8 at 14:21

























          answered Dec 8 at 13:14









          Kory Davids

          84




          84












          • Solution in my answer.
            – harrymc
            Dec 8 at 16:04


















          • Solution in my answer.
            – harrymc
            Dec 8 at 16:04
















          Solution in my answer.
          – harrymc
          Dec 8 at 16:04




          Solution in my answer.
          – harrymc
          Dec 8 at 16:04


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Super User!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1381868%2ffile-association-tsv-to-excel%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Plaza Victoria

          Puebla de Zaragoza

          Musa