How to Convert a DAT File to CSV

A DAT file is a generic data file that is created by a number of different applications. Some DAT files are video or image files, others are text-based database files. If the file is text-based, you can most likely rename the file as a comma separated values (CSV) file, or open the file in a spreadsheet application such as Microsoft Excel. From there, you’ll be able to save the file as a CSV file, a format that is readable by all spreadsheet applications. If you cannot import the file into a spreadsheet, you may need to use a third-party conversion tool.

...
Use your computer to convert a DAT file to CSV.

Save As CSV

Step

Locate a DAT file on your computer.

Step

Right-click the file and select “Open With.”

Step

Select “Microsoft Excel” or a similar spreadsheet application. This will launch the application and open the DAT file.

Step

Go to the “Save as” command to resave the file. Click the “Save as Type” drop-down menu.

Step

Select comma separated values (CSV). Click “Save.”

Rename File

Step

Determine the contents of the DAT file. If you know for sure the file contains text only and is likely a database-type file, you can rename the file extension.

Step

Locate the file on your computer.

Step

Click the name of the file once until you see a box outlining the file name.

Step

Change the ".dat" extension to ".csv."

Step

Open the file in a spreadsheet application in order to view the contents.

Third-party Conversion Tool

Step

Download and install a free trial of a third-party conversion tool such as ABC Amber Clarion Converter or I2C POI Format Converter if the above methods are not possible.

Step

Open the application and select your DAT file to convert it.

Step

Select CSV from the output options.

Step

Click "Save as" or "Start," depending on the tool you are using. The new CSV file will be saved on your computer.