Can you export multi-row variable sets to excel doc?

[Mitch B]

While I do like the multi-row variable sets being visible on the RITM record there is an additional requirement that has come up from one of the service owners that would help their fulfillment teams to complete their work faster. The service owner would like to export the row/columns from the multi-row variable set into an excel document to make it easier to copy and past certain information. 

Is there an easy way to do this?

I consulted the product documentation in https://docs.servicenow.com/bundle/london-it-service-management/page/product/service-catalog-management/concept/c_ServiceCatalogVariableSets.html however I was not able to find an easy way to do this. Before I go down the rabbit hole of trying to develop a solution for this I wanted to check if anyone else has run into a similar requirement. 

[Ct111]

Hi ,

Inorder to export a long list of records to excel you don't need to work much 

Just use   ?EXCEL at the end of URL

Example  like i want all the incident in excel then I would hit the URL 

https://devxxxx.service-now.com/incident_list.do/?EXCEL

It will directly give me entire list in the same way you can do for variable set

Mark my ANSWER as CORRECT and HELPFUL if it helped

[Alikutty A]

Hi,

You will need to write the logic for extracting row data from variable set. 

Thanks!

[MMKK]

Hi ali,

I have the same requirement. DO you have any link that i can start this through?

[deepak105]

There might be other but you can begin like this.

var jsonString = g_form.getValue('your_multi_row_variable');

now convert that string to json

var jsonData = jsonString.evalJSON();

now you can try with this 

exporting json to excel. follow the link below.

http://jsfiddle.net/hybrid13i/JXrwM/

You may need to use UI page variable in Catalog form.