Type a name for the CSV file in the File name field, navigate to where you want to save the file, then click the Save button.In the Save As window, select the CSV (Comma delimited) (*.csv) option in the Save as type drop-down menu.Again, click the File tab in the Ribbon menu and select the Save As option. The text file data is converted to spreadsheet format.If you don't need to format each column of data, click the Finish button. To format each column of data, like text, date, or numeric, click the Next button and select the format type for each column of data.