Comma-separated value (CSV) files are simplified versions of the type of spreadsheets you create with Excel and similar software. However, if you're trying to share data with people who use ...

Click the "Save as Type" drop-down list and select the "CSV (Comma Delimited)" option. Click the "Save" button. Excel saves the file in pipe-delimited format in the folder you selected.

2] Start a new Spreadsheet You will now need to get a new Spreadsheet up and running. Once you’ve fired up Excel, please click on Blank Workbook and that will create a new spreadsheet.

To import data from a text file into Microsoft Excel, follow this step-by-step guide: First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC.