How to Convert All Excel Sheets to CSV With Macros. Excel's Save As command lets you save a single worksheet in the CSV (comma seperated value) format, but not an entire workbook. Saving ...

If the DAT file you're trying to open is text, you can convert the file into text in the Microsoft Excel program by first saving it as a CSV file.