Import large CSV file

20 views (last 30 days)
SM on 18 Jan 2021
Answered: SM on 19 Jan 2021
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:
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?
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 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