CSV Downloads

[Guest]

I have just started using XP, having used Win2K for a couple of years, and
when downloading my bank statements as CSV it now opens Excel within Internet
Explorer. On my Win2K machine I can download to a folder. Any help
appreciated, thanks.

 

[Karl]

Perhaps you could change your file association to open with Excel vs IE?
Right click the file and choose open with, Excel, and check to always open
with excel.

 

[Guest]

It may well be that the download has an '.html' or '.htm' extension.

Just check the file name before you go changing associations.

If the file is saved as other than 'name.xls' right click and rename it to
'name.xls' from 'name.htm'.

 

[Admiral Q]

I believe you should have an "excel" toolbar within the IE window - click on
"File", "Save As" and save the file where you wish. I believe this change
is due to how the "developer" codes the webpage - so you can't change the
behavior - you can just work around it. I find this especially annoying
with PDF (Adobe) files, as I would rather just "save" them, instead of
viewing, then saving them.

--
Star Fleet Admiral Q @ your service!
"Google is your Friend!"
www.google.com

***********************************************

 

[David Candy]

Tell adobe not to in it's Preferences.

 

[Karl]

Just to clarify, when you go to the banking website and click the link to
download the files, instead of the download window popping up and asking if
you want to save or open the file, it just opens in IE? If so, you could try
right clicking the link and "save target as". If doing that brings up a file
with an .htm extension, then you could just click the link, and when it
opens in IE, just do File/Save As and save it as .xls or whatever.

When I read the post originally, I thought you were saying that you could
download the files, but that when you opened them they opened in IE. Sorry
for any wrong info.

 

[Guest]

Thanks for the replies,
When I try to download my statement I am given the 5 options via a dropdown
menu of - Microsoft Money, Quicken 2001, Quicken 98, Sage Line 50 (all OFX
files) and Microsoft Excel (CSV file). On my Win2K machine I select CSV and
am presented with a file download box. My option is where I would like to
save it as a .csv file. On the XP machine I select CSV and Excel is opened in
I.E. I do not appear to have any control over file associations. All I can
then do is copy and paste the related data into a seperately opened excel
workbook.
I hope this explains things more clearly.

 

[Ramesh, MS-MVP]

Hi Dave,

This problem can be resolved by modifying a couple of registry values.

1. Create a System Restore point if you want to undo the following
operation
2. Open Regedit and navigate to:

[HKEY_CLASSES_ROOT\.CSV]

3. In the right-pane, double-click "Content Type" and delete it
4. Navigate to:

[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]

5. Rename the key "CLSID" to "CLSID-"


NOTE: With missing Content Type value and missing Workbook CLSID, Internet
Explorer cannot execute the .CSV file, and you'll be presented with the
Open/Save As prompt when you click your bank statement (.CSV file). Should
you need to open a CSV file in Internet Explorer (embedded document) in
future, reverse the above steps.

Hope this helps, and keep us posted!

 

[Ramesh, MS-MVP]

Dave,

Here is another method: (But the changes are applied to CSV, XLS AND other
file types handled by MS Excel)

1. Open My Computer.
2. On the Tools menu (or the View menu), click Folder Options (or click
Options).
3. Click the File Types tab.
4. In the Registered file types list, click "Microsoft Excel Worksheet", and
then click Advanced (or click Edit).
5. In the Edit File Type dialog box, uncheck "Browse in same window" check
box
6. Click OK.

How to configure Internet Explorer to open Office documents in the
appropriate Office program instead of in Internet Explorer:
http://support.microsoft.com/default.aspx?scid=162059

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Hi Dave,

This problem can be resolved by modifying a couple of registry values.

1. Create a System Restore point if you want to undo the following
operation
2. Open Regedit and navigate to:

[HKEY_CLASSES_ROOT\.CSV]

3. In the right-pane, double-click "Content Type" and delete it
4. Navigate to:

[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]

5. Rename the key "CLSID" to "CLSID-"


NOTE: With missing Content Type value and missing Workbook CLSID,
Internet Explorer cannot execute the .CSV file, and you'll be presented
with the Open/Save As prompt when you click your bank statement (.CSV
file). Should you need to open a CSV file in Internet Explorer (embedded
document) in future, reverse the above steps.

