CSV files into Excel......Need Help Converting
 

My bank allows download of account files into the
CSV format
so I can then use Excel to do my accounting.

All of a sudden it stopped giving me the option of
Save or
Open, and just goes directly to a web page (see
below)
https://www.bankonlinebanking.net/ac...stdownload.asp
and the information on the page is not in columns.

I always save it and then reopen it and it would
open in
Excel and then I could save it as an Excel file.

There is some kind of association that needs to be
made
but for the life of me I can't remember it.

Thank in advance for the help.

CSV files into Excel......Need Help Converting
 

In the Web Page (in top-left-most) click on the First-piece of data, then
drag (highlight) - I sometimes press the SHIFT-END and my banks data takes me
automatically to the bottom (4,000 rows) and last column of data - then using
the shortcut Ctrl + C - (to place data into clipboard) then back to your
excel file, say cell a5 and do Edit Paste.
Perhaps this will work for you.
HTH


"Bubey" wrote:

My bank allows download of account files into the
CSV format
so I can then use Excel to do my accounting.

All of a sudden it stopped giving me the option of
Save or
Open, and just goes directly to a web page (see
below)
https://www.bankonlinebanking.net/ac...stdownload.asp
and the information on the page is not in columns.

I always save it and then reopen it and it would
open in
Excel and then I could save it as an Excel file.

There is some kind of association that needs to be
made
but for the life of me I can't remember it.

Thank in advance for the help.

CSV files into Excel......Need Help Converting
 

Thanks, but that wasn't what I was trying to find.
The info I had previously gotten was to make a
change
somewhere on the PC and then when you choose CSV
as your file type for download is automatically
gives you the choice to save or open. When you
open the file it is in an Excel worksheet and then
you can save it to the Excel format.


"JMay" wrote in
message
...
In the Web Page (in top-left-most) click on the
First-piece of data, then
drag (highlight) - I sometimes press the SHIFT-END
and my banks data takes me
automatically to the bottom (4,000 rows) and last
column of data - then using
the shortcut Ctrl + C - (to place data into
clipboard) then back to your
excel file, say cell a5 and do Edit Paste.
Perhaps this will work for you.
HTH


"Bubey" wrote:

My bank allows download of account files into
the
CSV format
so I can then use Excel to do my accounting.

All of a sudden it stopped giving me the option
of
Save or
Open, and just goes directly to a web page (see
below)
https://www.bankonlinebanking.net/ac...stdownload.asp
and the information on the page is not in
columns.

I always save it and then reopen it and it would
open in
Excel and then I could save it as an Excel file.

There is some kind of association that needs to
be
made
but for the life of me I can't remember it.

Thank in advance for the help.