How to Convert an Excel File to Dat (with Images)

Table of contents:

How to Convert an Excel File to Dat (with Images)
How to Convert an Excel File to Dat (with Images)
Anonim

This article explains how to convert a Microsoft Excel (. XLS) file on a Windows PC to. DAT format. We start by converting the. XLS file into. CSV (Comma Separated Values) format, then we move on to converting the. DAT with the Notepad program.

Steps

Part 1 of 2: Convert to. CSV

Convert Excel to Dat Step 1
Convert Excel to Dat Step 1

Step 1. Open Microsoft Excel

It is located within the group Microsoft Office in the section All programs from the Windows Start menu.

Convert Excel to Dat Step 2
Convert Excel to Dat Step 2

Step 2. Click on the File menu

It is located in the upper left corner of the screen.

Convert Excel to Dat Step 3
Convert Excel to Dat Step 3

Step 3. Click Open

Convert Excel to Dat Step 4
Convert Excel to Dat Step 4

Step 4. Click on the name of the file you want to convert

The file will open in Excel.

Convert Excel to Dat Step 5
Convert Excel to Dat Step 5

Step 5. Click on the File menu

Convert Excel to Dat Step 6
Convert Excel to Dat Step 6

Step 6. Click Save As

Convert Excel to Dat Step 7
Convert Excel to Dat Step 7

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

Convert Excel to Dat Step 8
Convert Excel to Dat Step 8

Step 8. Click on the "Save As" drop-down menu

A list of formats will appear.

Convert Excel to Dat Step 9
Convert Excel to Dat Step 9

Step 9. Select CSV (delimited by list separator) (*.cvs)

This command creates a file that you can convert to the. DAT format.

Convert Excel to Dat Step 10
Convert Excel to Dat Step 10

Step 10. Enter the name you want to give the file

The field to insert it in is "File Name". You can also accept the name the program suggests automatically and skip this step.

Convert Excel to Dat Step 11
Convert Excel to Dat Step 11

Step 11. Click the Save button

Two dialog boxes with format warnings will open.

Convert Excel to Dat Step 12
Convert Excel to Dat Step 12

Step 12. In both cases, confirm by clicking on the OK button

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

Part 2 of 2: Convert the. CSV file to. DAT

Convert Excel to Dat Step 13
Convert Excel to Dat Step 13

Step 1. Press the key combination ⊞ Win + E

This command opens the file manager.

Convert Excel to Dat Step 14
Convert Excel to Dat Step 14

Step 2. Select the folder where you saved your. CSV file

When you have opened the folder do not click on the file name, just bring it to the screen.

Convert Excel to Dat Step 15
Convert Excel to Dat Step 15

Step 3. Right click on the name of the file to convert

Convert Excel to Dat Step 16
Convert Excel to Dat Step 16

Step 4. Select Open With

A list of programs will appear.

Convert Excel to Dat Step 17
Convert Excel to Dat Step 17

Step 5. Click on Notepad

The file will open in Notepad.

Convert Excel to Dat Step 18
Convert Excel to Dat Step 18

Step 6. Click on the File menu

It is in the upper left corner of the screen.

Convert Excel to Dat Step 19
Convert Excel to Dat Step 19

Step 7. Click Save As…

Convert Excel to Dat Step 20
Convert Excel to Dat Step 20

Step 8. Click on the "Save As" drop-down menu

It is located under the "File Name" field. A list of formats will appear.

Convert Excel to Dat Step 21
Convert Excel to Dat Step 21

Step 9. Select All files (*. *)

Choosing this option allows you to specify the file extension.

Convert Excel to Dat Step 22
Convert Excel to Dat Step 22

Step 10. Rename the file by writing. DAT at the end, where the extension is

For example, if the "Filename" field contains Book1.txt, change it to Book1.dat.

The file name is not "case sensitive", so it does not matter whether it is uppercase or lowercase

Convert Excel to Dat Step 23
Convert Excel to Dat Step 23

Step 11. Click the Save button

The original file has now been saved in. DAT format.

Recommended: