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. Right-click the DAT file on your PC and click "Open." ...

How to convert a Text file into an Excel spreadsheet Let us see how to easily import or export data from a Text file to convert a Text (.txt or .csv) file into an Excel (.xlsx) spreadsheet.