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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 05, 2017

Hi Fazel,

 

It looks like you updated not only Excel - all versions parse csv files in the same way, no changes is here.

 

You have semicolon as the separator in you csv file. For your Windows/Mac (not Excel) check Regional format, here "Change date, time and numbers format" under it Additional setting. You will see List separator here, change it on semicolon and save.

 

Now your csv file shall be opened and parsed correctly by Excel if you click on the file name in File explorer.

 

However, please take into account that could be negative side effect in other functions or applications which also used list separator to parse the text. For example, if you have (or someone forward to you) the Excel file with INDIRECT function where comma separates part of the within INDIRECT text, yiu'll receive an error. On the other hand, you could never meet such.

Resources