Can I import this CSV file into Matlab?

2 views (last 30 days)
This is the CSV file I have got however it opens through excel and won't import into Matlab using csvread function.
How would I import this?

Accepted Answer

per isakson
per isakson on 24 Apr 2014
Edited: per isakson on 24 Apr 2014
Looks like Excel. Try xlsread
  2 Comments
Franchesca
Franchesca on 24 Apr 2014
No xlsread doesn't work on it either
per isakson
per isakson on 24 Apr 2014
Edited: per isakson on 24 Apr 2014
Doc on csvread says
M = csvread(filename)
reads a comma-separated value formatted file, filename. The file can only contain numeric values.
That might explain why you failed with xlsread. Did you try specifying row,col? Doc says
M = csvread(filename,row,col)
reads data from the file starting at the specified row and column. The row and column arguments are zero based, so that row = 0 and col = 0 specify the first value in the file.

Sign in to comment.

More Answers (1)

Image Analyst
Image Analyst on 24 Apr 2014
Edited: Image Analyst on 24 Apr 2014
Use readtable():
t = readtable('trial01.csv', 'headerlines', 3);
Or if you have an old version of MATLAB, use dlmread.

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!