System Requirements for Importing Spreadsheets

Importing Spreadsheets with Excel for Windows

If your system has Excel® for Windows® installed, including the COM server (part of the typical installation of Excel):

  • All MATLAB® import options support XLS, XLSX, XLSB, XLSM, XLTM, and XLTX formats.

  • xlsread also imports HTML-based formats.

  • xlsread includes an option to open Excel and select the range of data interactively. To use this option, call xlsread with the following syntax:

    mydata = xlsread(filename, -1)
  • If you have Excel 2003 installed, but want to read a 2007 format (such as XLSX, XLSB, or XLSM), install the Office 2007 Compatibility Pack.

  • If you have Excel 2010, all MATLAB import options support ODS files.

    Note:   Large files in XLSX format sometimes load slowly. For better import and export performance, Microsoft® recommends that you use the XLSB format.

Importing Spreadsheets Without Excel for Windows

If your system does not have Excel for Windows installed, or the COM server is not available:

  • All MATLAB import options read XLS, XLSX, XLSM, XLTM, and XLTX files.

Was this topic helpful?