Is there a way we can parse the response from excel and update values in our ServiceNow?

[milan51]

I have an assessment, I am building functionality in which Assignee take their assessment in excel and uploads that excel on the assessment record. After that on click of UI action that responses parse from an excel and update into Servicenow?

[darren_halliday]

Ok.  You can use a Flow to move the attached excel spreadsheet to a ServiceNow Data Source record of Type Excel.   I wrote an article a while back about parsing an incoming CSV file as an email attachment.  The principal should be the same.  Use a Flow to move the spreadsheet to your configured Data Source record as an attachment.  The Data Source should be linked to a standard Transform Map with a linked Import table and your target "Result" table.  Then use a scheduled import job to process the Data Source on your desired frequency.  The example in my article updates a CMDB table with IntegrationHub ETL.  But you could replace this part with a standard Transform Map updating your "Result" table.  If you do this, the whole thing would then be automated and you could load the results on a daily schedule,

https://community.servicenow.com/community?id=community_article&sys_id=785a2410db40499007ab8263059619d7

I hope this helps.

[Mahak2]

Hello,

https://community.servicenow.com/community?id=community_question&sys_id=b7fc0769db9cdbc01dcaf3231f961966

Follow the below steps:

1. Go to system import sets-->load data module
2. enter table name..chose file(.xls file) make sure 1st row in excel match fields in your destination table.so it will automap.
3. then click on create transform link
4. give it a name,select destination table(table in which u want to upload data)
5. click on auto map matching fields..if required fields do not match then click on mapping assist and match fields.
6. set colesce true to any one field from related list. it will be your unique field
7. click transform

Docs:

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/import-sets/concept/c_ImportDataUsingImportSets.html

Please refer below links:

https://www.servicenowelite.com/blog/2019/6/27/import-configuration-items-with-excel-spreadsheets

Please mark my response as helpful and correct as applicable.

Thanks

[Mahak2]

Hello,

Have you tried ?

Thanks