Google Sheets now lets you convert text to columns.

Google just made life easier for Google Sheets users with a new feature that allows them to copy and separate comma delimited text neatly into columns. This is only possible if the data is separated by commas, then a contextual menu will appear after the data is pasted into the sheet and the user can choose to split text into columns. This new feature will be a real time savior for heavy Sheets users. The update may not be available just yet, so make sure you check Google Play Store over the next two weeks.

Source: Google