DSXchange

Hi,

I'm trying to write output data to a spreadsheet as a .csv file using Sequential File stage. When I view the output spreadsheet, I see that the entire row is in the first cell.

But I want it to be written in such a way that each column is in each cell of the spreadsheet. Please let me know what is the way or settings to get this.

Thanks.

If you are writing a true 'csv' as in a 'comma separated value' file with a .csv extension, then Excel should load it up properly. What does the file look like when you open it in Notepad?

What "Delimiter" are you using while creating the csv file in the sequential stage?

Try avoiding Quote characters like single or double ', " if you have any. As noted, if its written properly, it can be easily opened in Excel, despite that, you can open the file specifying the respective column details.

Unless, of course, the delimiter character appears in data - in that case you DO need quoted character strings.

Thanks for all your comments. I was able to solve it.

I gave the Demiliter to be a 'tab' and the Quote character to be nothing. I got the output as needed; as each column written in each cell.

Still wondering why comma didn't worked for you.