How Can You Use MATLAB with Excel?

MATLAB^® provides advanced tools for data analysis, engineering, and AI beyond the capabilities of Microsoft^® Excel^®. MATLAB can integrate with Excel, enabling you to use functionality from both applications in your projects.

Techniques to Combine MATLAB and Excel

MATLAB and Excel can be combined in a variety of ways, including data exchange, interoperability, and deployment.

Import Data from Excel

Bring Excel data into MATLAB using the Import Tool or commands like readtable. You can directly integrate spreadsheets into MATLAB for additional data preprocessing, analysis, visualization, and simulation.

Control Excel from MATLAB

Automate and edit Excel spreadsheets directly from MATLAB using COM or .NET interfaces. You can perform tasks and apply formatting to Excel files without leaving MATLAB.

Control MATLAB from Excel

Use Spreadsheet Link™ to run MATLAB algorithms and exchange data directly from Excel.

Deploy as Excel Add-In

Package custom algorithms and tools you developed with MATLAB Compiler™. Colleagues can use the compiled MATLAB code from Excel, whether or not they have MATLAB.