How to Convert an Excel File Into a DAT File (with Pictures)

2024 Author: Jason Gerald | [email protected]. Last modified: 2023-12-16 10:50

This wikiHow teaches you how to convert a Microsoft Excel (. XLS) file to the. DAT format on a Windows computer. You'll need to convert the. XLS file to a. CSV (comma separated values) format first, then convert it to a. DAT file through an application like Notepad.

Step

Part 1 of 2: Converting an Excel Document Into a. CSV File

Step 1. Open Microsoft Excel

This application is in the application group " Microsoft Office " in the segment " All Apps ” in the "Windows"/"Start" menu.

Step 2. Click the File menu

It's in the top-left corner of the screen.

Step 3. Click Open

Step 4. Click the file you want to convert

The file will open in an Excel window.

Step 5. Click the File menu

Step 6. Select Save as…

Step 7. Open the folder where you want to save the file

Step 8. Click the “Save as type” drop-down menu

A list of file types will open.

Step 9. Select CSV (Comma delimited)(*.cvs)

This way, you can create a file that can be converted to the. DAT format.

Step 10. Type in a file name

Enter a name in the "File name" field. If you want to use an existing name, skip this step.

Step 11. Click Save

A confirmation message will be displayed.

Step 12. Click OK

The. CSV file will be saved and ready to be converted.

Part 2 of 2: Converting. CSV Files Into. DAT Format

Step 1. Press Win+E key

A File Explorer window will open.

Step 2. Visit the folder where the. CSV file is stored

Don't click the file once the folder is open; just let the folder show on the screen.

Step 3. Right-click the file you want to convert

Step 4. Select Open with…

A list of applications will be displayed.

Step 5. Click Notepad

The file will be opened in the Notepad application.

Step 6. Click the File menu

It's in the upper-left corner of the Notepad window.

Step 7. Click Save As…

Step 8. Click the “Save as type” drop-down menu

This menu is under the “File name” column. A list of file types will be displayed.

Step 9. Select All Files (*.*)

With this option, you can define your own extension to use.

Step 10. Rename the file with a. DAT extension at the end of the name

For example, if the “File name” column is currently labeled Buku1.txt, change it to Book1.dat.

Capitalization of the. DAT extension has no effect (e.g. “. DAT” or “.dat”)

Step 11. Click Save

The original file is now successfully saved into. DAT format.