How to skip a column to be extracted using easy import.

Mishu
Tera Expert

How to skip a column to be extracted using easy import.

 

The column should be visible in list view but when one is trying to create an excel template to import data , the excel should not contain State field.

 

 

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Mishu 

 

It is not possible. If you import the excel template then all fields will come. You can delete in excel after download.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Shamma Negi
Kilo Sage
Kilo Sage

Hi,

 

Please follow this:

 

You shouldn't remove the column from list view however when you create an excel template to import data to ServiceNow and remove the column you dont need in the template like I did. I created the template and removed the state field. You can decide what all column you need in the excel template.The one you dont need remove it from the template. Please find attached the template I used for incident table

 

my Incident List view

 

ShammaNegi_0-1701947537652.png

 

 

 

My Imported record:

 

ShammaNegi_1-1701947556214.png

 

I hope this article helpful. Please mark it as helpful and bookmark if you like it.

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.

 

 

 

Regards,Shamma Negi

AshishKM
Kilo Patron
Kilo Patron

Hi @Mishu , 

 

Refer the below thread for similar requirement along with other options suggested by @Dr Atul G- LNG @Shamma Negi,    

 

https://www.servicenow.com/community/now-platform-forum/restrict-export-of-single-column/m-p/1073928

 

-Thanks,

AshishKMishra


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution