Tranfering excel to mat

I have about 45 data files (all with hundreds of thousands of data points) all in either text format or excel. How to I transfer them from to MAT files in the most efficient way possible? Thanks!

Answer 1

[Niels]

i can think of 1 way, but it can be quite annoying.

you use textscan to read the data from .txt files and xlsread for the excel files. save the data in variables and then use save. the result will be a .mat file. (it may be easier to save them all in the array of one variable)

if the files are located in 1 folder its easier, you can use dir and a for loop