How do we convert downloaded .dat files into Excel?
If you've downloaded a .dat file, it means you're working with data created with a version of SSI Web prior to version 8. Unfortunately there is no way to grab a .dat file and convert it to something else short of writing your own script to parse it and write it out to another format. However, if you have the original .ssi file, you can place the .dat file into your SSI Web study, and then export the data (or specific variables within that data) to the file type of your choosing, such as CSV, Excel, SPSS, etc.
In version 8 you can download the data from your administrative module directly to a CSV file (though the same export options also exist).