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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bubey - 13 Apr 2007 22:22 GMT

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/account/histdownload.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.

Reply to this Message

JMay - 15 Apr 2007 17:54 GMT

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

> My bank allows download of account files into the
> CSV format
[quoted text clipped - 16 lines]
>
> Thank in advance for the help.

Reply to this Message

Bubey - 17 Apr 2007 05:38 GMT

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.

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
[quoted text clipped - 20 lines]
>
> Thank in advance for the help.

Reply to this Message

Rate this thread: