Results 1 to 6 of 6

Thread: Opening file type .tsv with Excel

  1. #1
    Join Date
    Dec 2010
    Posts
    61

    Opening file type .tsv with Excel

    Well I am using Windows 7 on my computer. I have also installed Microsoft Office 2007 on the computer of mine. Well I am having a query and I have decided to discuss with you all so that you can help me. Well I wanted to make Windows 7 and Office 2007 to open file type which is .tsv file using Microsoft Excel. Anyone having idea about this situation please reply. I will appreciate for your response. Thanks in advance.

  2. #2
    Join Date
    May 2008
    Posts
    860

    Re: Opening file type .tsv with Excel

    Well looking at your situation I am suggesting following solution that you can apply to meet your requirement. You have to click on start menu and choose control panel. Now select Default programs from the control panel menu. Now you have to choose Associate a file type of protocol with a program. You will find a list of file type see that it is added or not. If it is not added you have to add the same. If it is listed you can simply change the default application to Excel.

  3. #3
    Join Date
    May 2008
    Posts
    913

    Re: Opening file type .tsv with Excel

    You can use the following steps to solve the matter I am hoping that it will help you out from this particular problem.
    1. You have to double click on file. You will prompt with dialog box which says Windows can't open this file.
    2. You to click on Select a program from a list of installed programs . This will let you to the list of programs which you have installed on your computer. If program is not present in the list simply click on the Browse button in order to choose the desired program.
    3. Once you have selected the target program click on the Open button.
    4. You have to check Always use the selected program to open this kind of file check box.
    5. Now click on Ok button.

    Note that the program which you have selected must support the file type which you are trying to add.

  4. #4
    Join Date
    Nov 2008
    Posts
    1,054

    Re: Opening file type .tsv with Excel

    Well I am stuck in the similar situation that you have mentioned in your post. I was trying to meet the requirement by copying link to Microsoft Excel but it did not help me. .tsv file opens successfully into Word of the Microsoft Office 2010. However it doesn't open in to Excel of Microsoft Office 2010.As far as I know there was no issue on the previous version of Office. Please let me know why it is happening.

  5. #5
    Join Date
    Jun 2009
    Posts
    1,518

    Re: Opening file type .tsv with Excel

    Well You can .tsv file extension to .csv file using following steps.
    1. You have to launch command prompt from the Start menu.
    2. Now enter CD command and path of the file where it was stored actually.Now you have to press enter.
    3. Now you should enter rename tsvfile.tsv tsvfile.csv on the command prompt.
    Now you will be able to open .tsv file with Microsoft Excel.
    I am hoping that it will help you.

  6. #6
    Join Date
    Jan 2012
    Posts
    1

    Re: Opening file type .tsv with Excel

    It took me forever to figure this out. Back up your registry before making these changes. This worked for me on 2 systems running Windows 7 Pro and Office 2010 Pro Plus.

    My Solution: There are 3 registry changes you can make to make it work. Iím sure you can combine them all into one fix, but I have them as 3 and run them in order of 1, 2, 3 and it works. Below is the text you can copy into notepad and save it as a .reg file. If you want to combine the 3 files into one, thatís up to you, but I am listing them as the 3 separate files the way I have them. Do not copy the text reg file 1, 2, or 3. I added that so you know what each file was.

    Reg File 1:
    Windows Registry Editor Version 5.00

    [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.tsv]

    [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.tsv\OpenWithList]
    "a"="EXCEL.EXE"
    "MRUList"="a"

    [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.tsv\OpenWithProgids]
    "tsv_auto_file"=hex(0):

    Reg File 2:
    Windows Registry Editor Version 5.00

    [HKEY_CURRENT_USER\Software\Classes\Applications\EXCEL.EXE]

    [HKEY_CURRENT_USER\Software\Classes\Applications\EXCEL.EXE\shell]

    [HKEY_CURRENT_USER\Software\Classes\Applications\EXCEL.EXE\shell\open]

    [HKEY_CURRENT_USER\Software\Classes\Applications\EXCEL.EXE\shell\open\command]
    @="\"C:\\Program Files\\Microsoft Office\\Office14\\EXCEL.EXE\" \"%1\""

    Reg File 3:
    Windows Registry Editor Version 5.00

    [HKEY_CURRENT_USER\Software\Classes\tsv_auto_file]
    @=""
    "EditFlags"=hex:00,00,00,00

    [HKEY_CURRENT_USER\Software\Classes\tsv_auto_file\shell]

    [HKEY_CURRENT_USER\Software\Classes\tsv_auto_file\shell\open]

    [HKEY_CURRENT_USER\Software\Classes\tsv_auto_file\shell\open\command]
    @="\"C:\\Program Files\\Microsoft Office\\Office14\\EXCEL.EXE\" \"%1\""

Similar Threads

  1. Getting error when opening excel file using a VB script
    By Madri in forum Software Development
    Replies: 4
    Last Post: 18-07-2012, 06:27 PM
  2. Replies: 6
    Last Post: 17-02-2012, 12:18 PM
  3. Opening WK1 File in Microsoft Excel 2007
    By $horizon$ in forum Windows Software
    Replies: 3
    Last Post: 11-01-2012, 05:07 PM
  4. Problem opening Excel file with VBA code
    By Lord in forum Software Development
    Replies: 3
    Last Post: 19-10-2009, 09:50 AM
  5. Opening an Excel file in VB.NET
    By Braze in forum Software Development
    Replies: 4
    Last Post: 26-01-2009, 08:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •