Import data from multiple tabs/sheets in Excel

[Anjan 2025]

Hi,
I have a use case where I need to import data from an Excel file into a custom TEST table in ServiceNow. The table has the following fields:

• type
• code
• category
• subcategory
• description

My Excel file contains three sheets/tab:

• TEST_one
• TEST_two
• TEST_three

Each sheet contains relevant codes and descriptions. I’ve created a single Data Source using this Excel file and want to import all data into the code table using one import set table and one Transform Map.

✅ Requirement:

I want to set the type field in the target table dynamically based on the sheet name:

• If the data is from TEST_one, set type = "task"
• If from TEST_two, set type = "incident"
• If from TEST_three, set type = "problem"
  Below is the sample file snap,
  

  How can i set "type" field based on sheet name and also how can i process three sheets in single data source

[Dr Atul G- LNG]

Hi @Anjan 2025 

https://www.servicenow.com/community/developer-forum/import-data-from-multiple-tabs-sheets-of-excel-...

[Bhuvan]

@Anjan 2025 

Follow this post to load data from multiple tabs in an excel to target tables,

https://www.servicenow.com/community/developer-forum/parse-excel-xlsx-file-with-ease/m-p/2017439

You can also use same excel to load data to multiple target tables using Robust Transform Maps, see if it helps,

https://www.servicenow.com/docs/bundle/zurich-integrate-applications/page/administer/import-sets/con...

If this helped to answer your query, please accept the solution and close the thread.

Thanks,

Bhuvan

[Bhuvan]

@Anjan 2025 

Thanks for marking the post as helpful.

If my response helped to guide or answer your query, please accept the solution.

Thanks,

Bhuvan

[Ankur Bawiskar · Accepted solution]

@Anjan 2025 

Why to make it complex by having 3 sheets?

Do this

1) ask user to have data into single sheet and add column for Type and ask user to enter the Type as either task, Incident or Problem

2) then your job is easy and you can directly map the fields with target

If my response helped please mark it correct and close the thread so that it benefits future readers.