Generate a cvs file using document generation or other in Worlflow Cloud

Hi ​@rob_devitt,

Without knowing your exact data source, I can only give you general information.
As a CSV is just strings delimited by commas, you can loop through data and construct the string using create a text string action(s).

There is a Read Excel xtension in the Nintex Gallery that may be helpful.
https://gallery.nintex.com/t/read-excel-file
It returns a JSON string that you could easily turn into a CSV by basically chopping off the curly brackets using a modify string action or a Regular expression action.

Good afternoon ​@SimonMuntz

I am not asking the question, but I would like to add on to this since I have the same problem.

I am getting some data from the SharePoint api after which I turn it into a collection of csv rows (Basically: Title,Description..etc). I tried constructing a string, but I cannot find how to add a new line character so I gave up on that and went on to creating a template file that I can use in a Generate Document action, but that file has to be an .xlsx and it can’t be a csv so I am currently stuck on that.

How can i build the csv file if I can’t add new line characters? 

HI,

Hmmm, Sorry. I forgot about the line breaks. The only other thing I can think of is to create an extension that calls a web service to do the conversion.