Skip to main content
Nintex Community Menu Bar
Question

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


Forum|alt.badge.img+1

Is there a way to either generate a csv file in Nintex Workflow or convert an excel file or anything that can be done. I would like ot use Nintex to generate and email a csv file on a schedule. 

Translate
Did this topic help you find an answer to your question?

3 replies

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2436 replies
  • March 7, 2025

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.

 

Translate

Forum|alt.badge.img+1
  • Rookie
  • 4 replies
  • March 10, 2025

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? 

Translate

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2436 replies
  • March 10, 2025

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.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings