How to to import data from an excel sheet having multiple tabs into multiple tables in ServiceNow?

Sue16
Kilo Contributor

I have an excel sheet with multiple tabs/sheets that contain test cases. I need to import the excel sheet into ServiceNow such that a Test Plan gets created and test cases present inside the excel sheet get inserted into the tm_test_case_instance table (in the related list of Test Plan). I need to import such that few fields like "Test Steps", "Expected Results", "Status" should be created inside the related list "Test" table and the remaining fields of that excel into the parent "Test Case" table. All the test cases present inside one excel file should be inserted in a single "Test Plan".

So, I need to import data from an excel sheet having multiple tabs into multiple tables in ServiceNow (Tables are --> Test Plan (Parent), Test Case (in the related list of TestPlan), Test (which is Test Steps in the related list of Test Case).

If anyone can provide the approach/ Link on how to proceed with this requirement, will be helpful.

5 REPLIES 5

Could you guys provide me the whole solution? It'll be very helpful