If you have data in delimited text files from other programs that you need to get into an Excel workbook, you can use the import wizard to import delimited text files and convert them into usable ...

How to Create Pipe Delimited Files in Excel 2010. Microsoft Excel allows you to export spreadsheet data to a number of common formats for use with other applications. If you need to export data to ...

This is the demonstration file to accompany the article, How to quickly extract delimited data using Microsoft Excel Power Query by Susan Harkins.

cut and awk both do a great job of slicing and dicing tab-delimited data. Just make sure your data uses unix-style newlines (/n). If it uses windows style (/r/n), use dos2unix to convert first.