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 convert PDF files to Excel keeps formattingHow to convert PDF files to Excel keeps formatting
    previously, tipsmake.com sent to you how to convert excel files to pdf. today, we will guide you to convert back, ie from pdf to excel, through online tools that are completely free and very easy to use smallpdf. please consult.
  • How to convert Cad to Word, PDF, ExcelHow to convert Cad to Word, PDF, Excel
    after designing cad drawings, you want to transfer cad to word, excel to print, present ... or you want to transfer cad to pdf so that any computer can read this file but don't know how to do it what? don't worry, the following article will guide you to transfer cad to word, pdf, excel very simply but not everyone knows it!
  • Excel - Convert columns to rows in ExcelExcel - Convert columns to rows in Excel
    if you have an excel file and enter data in the wrong row or column or vice versa, what will you do? would you delete it and re-enter it? that takes up a lot of your time. let's see how taimienphi.vn guides you on how to convert columns into rows in excel.
  • How to Convert Measurements Easily in Microsoft ExcelHow to Convert Measurements Easily in Microsoft Excel
    excel's convert function ('=convert()') converts a measurement from one unit to another. to use this function, you will enter data and units into the formula: =convert(number, 'from_unit', 'to_unit'). first learn how to enter the convert...
  • How to convert a CSV file to ExcelHow to convert a CSV file to Excel
    how to convert a csv file to excel. csv stands for comma separated values, which is a simple text format where values ​​are separated by commas. both csv and excel are files that help store data in spreadsheets. however, csv also has advantages and disadvantages compared to excel software. t
  • 3 Ways to Convert CSV to Excel Successfully3 Ways to Convert CSV to Excel Successfully
    csv is a popular data format but it is not easy to work with without the right tools. this article will guide you through the simple and optimal way to convert csv to excel, helping you quickly summarize data.
  • How to convert numbers into words in Excel?How to convert numbers into words in Excel?
    in excel, entering and typing amounts is very tiring, sometimes confusing. so why do this work faster but still have to ensure accuracy? tipsmake.com will introduce you to a support tool, or more accurately, an additional add-in for microsoft excel, very convenient for accounting, finance, people who have to work with big amounts ...
  • How to convert fonts in ExcelHow to convert fonts in Excel
    how to convert fonts in excel. the default font for excel in the publisher's settings is calibri. this is a basic unicode font that is easy to use but if you use it for a long time you may find it boring and nothing special.
  • How to convert Celsius to Fahrenheit in ExcelHow to convert Celsius to Fahrenheit in Excel
    by default, we will always write the celsius symbol in excel, but in some cases, according to document requirements, you need to write fahrenheit, such as in technical documents, professional documents,...
  • How to convert a sequence of numbers into dates in ExcelHow to convert a sequence of numbers into dates in Excel
    on excel, we can convert the sequence of numbers into dates without manually entering data.