How to Convert MAT to XLS with Stat/Transfer
MAT files are actually binary data files created and used by MatLAB applications. This type of file usually contains arrays, functions, variables, expressions, and other mathematical data. XLS is one of the filename extensions used for Excel spreadsheets. XLS files are commonly used for the older version of Microsoft Excel (as the newer versions apply XLSX) and they contain data arranged in rows and columns. Converting MAT files to XLS spreadsheets can be useful if you want to quickly export data from your MatLAB as a format supported by multiple applications (compared to MAT files that are mainly used by MatLAB).
I will demonstrate the conversion process using Stat/Transfer 1.0 (Shareware $295) by Circle Systems, Inc., because it is one of the few methods you can turn MAT files into XLS without having to deal with MatLAB. It is also very easy to use as you will see from the following guide.
You will need to download the following software to keep up with this tutorial.
Here are the simple steps you will need to complete in order to convert your files
Select MatLAB as the input file type.
Select MatLab as the Input Format
Load your MAT file by clicking on the "Browse" button.
Choose "Excel '97-2003" as the output file type.
Change the output location by pressing the "Browse" button.
Click on the "Transfer" button to start the conversion.
a. Select which columns you want to convert to XLS from your MAT file by clicking on the "Variables" tab.
b. Customize the output file by clicking on the "Options" tab and modifying any desired entry (see the image).
As you can see, turning MatLAB MAT files into Excel XLS spreadsheets with Stat/Transfer is a pretty simple process (as long as you don't have to modify any parameters). The only other way to perform the conversion task (at least, the only one that I've found) is by using MatLAB applications and the xlswrite command. I believe that the presented method is much easier and cheaper than the alternative.
- Easy to use
- Support for large number of formats
- Lots of output customization options
- A bit expensive ($295)