cswwrite not in one column

Hello I would like to export a matrix I created myself as a csv file. I would like to open this file later with Excel.

When I use csvwrite all entries are in one field. How do I get each value to have its own field?

a = [1 2 4]
csvwrite('abcd.csv',a)

This is what it looks like so far:

this is how it should look:

Best regards

Fabian

Answer 1

[Rik]

This issue is an Excel issue, not a Matlab one.

You need to use the 'convert data to columns' option in Excel.

You might try to write a tab separated file instead, which is more often detected correctly by Excel.

a = [1 2 4];
writematrix(a,'abcd.csv','Delimiter','tab')
%technically you should use .tsv instead, but hardly anyone does that