How to Convert a DAT File to CSV

Written by amy dombrower
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Convert a DAT File to CSV
Use your computer to convert a DAT file to CSV. (holding laptop image by Adam Borkowski from Fotolia.com)

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.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

    Save As CSV

  1. 1

    Locate a DAT file on your computer.

  2. 2

    Right-click the file and select "Open With."

  3. 3

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

  4. 4

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

  5. 5

    Select comma separated values (CSV). Click "Save."

    Rename File

  1. 1

    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.

  2. 2

    Locate the file on your computer.

  3. 3

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

  4. 4

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

  5. 5

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

    Third-party Conversion Tool

  1. 1

    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.

  2. 2

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

  3. 3

    Select CSV from the output options.

  4. 4

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

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.