How to import contracts using excel

[Suma16]

hi, is there a direct way to import data from excel to ServiceNow for contracts. my objective is to create a new record using the data in excel.

I need to add two more fields to the form as well.

attaching the sample data.

can anyone suggest what would be the best approach to complete my work. ?

Thanks!

[Kaka Nayeem]

Hi Dhanalakshmi,

            You can acheive your requirement by using import set

            Load data by using import set.

Thanks,

Kaka Nayeem

PS: Hit like, Helpful or Correct depending on the impact of the response

[Deepa Srivastav]

You can go to the list view where you want to upload and right click near header and select import->excel option. Column name and header in excel should be same.

http://wiki.servicenow.com/index.php?title=Easy_Import#gsc.tab=0

Mark Correct if it solved your issue or hit Like and Helpful if you find my response worthy.

[Suma16]

the given url helped but couple of fields are drop down fields. those fields are not getting updated in a record. how can I achieve this?

[ITSMgal]

Sometimes drop down fields have different display values than data values. you will need to check that the values match the value stored in the record, not the display value. For a dropdown, you can select "Show Choice List" to see the values for the Label and Value.