There's an import function in the File dropdown, with a dialog giving you control over separators. If that fails, you can paste the data, followed by Data > Split text to Columns. I work with CSVs in Google Sheets often and it's pretty reliable.