Regarding Devlopment some REQ

kothasahit
Tera Contributor

I fill out a lot of timesheets and i would like to simply the process if possible by having an excel format i can populate and then upload into servicenow. Can you we do this

5 REPLIES 5

Rohit  Singh
Mega Sage

Hi @kothasahit ,

 

Yes, you can upload records in ServiceNow table from Data source as excel using import set and transform map.

 

If my response helped, please mark it helpful and accept the solution so that it benefits future readers.

 

Regards,
Rohit

Can we do it in any other way because the task is - there is a UI button whenever i click that button i should be able to retrive from the data set

SupriyaWaghmode
Kilo Sage

Hi , 

1. To import data into the system, follow these steps:

- Navigate to system import sets and click on "load data."

- Upload the Excel sheet containing the data.

 

2. After the data is uploaded, the "Create transform map" option will appear if there is no existing transform map in the instance. Here, you can:

- Select the target table.

- Map the columns in the Excel sheet to the fields on the target table.

 

3. Once the mapping is complete, click on "transform now" to initiate the transformation process.

 

For a detailed understanding of this process, you can find more information .

 

https://www.servicenow.com/docs/bundle/xanadu-integrate-applications/page/script/server-scripting/co...

 

 

Thanks & Regards ,

Supriya Waghmode |ServiceNow Consultant