Forum Discussion
Converting a CSV file to Excel without losing decimels
I occasionally get CSV files (from financial institutions) and choose to simply open them in Excel. No need to make use of the "Get Data" routine you cite. I do that simple open in Excel by right clicking on the file name (I'm on a Mac) which then gives me the choice of what program to use in opening it; I pick Excel, and I'm done.
Is that option available to you?
Your phrase the data appears in a single cell with commas between each piece of data, like a CSV file makes me wonder if it is only like a CSV without actually BEING a CSV.
How did you receive the file? What's the financial institution? Did you (yourself) export it from that institution specifically as CSV?
I have reaccessed the account to repro what I did. Yes, in order to download the file I selected Microsoft Excel Format and it automatically gave me a .csv file. mathetes
I have reaccessed the account to repro what I did. Yes, in order to download the file I selected Microsoft Excel Format and it automatically gave me a .csv file.
And..... ?
Looking for the rest of the story. Is it the same as before--still unable to open in a useful way? It's hard to believe you'd be the only customer of the bank having this difficulty.
Is it possible to post a copy of that file? On OneDrive or GoogleDrive, if you can, with a link here that grants access.