Hope this helps, and keep us posted!

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Thanks for the replies,
When I try to download my statement I am given the 5 options via a
dropdown
menu of - Microsoft Money, Quicken 2001, Quicken 98, Sage Line 50 (all
OFX
files) and Microsoft Excel (CSV file). On my Win2K machine I select CSV
and
am presented with a file download box. My option is where I would like to
save it as a .csv file. On the XP machine I select CSV and Excel is
opened in
I.E. I do not appear to have any control over file associations. All I
can
then do is copy and paste the related data into a seperately opened excel
workbook.
I hope this explains things more clearly.

 

[Guest]

Bank statements allegedly in CSV format downloaded correctly into Excel 97
SR-2 on a Windows 98 system but NOT when XP (home edition) is used because
then the rows of data occupy only one column. Applying the alternative fix
from Ramesh allows the file to be saved from the open spreadsheet in .txt
format. When this file is reopened a series of options allow the file to be
viewed correctly ( ie columns as well as rows ). There must be a better way.

Dave,

Here is another method: (But the changes are applied to CSV, XLS AND other
file types handled by MS Excel)

1. Open My Computer.
2. On the Tools menu (or the View menu), click Folder Options (or click
Options).
3. Click the File Types tab.
4. In the Registered file types list, click "Microsoft Excel Worksheet", and
then click Advanced (or click Edit).
5. In the Edit File Type dialog box, uncheck "Browse in same window" check
box
6. Click OK.

How to configure Internet Explorer to open Office documents in the
appropriate Office program instead of in Internet Explorer:
http://support.microsoft.com/default.aspx?scid=162059

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Hi Dave,

This problem can be resolved by modifying a couple of registry values.

1. Create a System Restore point if you want to undo the following
operation
2. Open Regedit and navigate to:

[HKEY_CLASSES_ROOT\.CSV]

3. In the right-pane, double-click "Content Type" and delete it
4. Navigate to:

[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]

5. Rename the key "CLSID" to "CLSID-"


NOTE: With missing Content Type value and missing Workbook CLSID,
Internet Explorer cannot execute the .CSV file, and you'll be presented
with the Open/Save As prompt when you click your bank statement (.CSV
file). Should you need to open a CSV file in Internet Explorer (embedded
document) in future, reverse the above steps.

Hope this helps, and keep us posted!

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Thanks for the replies,
When I try to download my statement I am given the 5 options via a
dropdown
menu of - Microsoft Money, Quicken 2001, Quicken 98, Sage Line 50 (all
OFX
files) and Microsoft Excel (CSV file). On my Win2K machine I select CSV
and
am presented with a file download box. My option is where I would like to
save it as a .csv file. On the XP machine I select CSV and Excel is
opened in
I.E. I do not appear to have any control over file associations. All I
can
then do is copy and paste the related data into a seperately opened excel
workbook.
I hope this explains things more clearly.

 

[Ramesh, MS-MVP]

Rod,

Have you tried setting it to "Browse in same window" ?

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Bank statements allegedly in CSV format downloaded correctly into Excel 97
SR-2 on a Windows 98 system but NOT when XP (home edition) is used because
then the rows of data occupy only one column. Applying the alternative fix
from Ramesh allows the file to be saved from the open spreadsheet in .txt
format. When this file is reopened a series of options allow the file to
be
viewed correctly ( ie columns as well as rows ). There must be a better
way.

Dave,

Here is another method: (But the changes are applied to CSV, XLS AND
other
file types handled by MS Excel)

1. Open My Computer.
2. On the Tools menu (or the View menu), click Folder Options (or click
Options).
3. Click the File Types tab.
4. In the Registered file types list, click "Microsoft Excel Worksheet",
and
then click Advanced (or click Edit).
5. In the Edit File Type dialog box, uncheck "Browse in same window"
check
box
6. Click OK.

How to configure Internet Explorer to open Office documents in the
appropriate Office program instead of in Internet Explorer:
http://support.microsoft.com/default.aspx?scid=162059

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Hi Dave,

This problem can be resolved by modifying a couple of registry values.

1. Create a System Restore point if you want to undo the following
operation
2. Open Regedit and navigate to:

[HKEY_CLASSES_ROOT\.CSV]

3. In the right-pane, double-click "Content Type" and delete it
4. Navigate to:

[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]

5. Rename the key "CLSID" to "CLSID-"


