File Exchange

image thumbnail

ANY2CSV

version 1.0 (4.38 KB) by

Exports any type of MATLAB data to a nicely formated csv-file

15 Downloads

Updated

View License

Editor's Note: This file was selected as MATLAB Central Pick of the Week

Exports any type of MATLAB data to a nicely formated csv-file, including fieldnames of structs and any multidimensional subscript-indices.
This tool is especially useful if you want to save the content of large structs and cell-arrays to an excel or ods sheet. Any to csv works recursively until all the content of a complicated object is written to a csv-spreadsheet and opens it in the standard csv application. There you can save it to e.g. xls or ods.

Comments and Ratings (13)

This does not work with a structure that has nested field names.

MATLAB 2012a, <1305983x3 cell>, sucked all my RAM, I ended up using http://www.mathworks.com/matlabcentral/fileexchange/7601-cell2csv instead

Hugh

Hugh (view profile)

very useful

Thanks, very useful

Larissa

Hi Felix,
Could you please have a look at this thread?
http://www.mathworks.com/matlabcentral/newsreader/view_thread/281952#744609
I am out of memory in 2009b. What could be a reason for that?

sophie neve

very useful !!
but I find the opening of excel annoying
I also got a (little) problem when creating the file, it says :
The system cannot find the file ''pathname''
normal it does not found... has not been created yet....

so.

Joachim

Very usefull work ( see comment from Steffen).

Steffen

Steffen (view profile)

This is a great way to manage the workflow of your data from Matlab to any office-programm like excel or openoffice. It's handy and easy to use.

I am using OpenOffice.org instead of Microsoft Office. OpenOffice.org has a very nice import function for csv files. Once the file is imported you can save as XLS. I know that those functions are available via command-line tools, however I do not remember the names and I have never used them.

Puifai S

Do you know of a way to convert from CSV to XLS quickly?

Felix Zörgiebel

Shame on me, I should have tested that case... Thanks Urs, I corrected the bug. Felix

Urs (us) Schwarz

does NOT work with empty cell entries, eg,
c={'a',[],{}}
us

Updates

- display struct fields horizontally or vertically -> line 128
- display content of cell/struct fields under or right to the subscripts/fieldname -> line 127

Thanks Jiro Doke for those two ideas!

- removed empty struct bug

The empty cell bug is now finally gone.

MATLAB Release
MATLAB 7.4 (R2007a)

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video