Text can live in many places and thanks to copy/paste, text can be easily moved around from application to application. However, when it comes to lists and easy organization, pasting can become a little complicated.

Pasting in Google Sheets can become especially difficult when you want to paste a list or text that you want to separate into different cells. The former solution to separating text was with a script, but Google announced this week that you can now easily convert text to columns in Sheets with new paste formatting options.

Watch the video demonstration above to learn more.


UP NEXT: How to Add a Hyperlink to a Google Sheet

10 thoughts on “How to do Text-to-Columns in Google Spreadsheets

  1. Bob Ferretti Reply

    Excellent quick tutorial and the script is great. It really is one of the annoying things I kept having to open Excel for. Thank you!

  2. Tammy Reply

    Thanks for this great tip!! How do I make this script available for any of my open spreadsheet files? It seems to only be available for the one spreadsheet where I created it.

  3. Mike McKenna Reply

    Great video. Thanks for posting. Quick question: where does the script reside? I don’t see it in my Google Drive.

  4. kathy Reply

    this is the best. Took me 5 minutes to setup and now I have a one-button solution to a task I do all the time.

  5. kojak edwards Reply

    What a disappointment. When I clicked on the .txt file, it was empty. When I looked up Google Script Apps, it was nowhere to be found.

    The only winner in all of this is Google Gooru. They get to sell my email address. I guess I can expect a boatload of spam/advertising.


Leave a Reply

Your email address will not be published. Required fields are marked *