Easily convert text to columns in Google Sheets

posted Mar 14, 2016, 10:00 AM by Eric Fruth

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.
  • 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.
See the Help Center to learn more.