Skip to main content
Nintex Community Menu Bar
Solved

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. 

Best answer by SimonMuntz

Hi ​@rob_devitt,

There is nothing out of the box that can create the file.
This means you would need to find a company that provides an API to generate the file or develop and host the API yourself.

 

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

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 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
  • 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
  • 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

MillaZ
Nintex Employee
Forum|alt.badge.img+21
  • Nintex Employee
  • March 17, 2025

Hi ​@rob_devitt 
Has your question been answered? 

Translate

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • March 18, 2025

Hi ​@rob_devitt,

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


I think it might help with your solution.

Translate

Forum|alt.badge.img+1

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. 

Translate

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • March 19, 2025

Hi ​@rob_devitt,

There is nothing out of the box that can create the file.
This means you would need to find a company that provides an API to generate the file or develop and host the API yourself.

 

Translate

Forum|alt.badge.img+1

@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. 

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