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.

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 ...