NOTE: With missing Content Type value and missing Workbook CLSID,
Internet Explorer cannot execute the .CSV file, and you'll be presented
with the Open/Save As prompt when you click your bank statement (.CSV
file). Should you need to open a CSV file in Internet Explorer
(embedded
document) in future, reverse the above steps.

Hope this helps, and keep us posted!

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org


Thanks for the replies,
When I try to download my statement I am given the 5 options via a
dropdown
menu of - Microsoft Money, Quicken 2001, Quicken 98, Sage Line 50 (all
OFX
files) and Microsoft Excel (CSV file). On my Win2K machine I select
CSV
and
am presented with a file download box. My option is where I would like
to
save it as a .csv file. On the XP machine I select CSV and Excel is
opened in
I.E. I do not appear to have any control over file associations. All I
can
then do is copy and paste the related data into a seperately opened
excel
workbook.
I hope this explains things more clearly.

 

[Ramesh, MS-MVP]

Correction:

Have you tried unchecking the "Browse in same window" in folder options?

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Rod,

Have you tried setting it to "Browse in same window" ?

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Bank statements allegedly in CSV format downloaded correctly into Excel
97
SR-2 on a Windows 98 system but NOT when XP (home edition) is used
because
then the rows of data occupy only one column. Applying the alternative
fix
from Ramesh allows the file to be saved from the open spreadsheet in .txt
format. When this file is reopened a series of options allow the file to
be
viewed correctly ( ie columns as well as rows ). There must be a better
way.

Dave,

Here is another method: (But the changes are applied to CSV, XLS AND
other
file types handled by MS Excel)

1. Open My Computer.
2. On the Tools menu (or the View menu), click Folder Options (or click
Options).
3. Click the File Types tab.
4. In the Registered file types list, click "Microsoft Excel Worksheet",
and
then click Advanced (or click Edit).
5. In the Edit File Type dialog box, uncheck "Browse in same window"
check
box
6. Click OK.

How to configure Internet Explorer to open Office documents in the
appropriate Office program instead of in Internet Explorer:
http://support.microsoft.com/default.aspx?scid=162059

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org


Hi Dave,

This problem can be resolved by modifying a couple of registry values.

1. Create a System Restore point if you want to undo the following
operation
2. Open Regedit and navigate to:

[HKEY_CLASSES_ROOT\.CSV]

3. In the right-pane, double-click "Content Type" and delete it
4. Navigate to:

[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]

5. Rename the key "CLSID" to "CLSID-"


NOTE: With missing Content Type value and missing Workbook CLSID,
Internet Explorer cannot execute the .CSV file, and you'll be
presented
with the Open/Save As prompt when you click your bank statement (.CSV
file). Should you need to open a CSV file in Internet Explorer
(embedded
document) in future, reverse the above steps.

Hope this helps, and keep us posted!

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org


Thanks for the replies,
When I try to download my statement I am given the 5 options via a
dropdown
menu of - Microsoft Money, Quicken 2001, Quicken 98, Sage Line 50
(all
OFX
files) and Microsoft Excel (CSV file). On my Win2K machine I select
CSV
and
am presented with a file download box. My option is where I would
like to
save it as a .csv file. On the XP machine I select CSV and Excel is
opened in
I.E. I do not appear to have any control over file associations. All
I
can
then do is copy and paste the related data into a seperately opened
excel
workbook.
I hope this explains things more clearly.

 

[Guest]

Both .xlb and.xls file types of "Microsoft Excel Worksheet are unchecked for
"Browse in the Same Window" using the method Ramesh suggested ( the registry
has not been edited ).

Correction:

Have you tried unchecking the "Browse in same window" in folder options?

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Rod,

Have you tried setting it to "Browse in same window" ?

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Bank statements allegedly in CSV format downloaded correctly into Excel
97
SR-2 on a Windows 98 system but NOT when XP (home edition) is used
because
then the rows of data occupy only one column. Applying the alternative
fix
from Ramesh allows the file to be saved from the open spreadsheet in .txt
format. When this file is reopened a series of options allow the file to
be
viewed correctly ( ie columns as well as rows ). There must be a better
way.

:

Dave,

Here is another method: (But the changes are applied to CSV, XLS AND
other
file types handled by MS Excel)

