Skip to content

Instantly share code, notes, and snippets.

@rocarvaj

rocarvaj/2013-07-30_text-to-columns-gdrive.md

Created September 10, 2014 12:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rocarvaj/9cfc642cb1e32b43379e to your computer and use it in GitHub Desktop.
Save rocarvaj/9cfc642cb1e32b43379e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
2013-07-30_text-to-columns-gdrive.md

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.

Source: http://webapps.stackexchange.com/a/22800.

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