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
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Unprotect an Excel Sheet
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Unhide Multiple Rows in Microsoft Excel
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Add a Column or Calculated Field in an Excel Pivot Table
      The Best Ways to Make & Format Lists in Excel
      How to
      Add a Best Fit Line in Excel
      Advertisement

      About This Article

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

      Is this article up to date?

      Advertisement