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