data upload into multiple tabes through multiple tabs in excel

[siva58]

hii,

I am trying to upload  data into multiple tables in service now from  multiple TABs in  Excel sheet. is it possible in servicenow?

--> if it is possible, may i know the process.

[Community Alums]

Hi Siva,

While loading/Uploading/Importing the data into Service-now 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 just amend the "work sheet number" and keep all the data in a single work book.

Next, you will need to create one source table and two/three transform maps.

You can also refer to this links for your help :

Parse Excel (xlsx) file.. with ease!

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

[siva58]

Hi @Sandeep Dutta ,

my requirement is Excel templete contains different tabs. each tab data uploaded to the table.

ex: in Excel tab1--> Table1,

tab2---> table .. etc....  

[Ankur Bawiskar]

Hi Siva,

parse the excel file and perform the transformation

Parse Excel (xlsx) file.. with ease!

regards
Ankur

[siva58]

link was not working..