We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Convert a DAT File to CSV

Updated March 23, 2017

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.

Loading ...
  1. Locate a DAT file on your computer.

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

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

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

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

  6. 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.

  7. Locate the file on your computer.

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

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

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

  11. 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.

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

  13. Select CSV from the output options.

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

Loading ...

About the Author

Amy Dombrower is a journalist and freelance writer living in Chicago. She worked in the newspaper industry for three years and enjoys writing about technology, health, paper crafts and life improvement. Some of her passions are graphic design, movies, music and fitness. Dombrower earned her Bachelor of Arts in journalism from The University of North Carolina at Chapel Hill.

Loading ...