Skip to content

Instantly share code, notes, and snippets.

What would you like to do?

Text-to-columns in Google Drive

Date: 2013-07-30

This is something that should be a standard feature in Google Drive: When pasting data formatted as rows separated by a new line and columns separated by spaces (or commas), get the data in the expected format (rows as spreadsheet rows and columns as spreadsheet columns). Right now, Google Drive does not do this, it just preserves the rows.

So we need the text-to-columns feature available in LibreOffice or Office. The feature in GDrive can be used as a script:

  • Go to "Tools" > "Script Gallery".
  • Search for "Text to columns".
  • Install script (have to give persmission to the script here).
  • Reload spreadsheet. There is now an "Advanced" menu which has a text-to-columns feature and also a columns-to-text one.


Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment