A while back I wrote this post about splitting data into multiple columns in Google Sheets.
A small update has made this task a little easier. When you paste data into a sheet, a small contextual menu now appears. Clicking on this offers the option to Split text into columns:
Clicking on this option carries out the split, but offers you an option to choose a different delimiter if you wish:
Alternatively, you can select the columns you want to split, then click Data > Split text to columns. A menu will appear beneath the data, allowing you to perform the split using commas, semicolons, periods, spaces, or even custom separators.