2D Array witing to spreadsheet file is making all columns go into one column of the excel file.

[govindsankar]

Hi, 

I am writing a program to insert the columns of a 2D array into Excel by wiring it to write it to a spreadsheet file and then giving the path to a .csv file. Rest, everything is default. Then I run the program and all the columns of the 2d array are coming in one column of the Excel sheet. How do I separate it into multiple columns. Thank you. 

Govind

[Yamaeda]

I guess you're using the wrong separator. If you use Write Delimited file it'll default to Tab as separator, where as a .csv wants comma. So either save it as .txt or use Array to Spreadsheet string with comma as separator and a 'pure' Write to text file.

You can do a Text to columns in Excel to split it as it is now.