Forum Discussion
Converting a CSV file to Excel without losing decimels
I have downloaded a csv file I want to convert to an Excel file. When I do the import from csv to Excel, the file loses decimels. I am opening an Excel file then going to Data tab, Get Data, From Fil...
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?
- Thanks for replying! It is a file from a financial institution. I tried doing what you suggested but when I choose to open it in Excel, the data appears in a single cell with commas between each piece of data, like a CSV file. It is a credit card statement and I want the amount spent in its own cell. I am using a Windows laptop.
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?
