manually Load data from into desired table

[ChetanSh]

I want to load the data into Servicenow instance.
I have a target table in which i want to load data from the excel sheet that i have received.

[VedS · Accepted solution]

Hello @ChetanSh ,

• 1. In the Navigation menu type Load data and click on it.
  2. You can either select an existing table if you have already created or create a new one.
  3.Choose the File that you want to upload and click submit.
  4. You will need to create a transform map if you have not already created one. So click Create transform map.
  5. Give a proper name to it select the target table the source table will be already selected.
  6. Save and open the Mapping assist from the related Lists.
  7. You can manually map the source fields with the target fields.
  8. Once the transform map is created you can load the data into the target table.
  For this you will need to run the transform map after creating it.
  https://www.servicenow.com/community/developer-forum/how-to-load-data-to-table-from-excel/m-p/145186...
  you can get more information about transform maps here.
  https://www.servicenow.com/docs/bundle/xanadu-integrate-applications/page/script/server-scripting/co...
  

Please mark this as "correct" and "helpful" if you feel this answer helped you in anyway.

Thanks and Regards,

Ved

[Dr Atul G- LNG]

Hi @ChetanSh 

My video will be 100% helpful.

https://youtu.be/vKIQ1IZDP10

[Dr Atul G- LNG]

A step by step:

https://developer.servicenow.com/dev.do#!/learn/learning-plans/xanadu/servicenow_administrator/app_s...

[Adrian Ubeda]

Hello ChetanSh, 

Check this thread: https://www.servicenow.com/community/developer-forum/how-to-load-data-to-table-from-excel/m-p/145186...

Just ensure that the data provided in excel sheet matches the one in tables and you can upload it easily. Use load data and staging table for doing the mapping properly and should work. If you want to apply some transform logic use transform map for this.