1. Open My Computer.
2. On the Tools menu (or the View menu), click Folder Options (or click
Options).
3. Click the File Types tab.
4. In the Registered file types list, click "Microsoft Excel Worksheet",
and
then click Advanced (or click Edit).
5. In the Edit File Type dialog box, uncheck "Browse in same window"
check
box
6. Click OK.

How to configure Internet Explorer to open Office documents in the
appropriate Office program instead of in Internet Explorer:
http://support.microsoft.com/default.aspx?scid=162059

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org


Hi Dave,

This problem can be resolved by modifying a couple of registry values.

1. Create a System Restore point if you want to undo the following
operation
2. Open Regedit and navigate to:

[HKEY_CLASSES_ROOT\.CSV]

3. In the right-pane, double-click "Content Type" and delete it
4. Navigate to:

[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]

5. Rename the key "CLSID" to "CLSID-"


NOTE: With missing Content Type value and missing Workbook CLSID,
Internet Explorer cannot execute the .CSV file, and you'll be
presented
with the Open/Save As prompt when you click your bank statement (.CSV
file). Should you need to open a CSV file in Internet Explorer
(embedded
document) in future, reverse the above steps.

Hope this helps, and keep us posted!

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org


Thanks for the replies,
When I try to download my statement I am given the 5 options via a
dropdown
menu of - Microsoft Money, Quicken 2001, Quicken 98, Sage Line 50
(all
OFX
files) and Microsoft Excel (CSV file). On my Win2K machine I select
CSV
and
am presented with a file download box. My option is where I would
like to
save it as a .csv file. On the XP machine I select CSV and Excel is
opened in
I.E. I do not appear to have any control over file associations. All
I
can
then do is copy and paste the related data into a seperately opened
excel
workbook.
I hope this explains things more clearly.

 

[shakey]

Rod, I have not been following this thread but I would suggest a EXCEL site.
I had a similar, but different enough so I cant help, problem and they
helped.
SG

Both .xlb and.xls file types of "Microsoft Excel Worksheet are unchecked
for
"Browse in the Same Window" using the method Ramesh suggested ( the
registry
has not been edited ).

Correction:

Have you tried unchecking the "Browse in same window" in folder options?

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Rod,

Have you tried setting it to "Browse in same window" ?

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org


Bank statements allegedly in CSV format downloaded correctly into
Excel
97
SR-2 on a Windows 98 system but NOT when XP (home edition) is used
because
then the rows of data occupy only one column. Applying the alternative
fix
from Ramesh allows the file to be saved from the open spreadsheet in
.txt
format. When this file is reopened a series of options allow the file
to
be
viewed correctly ( ie columns as well as rows ). There must be a
better
way.

:

Dave,

Here is another method: (But the changes are applied to CSV, XLS AND
other
file types handled by MS Excel)

1. Open My Computer.
2. On the Tools menu (or the View menu), click Folder Options (or
click
Options).
3. Click the File Types tab.
4. In the Registered file types list, click "Microsoft Excel
Worksheet",
and
then click Advanced (or click Edit).
5. In the Edit File Type dialog box, uncheck "Browse in same window"
check
box
6. Click OK.

How to configure Internet Explorer to open Office documents in the
appropriate Office program instead of in Internet Explorer:
http://support.microsoft.com/default.aspx?scid=162059

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org


Hi Dave,

This problem can be resolved by modifying a couple of registry
values.

1. Create a System Restore point if you want to undo the following
operation
2. Open Regedit and navigate to:

[HKEY_CLASSES_ROOT\.CSV]

3. In the right-pane, double-click "Content Type" and delete it
4. Navigate to:

[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]

5. Rename the key "CLSID" to "CLSID-"


NOTE: With missing Content Type value and missing Workbook CLSID,
Internet Explorer cannot execute the .CSV file, and you'll be
presented
with the Open/Save As prompt when you click your bank statement
(.CSV
file). Should you need to open a CSV file in Internet Explorer
(embedded
document) in future, reverse the above steps.

Hope this helps, and keep us posted!

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org


Thanks for the replies,
When I try to download my statement I am given the 5 options via a
dropdown
menu of - Microsoft Money, Quicken 2001, Quicken 98, Sage Line 50
(all
OFX
files) and Microsoft Excel (CSV file). On my Win2K machine I
select
CSV
and
am presented with a file download box. My option is where I would
like to
save it as a .csv file. On the XP machine I select CSV and Excel
is
opened in
I.E. I do not appear to have any control over file associations.
All
I
can
then do is copy and paste the related data into a seperately
opened
excel
workbook.
I hope this explains things more clearly.

 

