Life Tip – convert text to spreadsheet with cells

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 noting 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
print

Leave a Reply

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