What is the first step in the process to import spreadsheet data into ServiceNow?

[sandeepgujj]

What is the first step in the process to import spreadsheet data into ServiceNow?

A. Select Import Set
B. Run Data Scrubber
C. Define Data Source
D. Create import Set Most Voted
E. Set Coalesce

[Rajesh Chopade1 · Accepted solution]

hi @sandeepgujj 

C. Define Data Source

This step involves specifying the data source, such as an Excel file, CSV file, or other data sources, before importing it into ServiceNow. After defining the data source, you can then create an import set, map the data fields, and apply coalescing rules as needed.

I hope my answer helps you to resolve your issue, if yes please mark my answer helpful and correct.

thank you

Rajesh

[sandeepgujj]

can you help with the answer why option D

[Dr Atul G- LNG]

Hi @sandeepgujj 

The answer is D.

However, if you are an experienced developer, you would start with C – Data Source, which involves data loading and provides the option to create or use existing import sets. Did you check the CSA ebook? It's the best source of truth. Be sure to verify the information in the labs as well.

[Shivalika]

Hello @sandeepgujj 

Option D ) Create Import Set. 

1)Why because, there might be import set is not existing - eliminated A

2)Data scrubber is out of context - eliminated B

3)Data source definition is not needed - when you already have the import set soreadsheet with you - data source is automatically created when you choose "Load Data -> select existing import set table -> submit -> AT THIS JUNCTION there is already a data source with this attachment -> of course transform then". 

When do you need data source ? - its needed when you don't have data, but you will be importing it from somewhere - in an automated process. 

But here, you have spreadsheet handy and it will be created automatically. You can check this out with any random excel sheet and import set table, you will be able to see as i said above. 

4)Set Coalesce is a step in transform map - but definitely not first step

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[sibayan_chakrab]

Already known spreadsheet, so why do we need to select Data Source? Create Import Set seems to be logical here.