[Guest]

By editing the registry as Ramesh suggested the problem has been solved, .CSV
files can be moved into Excel 97 without any loss of formatting. Thanks for
your help.

Rod V

Hi Dave,

This problem can be resolved by modifying a couple of registry values.

1. Create a System Restore point if you want to undo the following
operation
2. Open Regedit and navigate to:

[HKEY_CLASSES_ROOT\.CSV]

3. In the right-pane, double-click "Content Type" and delete it
4. Navigate to:

[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]

5. Rename the key "CLSID" to "CLSID-"


NOTE: With missing Content Type value and missing Workbook CLSID, Internet
Explorer cannot execute the .CSV file, and you'll be presented with the
Open/Save As prompt when you click your bank statement (.CSV file). Should
you need to open a CSV file in Internet Explorer (embedded document) in
future, reverse the above steps.

Hope this helps, and keep us posted!

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Thanks for the replies,
When I try to download my statement I am given the 5 options via a
dropdown
menu of - Microsoft Money, Quicken 2001, Quicken 98, Sage Line 50 (all OFX
files) and Microsoft Excel (CSV file). On my Win2K machine I select CSV
and
am presented with a file download box. My option is where I would like to
save it as a .csv file. On the XP machine I select CSV and Excel is opened
in
I.E. I do not appear to have any control over file associations. All I can
then do is copy and paste the related data into a seperately opened excel
workbook.
I hope this explains things more clearly.

 

[Ramesh, MS-MVP]

You're welcome Rod. Thanks for taking the time to post back.

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

By editing the registry as Ramesh suggested the problem has been solved,
.CSV
files can be moved into Excel 97 without any loss of formatting. Thanks
for
your help.

Rod V

Hi Dave,

This problem can be resolved by modifying a couple of registry values.

1. Create a System Restore point if you want to undo the following
operation
2. Open Regedit and navigate to:

[HKEY_CLASSES_ROOT\.CSV]

3. In the right-pane, double-click "Content Type" and delete it
4. Navigate to:

[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]

5. Rename the key "CLSID" to "CLSID-"


NOTE: With missing Content Type value and missing Workbook CLSID,
Internet
Explorer cannot execute the .CSV file, and you'll be presented with the
Open/Save As prompt when you click your bank statement (.CSV file).
Should
you need to open a CSV file in Internet Explorer (embedded document) in
future, reverse the above steps.

Hope this helps, and keep us posted!

--
Ramesh, Microsoft MVP
Windows XP Shell/User
http://windowsxp.mvps.org

Thanks for the replies,
When I try to download my statement I am given the 5 options via a
dropdown
menu of - Microsoft Money, Quicken 2001, Quicken 98, Sage Line 50 (all
OFX
files) and Microsoft Excel (CSV file). On my Win2K machine I select CSV
and
am presented with a file download box. My option is where I would like
to
save it as a .csv file. On the XP machine I select CSV and Excel is
opened
in
I.E. I do not appear to have any control over file associations. All I
can
then do is copy and paste the related data into a seperately opened
excel
workbook.
I hope this explains things more clearly.

:

Just to clarify, when you go to the banking website and click the link
to
download the files, instead of the download window popping up and
asking
if
you want to save or open the file, it just opens in IE? If so, you
could
try
right clicking the link and "save target as". If doing that brings up
a
file
with an .htm extension, then you could just click the link, and when
it
opens in IE, just do File/Save As and save it as .xls or whatever.

When I read the post originally, I thought you were saying that you
could
download the files, but that when you opened them they opened in IE.
Sorry
for any wrong info.


It may well be that the download has an '.html' or '.htm' extension.

Just check the file name before you go changing associations.

If the file is saved as other than 'name.xls' right click and rename
it
to
'name.xls' from 'name.htm'.

:

Perhaps you could change your file association to open with Excel
vs
IE?
Right click the file and choose open with, Excel, and check to
always
open
with excel.

I have just started using XP, having used Win2K for a couple of
years,
and
when downloading my bank statements as CSV it now opens Excel
within
Internet
Explorer. On my Win2K machine I can download to a folder. Any
help
appreciated, thanks.