How to export a matlab table as a excel/csv file?

55 views (last 30 days)
Hi everyone,
Mya someone suggest me how i can export the Matlab table as a csv/excel file?

Accepted Answer

Cris LaPierre
Cris LaPierre on 31 May 2023
Edited: Cris LaPierre on 31 May 2023
I suggest using writetable.
writetable determines the file format based on the specified extension. The extension must be one of the following:
  • .txt, .dat, or .csv for delimited text files
  • .xls, .xlsm, or .xlsx for Excel® spreadsheet files
  • .xlsb for Excel spreadsheet files supported on systems with Excel for Windows®
  • .xml for Extensible Markup Language (XML) files

More Answers (1)

Diwakar Diwakar
Diwakar Diwakar on 31 May 2023
May be this code with help you.
% Sample table data
data = {'John', 25, 'USA'; 'Alice', 32, 'Canada'; 'Mike', 28, 'Australia'};
headers = {'Name', 'Age', 'Country'};
T = table(data(:,1), data(:,2), data(:,3), 'VariableNames', headers);
% Export as Excel file
excelFile = 'table_data.xlsx';
writetable(T, excelFile, 'Sheet', 'Sheet1');
% Export as CSV file
csvFile = 'table_data.csv';
writetable(T, csvFile);

Community Treasure Hunt

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

Start Hunting!