How do I create cases from an import file?

[jrusso]

We recently added a catalog item and HR Service.  However, the team managing this process had been collecting request data and tracking in Excel.  They would like to create HR Cases from their excel file so that last year's requests can be included in ServiceNow and they can report on all cases from ServiceNow. 

We would like to import the case details with a State of Closed Complete, as these are have all been addressed.  I don't believe Bulk Case creation would work in this situation.  We do not want these newly added closed cases to generate any emails to the employee since the case is already closed.

Is there a defined process for doing something like this? 

[AshishKM]

You must know some ETL process, In ServiceNow, it's same to load data in bulk via stage table including do some data transformation ( apply some logic ) and add/update the target table.

Try the below link from developer portal for Data Load tutorial

https://developer.servicenow.com/dev.do#!/learn/learning-plans/rome/servicenow_administrator/app_store_learnv2_importingdata_rome_importing_data_objectives

User below link for all foundation video

https://community.servicenow.com/community?id=community_article&sys_id=a2dc2a65dbd0dbc01dcaf3231f96197e&anchor=comment_508da4abdbc54194f77799ead396197a

-Thanks

Ashish

Please mark correct answer and helpful if it helps you