Select the .dat file you want to open in Excel. Finally, in the Text Import Wizard that opens up, select Fixed width, and then set the Field width and Data format when asked.

Though DAT files, which house data as the shortened name implies, are usually best left alone, here's how you can open them.

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.

If you're having trouble opening a DAT file, I'll show you a simple and free way to do it. This method works on both Mac and PC. Just open your browser and go to winmaildat.com. It's a ...