You can import data from spreadsheet files into MATLAB® interactively or programmatically, using an import function.
This table compares the primary ways to import spreadsheet files.
Ways to Import Spreadsheet Files
For More Information, See...
Import a worksheet or range to column vectors, a matrix, a cell array, or a table. You can generate code to repeat the operation on multiple files that are similar.
Import a worksheet or range to a table.
Import a worksheet or range to numeric and cell arrays.
Import data from one or more worksheets in a file.
Import data from from a collection of spreadsheet files.
Some import options require that your system includes Excel® for Windows®. For more information, see System Requirements and Supported File Formats for Spreadsheets.
Paste data from the clipboard into MATLAB using one of the following methods:
On the Workspace browser title bar, click , and then select Paste.
Open an existing variable in the Variables editor, right-click, and then select Paste Excel Data.