Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Hepler, Kansas, USA
    Posts
    151
    Thanks
    6
    Thanked 0 Times in 0 Posts
    How do I open a .dat file in Microsoft Excel? I have Windows 7 and use Office 2003.

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Do you know what info is in the .dat file?
    Do you know the source of the .dat file?
    What program created the .dat file?

  3. #3
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Hepler, Kansas, USA
    Posts
    151
    Thanks
    6
    Thanked 0 Times in 0 Posts
    It's a spreadsheet of data from the county appraiser's office. I don't know what program they used to creat it.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    File - open
    select type: all files (*.*)
    browse to where it is and open it.

    If you are lucky EXCEL will be able to read it. If it is an unknown type, you will have to get the person who saved the dat file to save it under a different format...

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Hepler, Kansas, USA
    Posts
    151
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Thanks. I clicked on the file, clicked open and was given 2 options. One to find a program on the web that would open it. I tried that and all I got were a lot of websites that wanted to sell me something. I clicked on select from a program already installed on this computer, selected Microsoft Works spreadsheet (which I had to install) and the file opened perfectly.

  6. #6
    New Lounger
    Join Date
    Jan 2010
    Location
    Rochester, NY
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In my expercience most .dat files are text files. You should be able to open in a text editor and copy to a spreadsheet and parse the data into columns. As long as the formatting is consistent it should work.

  7. #7
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Hepler, Kansas, USA
    Posts
    151
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Thank you for your reply. I learned a new word and a new function of Excel. I'd never heard of "parsing" so I've downloaded support information from microsoft to begin a new learning experience. I'm 70. You can teach an old dog new tricks.

  8. #8
    New Lounger
    Join Date
    Dec 2009
    Location
    Ontario
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Dat files are often created by MS Outlook and contain your spreadsheet, but in a text format. Theres a utility out there called WinMail Opener that will properly open the dat file and allow you access to the actual .xls file, and it's free.

    http://www.eolsoft.com/freeware/winmail_opener/

  9. #9
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Hepler, Kansas, USA
    Posts
    151
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Thanks for your reply. I looked at the website you referred to and decided I probably could get by just opening the .dat files using the options already included in Windows 7. Seemed pretty complicated for a 70 year old.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •