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.

Hi ​@rob_devitt 
Has your question been answered? 

Hi ​@rob_devitt,

I just saw this post where the user is creating a CSV file.

I think it might help with your solution.

Hi ​@SimonMuntz I don’t understand how they use the string variable to create the file. That’s the missing piece for me. I can create a comma severated string but can’t do anything usefull with it. 

​@SimonMuntz that’s what i was thinking, the link above made it seem like he was doing it in Nintex somehow. I’ll check out some online apis.