Forum Discussion
Import CSV to Excel
Greetings would appreciate some help. New laptop with windows 10 & office 365. Unable to download csv. files to excel & separate info to columns with comma of the csv format. Region settings English ...
Hi! Just let’s check something:
Can you pls open the csv file in your Windows Explorer with Right-Click it and choose „Open with....“
Maybe your brandnew stuff does not know that csv shall be opened with excel. Can you open it now? Greets, Eva
Can you pls open the csv file in your Windows Explorer with Right-Click it and choose „Open with....“
Maybe your brandnew stuff does not know that csv shall be opened with excel. Can you open it now? Greets, Eva
Hi Eva,
Thanks for your reply, sorry for the late response.
I can do open with right click 'open with' & that is set for excel. The problem is that our banks provide statements for downloading only in csv format. During the download comma separation does not function leaving all detail in one line. This is the same whether saved as excel or as csv.
I had similar problem on previous laptop & managed to resolve it by changing the regional settings - for some reason doing that with this one dose not work.
Greetings Gret