There are two simple ways to import data from a text file (.txt or .csv) into Excel. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down menu.

To import data from a text file into Microsoft Excel, follow this step-by-step guide: First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC.

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.

How to Save an Excel Spreadsheet to Your Desktop. Your computer's desktop is often the easiest and most convenient place to store files, especially those you use often.