Importing big data from txt/excel file

Hi all,

I have quite large number of battery test data which contain hundreds of thousands data from each 13 columns (totally million of them). I generally convert them into txt and/or excel. However, when importing the file by using xlsread or import; it takes a few hours.

I'm looking for a more easy way to import txt or excel file in a shorter time. My purpose is to draw a 2D plot choosing any 2 columns of them.

[Wei Wang]

You can use the function: tall to deal with the big data. It is extremely fast.

good luck.

Answer 1

[Robert Alvarez]

Read your data into excel then export them as comma-separated-values (csv) then read into Matlab with csvread