ANY2CSV

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

Description

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.

• MATLAB release: MATLAB 7.4 (R2007a)
• Other requirements: Opening the csv-file after creation only works on os x and windows.

[Urs (us) Schwarz]

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

[Felix Zörgiebel]

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

[Puifai S]

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

[Felix Zoergiebel]

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.

[Steffen]

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.

[Joachim]

Very usefull work ( see comment from Steffen).

[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.

[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?

[Oren Schaedel]

Thanks, very useful

[Kshitij Gupta]

very useful