First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC. Then, switch from the Home tab to the Data tab. You can find an option called From Text/CSV here.

How to Create Pipe Delimited Files in Excel 2010. ... In most cases, if all else fails, you can export Excel data in the text-based CSV, or Comma Separated Value, ...

How to create a CSV file. You can create CSV files in a few different ways. From an Excel spreadsheet. 1. Open your Excel document and click on the File tab. In the menu that appears, select Save ...