Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Omender Singh
Tera Guru

Hello, Servicenow Ninjas,

I am back with one more interesting topic i.e. Parsing excel in ServiceNow. I am sure there are multiple ways but I am sharing a non-complex and easy one.

 My Requirement -

 Parse an excel which is submitted by a user (so the user submits an excel and I have to parse it and use the content of excel for analysis etc.)

 My Solution -

Load excel into the import set table and read it from there.

 

All this process is demonstrated in the video Click Here

 

I hope you like the video and share it with your friends and colleagues who are facing excel nightmares 🙂

 

See you soon with something new.

 

- O P Singh

 

All the scripts are attached.

Mark Helpful if it helped.

Version history
Last update:
‎04-03-2022 10:48 AM
Updated by: