Convert multiple csv to xls files.

Hi!

I have a folder containing many excel files ( more than 200) in csv format . I need to write all these files in xls format.

Can this be done in matlab . Can anyone please help.

Thanks in advance

Answer 1

[Azzi Abdelmalek]

yourfolder='E:\matlab'
d=dir([yourfolder '\*.csv']);
files={d.name};
for k=1:numel(files)
   old_name=files{k}; 
   [~,~,b] = xlsread(old_name) ;
   new_name=strrep(old_name,'csv','xls')
   xlswrite(new_name,b);
end

[avantika]

Hi!

Thanks

But is there a way to save these xls files to new folder?

[Azzi Abdelmalek]

yourfolder='E:\matlab'
d=dir([yourfolder '\*.csv']);
files={d.name};
for k=1:numel(files)
 old_name=files{k}; 
 [~,~,b] = xlsread(old_name) ;
 new_name=strrep(old_name,'csv','xls')  
 new_folder='E:\another'
 new_file=fullfile(new_folder,new_name)
 xlswrite(new_file,b);
end

[avantika]

thanks a lot!

[Image Analyst]

Avantika, you forgot to accept it, so I did it for you.

[Robert Jones]

great info. Q: how to merge the *.csv files as sheets of ONE excel file?

[Walter Roberson]

More correct would be

yourfolder = 'E:\matlab'
d = dir(fullfile(yourfolder, '*.csv'));
files = {d.name};
for k=1:numel(files)
 old_name = files{k}; 
 [~,~,b] = xlsread( fullfile(yourfolder, old_name)) ;
 new_name = strrep(old_name,'csv','xls')  
 new_folder = 'E:\another'
 new_file = fullfile(new_folder, new_name)
 xlswrite(new_file,b);
end

[Onur ALPAY]

Hi,

I am using MATLAB 2019a version and it looks there is no problem with version. I try this code but I realized that the below code doesn't work. It gives me the same file name. Do you have any experiance about that?

new_name = strrep(old_name,'csv','xls')

Answer 2

[Fabian Neira]

I got the following error "File name must be a character vector" when using the code.

[Walter Roberson]

Please post your code.

Answer 3

[Lotan Jackson]

Hi everyone, I know this is an old question but I had to adjust things for either the newest version or being on a newest matlab version. Here's the code. I placed all the files in the folder with the script.

file = dir('*.csv'); 
s= size(file,1);
for i= 1:s
    Data = readtable(file(i).name);
    filename=file(i).name;
    filename= filename(1:end-5); 
    writetable(Data,[filename '.xls']);
end;

Hope this helps anyone in the future. :)

[Marcos dos Santos]

It helped me. Thank you, Lotan!