Double click to open CSV and TSV in Excel 2013

We have someone (John Doe) that would like to open TSV (tab delimited text file) files automatically in Excel without using the import wizard.

Our goal: Basically the file is provided by a website (an export of data) and it downloads to the temp file location, then have it open in Excel automatically.

We have tsv associated with Excel, and excel opens. However it just goes to the beginning screen where you have to select a blank workbook. We never see that data opened into Excel.  If we save the file, open excel, tell excel to open the TSV we can go through the import wizard to open the data into a spreadsheet. But this is not our goal. :)

We know this can be done for two reasons.  There is another employee (Jane Doe, no relation) that has this working according to our goal. She can even double click on a TSV and it opens right up into an Excel spreadsheet with the data parsed properly. If we double click on a TSV file on John's computer it opens excel, but goes right to the option to open a blank workbook. None of the tsv data comes in.  Unfortunately Jane does not recollect how this started working on her computer. I have compared Excel settings and addins on both computers but am not finding a difference.

Second reason I know this can work. I used to have the same issues on my computer with CSV files. I would have to open a blank Excel, then have Excel open the CSV and go through the import wizard to configure the data parsing.  For about 6-12 months now I have been able to just double click on a CSV and it opens into an Excel spreadsheet with the data parsed properly. Unfortunately I do not recall ever doing anything to my computer to make this happen... Granted that could be a memory issue on my part. :( 

Any ideas on this would be greatly appreciated.

Tha

March 18th, 2015 6:13pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics