Use semicolon as separator viewing csv files

Given that Numbers also can’t read that file correctly, maybe you should check its coding. (That of the file, not of Numbers).