Google Sheets that allows you to copy and paste data into a spreadsheet smartly into columns. You can now split delimited data from one column to another in several ways, for example, once you select the columns you want to split, click Data > Split text to columns. A menu will then appear underneath the data, allowing you to split the data using commas, semicolons, full stop, spaces, and custom separators as shown below.
In addition to the above option, you can also format cells containing delimited data using a contextual menu that appears immediately after you’ve pasted data, as shown below. You also have the option to use custom separator if you prefer.
Once you have copied and paste the text you would like onto your spreadsheet, select the paste formatting option and choose how you would like to split the data via the separator option.