How to load data to table from excel

Nana5
Mega Guru

Hi Friends,

How i can upload the data to table from excel.

Thanks

1 ACCEPTED SOLUTION

Rushit Patel2
Tera Guru

Hi   Prakash,



if you dont understand wiki follow below steps. i am assuming that u dont already have transform map for that destination table. if u have then use that



  1. go to system import sets-->load data module
  2. enter table name..chose file(.xls file) make sure 1st row in excel match fields in your destination table.so it will automap.
  3. then click on create transform link
  4. give it a name,select destination table(table in which u want to upload data)
  5. click on auto map matching fields..if required fields do not match then click on mapping assist and match fields.
  6. set colesce true to any one field from related list. it will be your unique field
  7. click transform


Let me know if u face any problems.



(please mark helpful/correct/like if it helps)




Regards,


Rushit Patel


View solution in original post

6 REPLIES 6

Rushit Patel2
Tera Guru

Hi   Prakash,



if you dont understand wiki follow below steps. i am assuming that u dont already have transform map for that destination table. if u have then use that



  1. go to system import sets-->load data module
  2. enter table name..chose file(.xls file) make sure 1st row in excel match fields in your destination table.so it will automap.
  3. then click on create transform link
  4. give it a name,select destination table(table in which u want to upload data)
  5. click on auto map matching fields..if required fields do not match then click on mapping assist and match fields.
  6. set colesce true to any one field from related list. it will be your unique field
  7. click transform


Let me know if u face any problems.



(please mark helpful/correct/like if it helps)




Regards,


Rushit Patel


Hi Rushit,


  Thanks for reply, Let me try. If i will face any issue, i will let u know.



Thanks


Prakash Ranjan


Tanaji Patil
Tera Guru

Hi Prakash,



Easiest way is to use Easy Import. Here you don't even need to manually create transform map. It will take care of transform map on its own for you.



Follow below steps-


1. Download excel template from the list view.


2. Put your data in it.


3. Import the data back.



Please check below link for more information-


Easy Import - ServiceNow Wiki



Thanks,


Tanaji Patil



--Mark correct/helpful if it helps solving your issue.