cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
raj_kamal01
Nintex Newbie

Export Nintex form data to MS excel or CSV

Jump to solution

Hi everyone,

I have requirement where i have fixed set of questionnaire created using Nintex form. What i need is to export the complete dump once user submits the form. Number of questions is fixed to 100.

Please note: I am not looking to connect each and every field in Nintex form to a SharePoint list > and export it to excel. This will require large number of list columns and will complicate the things.

My form format is something like below:

QuestionSelect Yes / NoComment
Sample question 1Choose Yes/NoEnter your comment
Sample question 2Choose Yes/NoEnter your comment

Once form is submitted with all 100 questions answered, i wish to save the form data into excel or csv like:

Sample question 1,Yes,Comment 1

Sample question 2,No,Comment 2

...

Please suggest an appropriate solution if i am not thinking in the right direction.

Thank you in advance.

export to csv‌

Labels: (2)
0 Kudos
Reply
2 Replies
Community Manager Community Manager
Community Manager

Re: Export Nintex form data to MS excel or CSV

Jump to solution

You have to options for this.

 

1. You can use a Nintex site workflow to query the list, pull the information into a few collections and design an excel output using Nintex DocGen. This is clean and allows you control over the layout and design. 

 

2. You can simply export the SharePoint list to excel which is a standard for SharePoint and do whatever you want with the data and format from there. 

0 Kudos
Reply
janeaeck
Nintex Newbie

Re: Export Nintex form data to MS excel or CSV

Jump to solution

I have a form with ~ 30 fields.  I have all the fields on the form connected to a field.  When I export to excel I do not get all the information i have input in each field. I made sure all the columns are selected to show.  I have noticed that even though I "apply" show all columns the next time I go back in they are no longer selected.    How can i get all of my data to come out in excel export ? 

0 Kudos
Reply