Wow, this is messed up:
Numbers 3.0 on Mac does not allow importing .CSV files (all columns are bunched up into one), but on iCloud it works perfectly with proper column formatting.
Crazy! At least there's a workaround the lack of proper .CSV importing in the Mac version!!