Csv files

[Ramsee2020]

When i down loaded a csv file and opened it in excel 2013 all data is loaded correctly in the excel worksheet. I.e all data is in columns and numerical values are displayed as numbers.
When I open a csv file in excel 2016 all data is displayed as comma delimited data in one row.

Is there a setting in excel 2016 that i can use to avoid the long process of converting data into colums

 

[sandy666]

as I said, download file on your computer then open
right click on this file - Properties - uncheck read only if necessary then OK & open
don't open file directly in Excel On-Line

 

[Ramsee2020]

When i right click on your file there is no option to save the file
When i click on it it opens in a read only file
When i save a copy it saves it as a xlsx file
Anyhow the xlsx version is100%. The numbers is saved as values and not text

 

[sandy666]

ok try from here: TinyUpload.com - best file hosting solution, with no limits, totaly free
let me know if you download this csv to your computer

 

[Ramsee2020]

Thank you for trying to solve the riddle but i get the impression that there is no answer.
Take care

 

[sandy666]

sure, your choice
one thing you can do is import via Wizard because too many delimiters are there (see post#29) and you need to define which one Excel should use
Have a nice day

 

[Ramsee2020]

http://s000.tinyupload.com/?del_id=09444592589040665522

 

[Ramsee2020]

this is my csv file

 

[sandy666]

you posted link to delete file not for download but I got this file another way ?
then double clik and voilà (XL 2016)

Date	Description	Amount	Balance
20200301	KREDIETRENTE	5702.31	1191991.75
20200302	INETBNK OORPL DT ABSA BANK Tax free trf	-36000	1155991.75
20200303	INETBNK OORPL DT ABSA BANK Trf Ccp Abbyvale	-249	1155742.75
20200304	INETBNK OORPL KT ABSA BANK Trf Depositor	10000	1165742.75
20200304	INETBNK OORPL KT ABSA BANK Trf Depositor	10000	1175742.75

try dbl click your example not whole csv

 

[Ramsee2020]

But all info is in one row!
Info should be in collums

 

[Ramsee2020]

Sorry. I did mot scroll