workaround for custom table creation

[sai bharath kas]

There is data in an xl sheet containing branch information. Currently, the support team is manually entering this data by referring to the Excel sheet. The business wants to automate this process. What is the best solution without creating a custom table and feeding the data into the table.

[Aditya_hublikar]

Hello @sai bharath kas ,

If there is existing table in servicenow instance , you can import your excel sheet data from excel sheet to table using import set .

Refer this thread :

https://www.servicenow.com/community/community-resources/understanding-import-sets-in-servicenow-ste...

If you want to fetch data from excel sheet at particular time/day  without using import set you can refer this thread :

https://www.servicenow.com/community/itsm-forum/interview-scenario-servicenow-itsm-integration/td-p/...

If this helps you then mark it as helpful and accept as solution.

Regards,

Aditya

https://youtu.be/2RIFXWExERw?si=m1ZjWrFuDsUiTqfh

[yashkamde]

Hello @sai bharath kas ,

You can use the Import Set feature with a scheduled data source pointing to the Excel file. Then, define a transform map to push the data into the existing table.

This is a standard, ootb way to automate Excel ingestion without building custom tables.

If my response helped mark as helpful and accept the solution.

[Tanushree Maiti]

Hi @sai bharath kas 

Using Data source -> Transform map -> you can load the data. Schedule it (may b monthly) to automate it. Make sure you are attaching the latest excel in the data source before the job run.

refer: Administration: Importing & Transforming of External Data || Knowledge & Troubleshooting Resources

Check  these option as well:

Automate Data import from Excel File Attachment via Catalog item & Import Sets

Episode 17 - Import data through multiple excels and using flow designer