Create a new record per column in excel when doing import

[gunishi]

Hi there, 

I have a requirement where excel is structured:

A, B, C, D, E

A_value, B_value etc

I need to create a new record per column and then depending on the column name populate another. For example if the column name is A, I need to populate my other field on the record with 1. Is there a simple way to do this?

Many thanks, 

G

[Slava Savitsky]

The easiest way to get data into ServiceNow is to use Import Sets. In the Transform Map, you can define the logic for populating the fields in the target table (either via a simple field mapping or via scripting). A prerequisite for using this approach, however, is that your Excel should have one entry per row, not per column. So the best option, in my opinion, would be to transpose your Excel spreadsheet before feeding it to ServiceNow.