How do I import multiple CSV files from a directory as tables in the workspace?

Hi!

I have 17 csv files in a directory names as 0000,0001,0002, and so on. I want to import all these csv files as table in the workspace. How can I do that?

Thanks in advance for the help!

Answer 1

[Arif Hoq]

Try this:

% Get a list of all files in the folder with the desired file name pattern.
myFolder='\\msint82\redirect$\4136\Desktop\a20220729';  
filePattern = fullfile(myFolder, '*.csv'); % Change to whatever pattern you need.
fileList = dir(filePattern);
for k = 1 : length(fileList)
    % Read in this table.
    baseFileName = fileList(k).name;
    fullFileName = fullfile(fileList(k).folder, baseFileName);
    thisTable = readtable(fullFileName,'VariableNamingRule','preserve'); 
end

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

https://matlab.fandom.com/wiki/FAQ#How_can_I_process_a_sequence_of_files?

Answer 2

[Mathieu NOE]

hello

try this

%% read multiple csv files 
P = pwd; % currrent directory
S = dir(fullfile(P,'*.csv')); % get list of files in directory

for k = 1:numel(S)
    F = fullfile(S(k).folder, S(k).name);
    T{k} = readtable(F); % cell array of tables 
end