I want to import data to new table by excel file

[sudaporn]

I create new table . and I want to import data (excel file) to Application_SupportTeam Table .it's new table  

Show list in the new table.

Data in excel file. i want to import all data to table

d

[Deepa Srivastav]

Read from section 2.1 of the below:-

Import Sets - ServiceNow Wiki

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

Thanks,
Deepa

[Deepa Srivastav · Accepted solution]

You have to goto Load data--click create new table and give some temporary name...then upload your file in csv or xls format...then click submit...

Your data will be uploaded to a temporary table .Then you have do the mapping...CLick on Mapping assist for that and map your fields correctly and then once done click ..transform data...

Give the Column name as present in SNOW table.

Then Goto Load data.Choose option of create a new table and create a temp table..Then Load file and click on sumbit.

Click on "create Transform Map" .Then choose target table as Application_SupportTeam table and click on automap matching fields or mapping assist (if you don't have same heahders).

After that click on transform below mapping assit ...

Let me know if you face any other issue.

You can check transform history in Transform History of transform is complete.

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

Thanks,
Deepa

[Riya17]

I have a similar requirement with continuation. 

I have done the transform (Source risk data - Target risk data)and now I need to create a task for 'risk support' to take an action.  The excel spreadsheet comes in by an email on a daily basis.  Depending on the severity of the risk(high, medium, low), the task is allocated to level 1, level 2, level 3 support.  How can I proceed?

Thanks

[Deepa Srivastav]

Alternative way is there but for that Field names in excel should match with the table....

Go to the table(in list view) where you want to add records. Rt-click on any of the fields and select "import" as shown below.

Then click "insert" and attach your excel file(in xls or csv) as shown below and select preview imported data.

The uploaded data will be displayed and if it is as you expected then click 'complete report" else click "back".

Navigate to your table and check for updates.

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

Thanks,
Deepa