I am trying to use Nintex to generate an excel export of a list. I am able to get the data through webservice and generate in CSV format.But i would like to get in excel and if i do as list attachment as excel , i am getting all the data in first column. Any help on this will be appreciated.Thank You.
Could you share the workflow to take a look at this?
Did you try the Data\Text to Columns option to split the imported CSV? Or using the Data\From Text.
Also it may help to add the delimiter/separator character on the first line of your csv file, as described in the following post (out of several btw): https://stackoverflow.com/questions/17953679/how-to-correctly-display-csv-files-within-excel-2013