So, .csv file is basically text file with usually comma(,) separated fields.
When I opened it in my LibraOffice Calc it asked me how the fields are separated, then I selected comma (,) so it opened as it should then just save it and import that to Xibo.
With MS excel or OpenOffice it would be the same/similar.
As for the columns, you can set the type if you want, but I left it as string and didn’t do anything to it.
I hope that this will help you 