Cannot read csv with readtable (Unrecognized field name "text")
显示 更早的评论
Hi All,
I'm trying to read some csv data but saw the following error, for which I had absolutely no clue... Could anyone kindly help?
aaa.csv is just a simple dummy dataset I created with excel for the sake of testing.
Error from matlab:
aaa = readtable('G:\My Drive\Project_GDrive\data\aaa.csv');
Error using readtable (line 517)
Unrecognized field name "text".
Many thanks
Min
12 个评论
aaa = readtable('aaa.csv')
Please show us the complete output from this command:
which readtable -all
Min
2025-1-20
the cyclist
2025-1-20
Hm, that's puzzling. I think one would typically get this error when you attempt to use an option or parameter that is not valid for the version of MATLAB you are using, or some other syntax issue.
But you seem to be using 2024a, and are not using any aditional options. Is
readtable('G:\My Drive\Project_GDrive\data\aaa.csv');
definitely the calling syntax that gives the error, or might you have called it differently?
The usual cause of that error is that you have shadowed some text function (e.g. REPLACE):
In which case you can fix it by removing/renaming the offending function.
Do you have some third-party toolbox installed or your own functions?
Min
2025-1-20
@the cyclist: I tried to save the file in different location (e.g. readtable("C:\Users\minuser\Desktop\abc.csv") so that the space in the path is gone), but still the same error...
@Stephen23: It's a fresh installation and the following add-ons are installed. But I don't think I have other third party toolbox installed.
Stephen23
2025-1-20
Try restoredefaultpath.
Min
2025-1-20
Stephen23
2025-1-20
Try specifying the option FileType='text'.
Min
2025-1-21
Stephen23
2025-1-21
Contact TMW directly for technical support: https://www.mathworks.com/support/contact_us.html
I would suggest
dbstop if caught error
and then run the code. It should stop at the place the error actually occurs. It is quite unlikely that it is stopping at
which readtable
line 517, as that readtable has no-where near 517 lines.
Walter Roberson
2025-8-12
Ah, in R2024a, readtable.m line 517 contains a throw() for an exception that was taken in another function. Tracking the problem is a bit more of a nuisance, but
dbstop if caught error
would help
回答（2 个）
You mistyped the file name. It is read correctly - see:
D = readtable('aaa.csv');
disp(D)
4 个评论
Min
2025-1-21
Walter Roberson
2025-8-10
Which MATLAB release are you using? In all recent versions, readtable.m itself is fairly short code, with no-where near 517 lines
I suspect that you have a third-party function with the same name as a Mathworks supplied function.
Image Analyst
2025-8-11
His error message said he was using r2024a.
Min
2025-8-12
Min
2025-1-21
移动：Walter Roberson
2025-1-21
0 个投票
1 个评论
Matteo
2025-8-10
Just to support the the comment - I just had the same problem and I also was able to run the code after rebooting. The dbstop if caught error command also stops at the same place, seems to have to do with some settings from matlab.io missing the 'text' entries. Maybe these settings were modified by something else and a fresh restart ensured that they were not affected?
类别
在 帮助中心 和 File Exchange 中查找有关 Calendar 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
