Copying data and pasting it into a spreadsheet can be a pain if the data does not separate neatly into columns. Today Google is launching a feature in Google Sheets that allows you to split delimited data (e.g. data separated by commas) from one column across multiple columns.
There are a couple ways to do this:
- Select the columns you want to split, and click Data > Split text to columns. A menu will then appear underneath the data, allowing you to split the data using commas, semicolons, periods, spaces, and even custom separators.
See the Help Center to learn more.
- Format cells containing delimited data using a contextual menu that appears immediately after you’ve pasted data. You can also choose a custom separator with this method.