T = readtable ('plot 1.xlsx'); results in 1st line used as headers (good), but text of headers in lines 2-4 cause all remaining (numeric) data to be read in as text, not numeric data (bad). C = readcell (filename,opts) additionally uses the import options opts. How can I load .tab file with header in MATLAB for jj = 1:length (impt_rows) hours_populate (jj) = xlsColNum2Str (impt_rows (jj)+5) %for whatever col num starting on. It would, though, allow for the possibility of fopen() the file, fgetl() one line, fclose(), split the input line to get the column headers, then csvread() the file telling it to skip the first row. xlsread (MATLAB Functions) xlsread (MATLAB Functions) How to read import csv file with required header while importing ... Test with spaces between column labels: how to import csv file in matlab - MathWorks This needs to be imported into MATLAB for calculations and plotting. 1. Fields and Characters to Ignore. Matlab functions for reading/writing text files - Comillas readmatrix determines the file format from the file extension: .txt, .dat, or .csv for delimited text files. How I can read a CSV file with header?. Read matrix from file - MATLAB readmatrix - MathWorks raw, output argument. But I like to simply double-click on the file from the current folder directory. How do I create variable names from Excel file header ... - MathWorks You can see that the range field is . See the example code below. How can I import data from .csv file with numeric ... - MATLAB & Simulink I'd like to read them into tables, picking up the first line as column labels, skipping lines 2-4, then reading the rest of the file. How to read import csv file with required header while ... - MathWorks