Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Adobe files into Excel files | Excel Discussion (Misc queries) | |||
Converting excel files | Excel Discussion (Misc queries) | |||
Converting files for Excel | Excel Discussion (Misc queries) | |||
Converting CSV files into Excel files | Excel Worksheet Functions | |||
Converting DBF Files to Excel | Excel Discussion (Misc queries) |