Spreadsheets

Microsoft^® Excel^® spreadsheets

Read and write data in spreadsheet files, including .xls and .xlsx files. Import spreadsheet data interactively using the Import Tool. Import or export spreadsheet data programmatically using the functions on this page. To compare primary ways to import spreadsheet files, see Ways to Import Spreadsheets.

Functions

expand all

Import Data Interactively

Import Tool

Import data from file

Read and Write Tables or Timetables

Basic Import and Export

`readtable`	Create table from file
`writetable`	Write table to file
`readtimetable`	Create timetable from file
`writetimetable`	Write timetable to file

Define Import Rules

`detectImportOptions`	Create import options based on file content
`spreadsheetImportOptions`	Import options object for Spreadsheets
`getvaropts`	Get variable import options
`setvaropts`	Set variable import options
`setvartype`	Set variable data types
`preview`	Preview eight rows from file using import options

Read and Write Matrices and Arrays

`readmatrix`	Read matrix from file
`writematrix`	Write a matrix to a file
`readcell`	Read cell array from file
`writecell`	Write cell array to file
`readvars`	Read variables from file
`xlsfinfo`	Determine if file contains Microsoft Excel spreadsheet
`importdata`	Load data from file

Objects

spreadsheetDatastore Datastore for spreadsheet files

Topics

Ways to Import Spreadsheets

You can import data from spreadsheet files into MATLAB^® interactively using the Import Tool, programmatically using import functions, or by pasting data from the clipboard.

Write Data to Excel Spreadsheets

Export data in the workspace to a Microsoft Excel spreadsheet file.

Define Import Options for Tables

For customized data import and additional control over the import process, define and use the import options.