importing csv file into MATLAB gives an error

I am trying to read in a CSV-file into MATLAB R2013b, but I keep receiving errors. I am positive my formatting is properly aligned with my columns in my Excel sheet.

>> exampletable = readtable('example.csv', 'ReadVariableNames',false, 'Delimiter',',', 'TreatAsEmpty','', 'Format','%s%s%s%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f');

Error using table/readTextFile (line 184)

Unable to read the entire file. You may need to specify a different format string, delimiter, or

number of header lines.

Error in table.readFromFile (line 41)

t = table.readTextFile(filename,otherArgs);

Error in readtable (line 114)

t = table.readFromFile(filename,varargin);

Caused by:

Reading failed at line 1. A field on that line may have contained the wrong type of value.

Answer 1

[MathWorks Support Team]

In R2013b, you must specify the 'FileType' as 'spreadsheet'. You do not need to give MATLAB the format for every column nor give a 'Delimiter' because it is a spreadsheet.

>> exampletable = readtable('example.csv','FileType', 'spreadsheet', 'ReadVariableNames', false);

In newer versions of MATLAB, such as R2016a and later, you can simply call:

>> exampletable = readtable('example.csv');

[Kenny Shu]

Hi Asad, try using "detectImportOptions" as mentioned in this answer:

https://www.mathworks.com/matlabcentral/answers/307423-error-using-readtable-cannot-interpret-data-in-the-file-txt