Import data from multiple tabs/sheets of excel to multiple Service Now tables

[astha_chaubey]

Hi All,

I have a requirement where I need to automate Service Now's import process. We have to import data from an excel sheet containing multiple tabs, holding data for different tables. All this data needs to be imported in respective tables of ServiceNow, in one go. Possibly we will have a UI Action on our custom table's form view to import this excel sheet.

Please revert on this post if anyone has any idea about this one.

Thanks & Regards,

Astha Chaubey

[Mujtaba Amin Bh]

When loading the data into ServiceNow as a Data Source in "System import sets > Load Data". You can select "Upload an Excel file" and this give you the option to specify the "work sheet number" and the "header row number".

So you can create different data sources and mention the worksheet numbers accordingly.

[astha_chaubey]

Hi Mujtaba,

Thanks for your response. Creating multiple data sources will limit our solution as well as increase number of manual processes, as we want our functionality to be available to multiple tables (>20). This is not something that we are looking for currently.

Thanks & Regards,

Astha Chaubey

[Alikutty A]

Hi,

I suggest you create a record producer and automate your data loads. You can access the data load and transform APIs to load any number of sheets via scripting.

Refer https://www.servicenowguru.com/system-definition/imports/simplifying-data-imports-parties/   for more information.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[astha_chaubey]

Hi Alikutty,

I will try to implement this solution and get back to you. Thanks for a quick response!

Thanks & Regards,

Astha Chaubey