How to open a .csv file in Excel Opening a .csv file is as easy as opening a .txt file, and usually, you won’t have to clean up the data before doing so because the save task inserts the delimiter.

For example, PROC IMPORT recognizes the filename ACCOUNTS.WK1 as a Lotus 1 spreadsheet and the filename MYDATA.CSV as a delimited external file that contains comma-separated data values.