5 Ways to Import Multiple Excel Sheets into MATLAB

Importing multiple Excel sheets into MATLAB can significantly streamline your data analysis process. Whether you are dealing with time-series data, experimental results, or large datasets, integrating these spreadsheets into MATLAB can allow for complex computations, data visualization, and further statistical analysis. Here are five methods to efficiently import multiple Excel sheets into MATLAB:

Method 1: Using readcell Function

The readcell function is particularly useful when your data contains a mix of numeric, text, and empty cells. This function reads an Excel file into a cell array, which can be very handy for handling irregular or multi-sheet data.

• Step 1: Open MATLAB.
• Step 2: Use the following command:

[file, path] = uigetfile(‘*.xlsx’, ‘Select the Excel file’);
if isequal(file,0)
    disp(‘File selection canceled.’);
else
    filename = fullfile(path, file);
    [~, sheets] = xlsfinfo(filename);
    data = cell(numel(sheets), 1);
    for k = 1:numel(sheets)
        data{k} = readcell(filename, ‘Sheet’, sheets{k});
    end
end

📌 Note: This method assumes that all sheets within the file have data you want to import. If some sheets should be skipped, you will need to modify the code to include sheet filtering logic.

Method 2: Using readtable

If your Excel sheets are structured similarly, with headers that can be interpreted as variables, the readtable function is ideal. It reads data into a table, which MATLAB can then use for analysis or further manipulation.

• Step 1: Use this MATLAB command:

[file, path] = uigetfile(‘*.xlsx’, ‘Select the Excel file’);
if isequal(file,0)
    disp(‘File selection canceled.’);
else
    filename = fullfile(path, file);
    [~, sheets] = xlsfinfo(filename);
    data = table;
    for k = 1:numel(sheets)
        dataSheet = readtable(filename, ‘Sheet’, sheets{k});
        data = [data; dataSheet];
    end
end

🔍 Note: Be aware that stacking tables might result in a very large dataset if sheets contain many rows, which could lead to performance issues.

Method 3: Custom Loop with xlsread

xlsread is an older function but still effective for reading numeric data from Excel files. For custom import scenarios, especially when you need control over what data gets imported, you might choose this method.

• Step 1: Open MATLAB.
• Step 2: Implement the following code:

[filename, pathname] = uigetfile(‘*.xlsx’, ‘Select the Excel file’);
if isequal(filename,0)
    disp(‘File selection canceled.’);
else
    [~, sheets] = xlsfinfo(fullfile(pathname, filename));
    dataCell = cell(numel(sheets), 1);
    for k = 1:numel(sheets)
        dataCell{k} = xlsread(filename, sheets{k});
    end
end

🚨 Note: xlsread can struggle with reading date or text data, so consider your data type before opting for this method.

Method 4: MATLAB’s GUI Interface

For those less inclined to write code, MATLAB’s GUI provides a user-friendly way to import data:

• Step 1: Open MATLAB.
• Step 2: Go to Home tab > Variable section > Click on Import Data.
• Step 3: Navigate to your Excel file and select it.
• Step 4: In the Import Wizard, you can choose which sheets to import. Each sheet will be imported into a separate variable or combined into one table.

Method 5: Using importdata

The importdata function can handle both text and numeric data from Excel files. It’s a more generic solution that doesn’t require specifying sheets individually:

• Step 1: Use the following MATLAB code:

[filename, pathname] = uigetfile(‘*.xlsx’, ‘Select the Excel file’);
if isequal(filename,0)
    disp(‘File selection canceled.’);
else
    data = importdata(fullfile(pathname, filename), ‘ ‘, 1);
end

Importing data from multiple Excel sheets into MATLAB opens up a myriad of possibilities for analysis and visualization. Each method discussed here has its advantages:

• readcell provides flexibility with irregular data.
• readtable is perfect for structured data that fits into a table format.
• xlsread is good for numeric data but limited with dates or strings.
• GUI Import is user-friendly for those less comfortable with coding.
• importdata can handle both text and numeric data with minimal setup.

In summary, the choice of method depends on the structure of your data, the type of analysis you intend to perform, and your comfort with MATLAB scripting. Each approach has unique strengths, making it suitable for different scenarios. With these techniques, you can efficiently manage and analyze data from multiple Excel sheets in MATLAB, enhancing your workflow and providing a solid foundation for further exploration and analysis.

Can I import only specific sheets from an Excel file?

+

Yes, you can. When using readcell, readtable, or xlsread, you can specify which sheets to import by modifying the loop to check against a predefined list of sheet names or indices.

How do I handle data across multiple Excel files?

+

Extend the above methods by using a loop or a function to load files from a directory, then import each Excel file individually.

What if my data includes different ranges in different sheets?

+

Specify the range in the read functions. For example, use readtable(filename, ‘Sheet’, ‘Sheet1’, ‘Range’, ‘A1:D20’) to read only specific ranges.