How to Convert Excel to Dat

PDF download Download Article
PDF download Download Article

This wikiHow teaches you how to convert a Microsoft Excel file (.XLS) to the .DAT format on a Windows PC. You’ll begin by converting the .XLS file to .CSV (comma separated values) format, and then you can convert to .DAT in an app like Notepad.

Quick .XLS to .DAT Conversion Steps

  1. Open your .XLS document in Excel.
  2. Navigate to File > Save as... .
  3. Change the Save as type drop-down to CSV (Comma delimited(*.csv) .
  4. Save the file in your desired location.
  5. Open the .CSV file in Notepad and navigate to File > Save as... .
  6. Change the Save as type drop-down to All Files (*.*) .
  7. Save the file as "[filename].DAT" where [filename] is your desired file name.
Part 1
Part 1 of 2:

Converting to .CSV

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5a\/Convert-Excel-to-Dat-Step-1.jpg\/v4-460px-Convert-Excel-to-Dat-Step-1.jpg","bigUrl":"\/images\/thumb\/5\/5a\/Convert-Excel-to-Dat-Step-1.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    It’s in the Microsoft Office group of the All Apps section of the Windows/Start menu.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2c\/Convert-Excel-to-Dat-Step-2.jpg\/v4-460px-Convert-Excel-to-Dat-Step-2.jpg","bigUrl":"\/images\/thumb\/2\/2c\/Convert-Excel-to-Dat-Step-2.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-2.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    It’s near the top-left corner of the screen.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/39\/Convert-Excel-to-Dat-Step-3.jpg\/v4-460px-Convert-Excel-to-Dat-Step-3.jpg","bigUrl":"\/images\/thumb\/3\/39\/Convert-Excel-to-Dat-Step-3.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-3.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6e\/Convert-Excel-to-Dat-Step-4.jpg\/v4-460px-Convert-Excel-to-Dat-Step-4.jpg","bigUrl":"\/images\/thumb\/6\/6e\/Convert-Excel-to-Dat-Step-4.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The file will open in Excel.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bf\/Convert-Excel-to-Dat-Step-5.jpg\/v4-460px-Convert-Excel-to-Dat-Step-5.jpg","bigUrl":"\/images\/thumb\/b\/bf\/Convert-Excel-to-Dat-Step-5.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-5.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c8\/Convert-Excel-to-Dat-Step-6.jpg\/v4-460px-Convert-Excel-to-Dat-Step-6.jpg","bigUrl":"\/images\/thumb\/c\/c8\/Convert-Excel-to-Dat-Step-6.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/38\/Convert-Excel-to-Dat-Step-7.jpg\/v4-460px-Convert-Excel-to-Dat-Step-7.jpg","bigUrl":"\/images\/thumb\/3\/38\/Convert-Excel-to-Dat-Step-7.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Convert-Excel-to-Dat-Step-8.jpg\/v4-460px-Convert-Excel-to-Dat-Step-8.jpg","bigUrl":"\/images\/thumb\/3\/3c\/Convert-Excel-to-Dat-Step-8.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    A list of file types will appear.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1b\/Convert-Excel-to-Dat-Step-9.jpg\/v4-460px-Convert-Excel-to-Dat-Step-9.jpg","bigUrl":"\/images\/thumb\/1\/1b\/Convert-Excel-to-Dat-Step-9.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This will create a file that can be converted to .DAT format.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/eb\/Convert-Excel-to-Dat-Step-10.jpg\/v4-460px-Convert-Excel-to-Dat-Step-10.jpg","bigUrl":"\/images\/thumb\/e\/eb\/Convert-Excel-to-Dat-Step-10.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    It goes into the “File name” field. If you want to accept the current name you can skip this step.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bb\/Convert-Excel-to-Dat-Step-11.jpg\/v4-460px-Convert-Excel-to-Dat-Step-11.jpg","bigUrl":"\/images\/thumb\/b\/bb\/Convert-Excel-to-Dat-Step-11.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    A confirmation message will appear.
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7f\/Convert-Excel-to-Dat-Step-12.jpg\/v4-460px-Convert-Excel-to-Dat-Step-12.jpg","bigUrl":"\/images\/thumb\/7\/7f\/Convert-Excel-to-Dat-Step-12.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The .CSV file is saved and ready to be converted.
    13. Advertisement
Part 2
Part 2 of 2:

Converting the .CSV to .DAT

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a0\/Convert-Excel-to-Dat-Step-13.jpg\/v4-460px-Convert-Excel-to-Dat-Step-13.jpg","bigUrl":"\/images\/thumb\/a\/a0\/Convert-Excel-to-Dat-Step-13.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-13.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This opens the file explorer.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/01\/Convert-Excel-to-Dat-Step-14.jpg\/v4-460px-Convert-Excel-to-Dat-Step-14.jpg","bigUrl":"\/images\/thumb\/0\/01\/Convert-Excel-to-Dat-Step-14.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Don’t click the file once you open the folder, just bring it onto the screen.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4a\/Convert-Excel-to-Dat-Step-15.jpg\/v4-460px-Convert-Excel-to-Dat-Step-15.jpg","bigUrl":"\/images\/thumb\/4\/4a\/Convert-Excel-to-Dat-Step-15.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-15.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ee\/Convert-Excel-to-Dat-Step-16.jpg\/v4-460px-Convert-Excel-to-Dat-Step-16.jpg","bigUrl":"\/images\/thumb\/e\/ee\/Convert-Excel-to-Dat-Step-16.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-16.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    A list of apps will appear.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-17.jpg\/v4-460px-Convert-Excel-to-Dat-Step-17.jpg","bigUrl":"\/images\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-17.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-17.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The file will open in the Notepad app.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Convert-Excel-to-Dat-Step-18.jpg\/v4-460px-Convert-Excel-to-Dat-Step-18.jpg","bigUrl":"\/images\/thumb\/6\/6b\/Convert-Excel-to-Dat-Step-18.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-18.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    It’s near the top-left corner of Notepad.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c6\/Convert-Excel-to-Dat-Step-19.jpg\/v4-460px-Convert-Excel-to-Dat-Step-19.jpg","bigUrl":"\/images\/thumb\/c\/c6\/Convert-Excel-to-Dat-Step-19.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-19.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Convert-Excel-to-Dat-Step-20.jpg\/v4-460px-Convert-Excel-to-Dat-Step-20.jpg","bigUrl":"\/images\/thumb\/4\/48\/Convert-Excel-to-Dat-Step-20.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-20.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    It’s below the “File name” field. A list of file types will appear.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/af\/Convert-Excel-to-Dat-Step-21.jpg\/v4-460px-Convert-Excel-to-Dat-Step-21.jpg","bigUrl":"\/images\/thumb\/a\/af\/Convert-Excel-to-Dat-Step-21.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-21.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Choosing this option allows you to specify your own file extension.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Convert-Excel-to-Dat-Step-22.jpg\/v4-460px-Convert-Excel-to-Dat-Step-22.jpg","bigUrl":"\/images\/thumb\/4\/4c\/Convert-Excel-to-Dat-Step-22.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-22.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-23.jpg\/v4-460px-Convert-Excel-to-Dat-Step-23.jpg","bigUrl":"\/images\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-23.jpg\/aid9586404-v4-728px-Convert-Excel-to-Dat-Step-23.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The original file is now saved in the .DAT format.
    12. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Link Sheets in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      How to Combine Columns in Excel Without Losing Data
      Advertisement

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 98,334 times.

      Is this article up to date?

      Advertisement