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 File, From Text/CSV, select file, Import. In the results, under File Origin, it reads 1252: Western European (Windows). I live in Europe but the file was downloaded from a US site. I tried selecting a few different options under File Origin to see if that would fix the lost decimel issue but didn't have luck. The problem is that in the original CSV file the amount was 2.36 and in Excel it became 236. How do I retain the decimels or add them back in? Thanks for your help!
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?
