Import large CSV file

20 views (last 30 days)
SM
SM on 18 Jan 2021
Answered: SM on 19 Jan 2021
Hello
I have a CSV file that has 239615 rows and 24 columns with 85 Mb size.
the first row is headers and the rest of it are numbers.
I tried the following methods:
1-readmatrix
2-readtable
3-Matlab import
all of them only read up to 238491 and ignored rest of it.
Does anyone have any idea how to read the whole file?
Cheers
  4 Comments
Walter Roberson
Walter Roberson on 18 Jan 2021
xls files have a maximum of 65535 rows, but cvs files should not have that limitation.
As an experiment, try readmatrix with the 'Encoding', 'UTF-8' option.

Sign in to comment.

Answers (1)

SM
SM on 19 Jan 2021
Thank you everyone
It seems there was a malfunction in microsoft excel.
It resolved spontaneously.

Community Treasure Hunt

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

Start Hunting!

Translated by