I can't open a csv file

I have a .csv file but calc won’t open it right. It’s nothing more than basic rows with data separated by commas, but when I open it it shows it all in one big cell and it uses only chinese (or what looks like it) characters. What in the world???

It opens fine with excel.

I really wish I knew how to explain it better. Hopefully you know the problem I’m referring to.

Ah, it was using Unicode instead of Unicode UTF-8!

Thanks so much!
Was very lost