Forum Discussion

Fazel Khota's avatar
Fazel Khota
Copper Contributor
May 05, 2017

csv files

i use to download my bank statements in csv and it use to open automatically with excel in sepearated columns- that was using 2013 . Now im using the latest excel and  it doesn't. When I use the Get ...
excel
Frances Akridge's avatar
Frances Akridge
Copper Contributor
Aug 11, 2017

I am having the same problem. Here is a copy of of the file from the bank. 

 

 

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 12, 2017

Frances,

 

You latest file is empty, but the file from first post is opened correctly in any version of Excel if only you have proper regional settings - semicolon for List separator and the dot for Decimal symbol.

 

 

1) When double click on CSV file Excel splits it on 3 columns and correctly recognizes the date in first column and number in third one.

 

2) Import from csv file with 3-step (old style connector) requires only the dot as decimal settings, you may select semicolon as separator within the wizard and YMD for first column, General for two others.

 

3) Modern connector in latest version of Excel with correct regional settings recognizes the file in one step and returns the table with correct date and number formats in first and third columns (with default settings).

 

Thus first please check the regional settings on your computer. If they are as above and import still doesn't work when more details will be required, but let start from this.

 

Resources