File Association .tsv to excel
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
add a comment |
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
add a comment |
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
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
microsoft-excel
asked Dec 8 at 11:34
Kory Davids
84
84
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
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"
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 thereg
command for batch.
– harrymc
Dec 8 at 12:35
THANK YOU SO MUCH. Mission accomplished.
– Kory Davids
Dec 8 at 16:44
add a comment |
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.
Solution in my answer.
– harrymc
Dec 8 at 16:04
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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"
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 thereg
command for batch.
– harrymc
Dec 8 at 12:35
THANK YOU SO MUCH. Mission accomplished.
– Kory Davids
Dec 8 at 16:44
add a comment |
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"
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 thereg
command for batch.
– harrymc
Dec 8 at 12:35
THANK YOU SO MUCH. Mission accomplished.
– Kory Davids
Dec 8 at 16:44
add a comment |
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"
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"
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 thereg
command for batch.
– harrymc
Dec 8 at 12:35
THANK YOU SO MUCH. Mission accomplished.
– Kory Davids
Dec 8 at 16:44
add a comment |
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 thereg
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
add a comment |
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.
Solution in my answer.
– harrymc
Dec 8 at 16:04
add a comment |
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.
Solution in my answer.
– harrymc
Dec 8 at 16:04
add a comment |
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.
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.
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
add a comment |
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
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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