Life Tip – convert text list to spreadsheet

You know how someone gives you a list and you’re like oh man, it sure woulda been nice had they not gone and made a list in Word or email that’s nothing but text, separated by commas? Yeah that thing. So here’s what to do… takes about a minute. Requires a spreadsheet editor, probably Microsoft Excel.

  1. Save your plain text as a text file
  2. Open Microsoft Excel
  3. Click Import
  4. Sort by comma
  5. Boom, spreadsheet

Leave a Reply

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