How to Convert Excel to DAT

Techwalla may earn compensation through affiliate links in this story.
How to Convert Excel to DAT
Image Credit: shironosov/iStock/Getty Images

You can use the Notepad program on your Windows 7 computer to create DAT files, but you cannot open an Excel file in Notepad without first saving it as a CSV file. The CSV format is a plain-text document type that separates values with commas, which allows you to preserve some of the Excel formatting while still being able to view the file in plain-text editors. Your converted DAT file will then prove accessible in the program that requires that format.

Advertisement

Step 1

Double click to open your Microsoft Excel 2010 file.

Video of the Day

Step 2

Click the "File" tab in the upper-left corner, then select "Save As."

Step 3

Click the drop-down menu to the right of "Save As Type" and select "CSV (Comma Delimited)."

Advertisement

Step 4

Click the "Save" button, click "OK" to save the active sheet, then click "Yes" to keep the worksheet in CSV format.

Step 5

Right click the CSV file you just created, click "Open With" and select "Notepad."

Advertisement

Advertisement

Step 6

Click "File" at the top of the window, then click "Save As."

Step 7

Click the drop-down menu to the right of "Save As Type" and choose "All Files."

Advertisement

Step 8

Click inside the "File Name" field and add ".dat" to the end. For example, if your filename is "xxxxxx," modify it so it reads, "xxxxxx.dat."

Step 9

Click the "Save" button.

Advertisement

Advertisement

Report an Issue

screenshot of the current page

Screenshot loading...