How to Convert MAT to XLS

Updated July 20, 2017

A file with a ".mat" extension is a binary data file commonly used by MATLAB applications. This file may include arrays, variables, functions and other types of data. A file with the ".xls" extension is a spreadsheet commonly used by Microsoft Excel applications in which data is stored in a table with rows and columns. Users can convert a ".mat" file to ".xls" from the MATLAB application in order to be able to read their data on any computer containing Microsoft Excel. It is easier to transfer ".xls" files through e-mail because their size is less than the ".mat" files by a significant amount.

Double-click the MATLAB application icon from your desktop to open the program. If the icon is not available on your desktop, open the MATLAB application link from "Start," "Programs," "MATLAB" and "MATLAB x," where x stands for the application's version number.

Type the command "load NewFile" in the command window and press the "Enter" key, where "NewFile" is the name of the ".mat" file you wish to convert to an ".xls" file. This command will load the contents of the ".mat" file and store them in MATLAB application's memory.

Type the command "xlswrite('NewExcelFile.xls', 'NewFile')" in the command window and press the "Enter" key, where "NewExcelFile.xls" is the Microsoft Excel file in which you want the data from the ".mat" file to be saved.

Double-click the "My Computer" icon from your desktop and browse to the folder location where the ".mat" file is stored. Check the folder to see if a file called "NewExcelFile.xls" is created. Double-click the "NewExcelFile.xls" file to open it with Microsoft Excel.

Things You'll Need

  • Computer with Windows XP operating system
  • MATLAB application
bibliography-icon icon for annotation tool Cite this Article

About the Author

Nachiket Deshmukh is a tech savvy professional with 11 years of experience in aerospace, engineering and IT industry. He is always on a lookout for low cost technology implementations for DIY home automation. Many of his articles have been published on eHow in personal finance and technology domains.