There are a variety of ways to bring data into a Google Sheet.
For small amounts of data you wish to copy and paste inside a Sheet, here is a nice technique to simply convert text into columns.
The text needs to have a standard delimiter including commas, semicolons, periods, spaces, and also custom separators you can define yourself.
To use this technique in Google Sheets, simply follow these steps:
This will present a small menu enabling you to select the separator or you can specify a custom one.