How to Convert Excel to Dat

Part 1 of 2:

Converting to .CSV

How to Convert Excel to Dat Picture 1

Open Microsoft Excel. It's in the Microsoft Office group of the All Apps section of the Windows/Start menu.

How to Convert Excel to Dat Picture 2

Click the File menu. It's near the top-left corner of the screen.

How to Convert Excel to Dat Picture 3

Click Open.

How to Convert Excel to Dat Picture 4

Click the file you want to convert. The file will open in Excel.

How to Convert Excel to Dat Picture 5

Click the File menu.

How to Convert Excel to Dat Picture 6

Click Save as….

How to Convert Excel to Dat Picture 7

Navigate to the folder where you want to save the file.

How to Convert Excel to Dat Picture 8

Click the 'Save as type' drop-down menu. A list of file types will appear.

How to Convert Excel to Dat Picture 9

Select CSV (Comma delimited)(*.cvs). This will create a file that can be converted to .DAT format.

How to Convert Excel to Dat Picture 10

Type a name for the file. It goes into the 'File name' field. If you want to accept the current name you can skip this step.

How to Convert Excel to Dat Picture 11

Click Save. A confirmation message will appear.

How to Convert Excel to Dat Picture 12

Click OK. The .CSV file is saved and ready to be converted.

Part 2 of 2:

Converting the .CSV to .DAT

How to Convert Excel to Dat Picture 13

Press Win+E. This opens the file explorer.

How to Convert Excel to Dat Picture 14

Navigate to the folder where you saved the .CSV file. Don't click the file once you open the folder, just bring it onto the screen.

How to Convert Excel to Dat Picture 15

Right-click the file to convert.

How to Convert Excel to Dat Picture 16

Select Open with…. A list of apps will appear.

How to Convert Excel to Dat Picture 17

Click Notepad. The file will open in the Notepad app.

How to Convert Excel to Dat Picture 18

Click the File menu. It's near the top-left corner of Notepad.

How to Convert Excel to Dat Picture 19

Click Save As….

How to Convert Excel to Dat Picture 20

Click the 'Save as type' drop-down menu. It's below the 'File name' field. A list of file types will appear.

How to Convert Excel to Dat Picture 21

Select All Files (*.*). Choosing this option allows you to specify your own file extension.

How to Convert Excel to Dat Picture 22

Rename the file with .DAT at the end. For example, if the 'File name' field currently says Book1.txt, change it to Book1.dat.

It doesn't matter whether the letters in .DAT are capital or lowercase.

How to Convert Excel to Dat Picture 23

Click Save. The original file is now saved in the .DAT format.

4 ★ | 674 Vote

May be interested

  • How to Update ExcelPhoto of How to Update Excel
    this wikihow teaches you how to check for updates in microsoft excel on a windows or mac computer. if updates are available, excel will download and install them as needed. keep in mind that excel, like most microsoft office products, will...
  • How to Remove a Macro in ExcelPhoto of How to Remove a Macro in Excel
    this wikihow teaches you how to remove a macro from a microsoft excel spreadsheet. you can do this from within the spreadsheet's settings in excel on both windows and mac computers. open the macro-enabled excel sheet. double-click the...
  • How to Recover a Corrupt Excel FilePhoto of How to Recover a Corrupt Excel File
    this wikihow teaches you how to recover and repair a corrupted microsoft excel file on your windows or mac computer. make sure that you're using a windows computer. you can only repair an excel file in the windows version of excel.
  • How to Change a Comma to Dot in ExcelPhoto of How to Change a Comma to Dot in Excel
    this wikihow article teaches you how to change a comma to a dot in excel. manually replacing commas with dots in excel can be a time-consuming task. you might run into this situation due to european countries using commas as a decimal...
  • How to Subtract in ExcelPhoto of How to Subtract in Excel
    this wikihow teaches you how to subtract the contents of one or more excel cells from another cell. open excel. it's a green app with a white 'x' on it.
  • How to Make a Family Tree on ExcelPhoto of How to Make a Family Tree on Excel
    family trees are a common school project, and a fun way to show people your ancestry. excel is capable of more complex genealogy projects as well, but for longterm research projects you may prefer specialized software. create a new...