How do I get a range of data from csv with unequal columns?

I want to read in a section of this data.csv. Everything works fine with the xlsx version of the file.

A = xlsread(filename,1, 'I9..N30008');

The trouble is I would rather pull it in as a csv so that I don't have to save all my csv files as xlsx. I think the difficulty arises since there are not equal column numbers on every row.

Answer 1

[Walter Roberson]

T = readtable('data.csv', 'HeaderLines', 8, 'ReadVariableNames', false, 'Delimiter', ',');

If you need to convert the second column into dates, then

dates = datetime(T{:,2}, 'InputFormat', 'MM/dd/yyyy hh:mm:ss.SSS a');

and the pure numeric part (ignoring the first column that gives row numbers) would be

num = T{:,3:14};

The events are at T{:,15} and T{:,16}