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.
You should read it
- How to Save a Microsoft Word Document
- How to Convert Powerpoint to Jpeg
- How to save web pages as PDFs on iPhone and iPad
- How to save files to multiple folders on the web browser
- Steps to save Email as PDF
- How to save AI file in Adobe Illustrator to JPG and other image formats
- How to save Zip file to iPhone or iPad
- 3 How to rotate a PDF file and save it as the simplest new file
- How to Zip a PowerPoint File
- How to Change a File Extension
- How to Save Images to PNG Format
- How to Convert a Doc File to a Docx File