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

35 views (last 30 days)
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!

Answers (2)

Arif Hoq
Arif Hoq on 26 Oct 2022
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

Mathieu NOE
Mathieu NOE on 26 Oct 2022
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

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by