How to overcome the error "data contains 2 columns, expected 1 " while importing ?

snow57
Tera Contributor

‎02-16-2024 12:03 PM

Hi Team,

 

I am working on the "inbound email action" - as part of it i have to import the data from CSV attached in the email. and in that CSV from 6 th row we have to accept the data and import it to ServiceNow. After importing i am facing the above error . Please help me on how to resolve this .

Note: validated the CSV format and its looks good .

 

Thanks,

Sano.

0 Helpfuls
  • 750 Views
2 REPLIES 2

The Machine
Kilo Sage

‎02-16-2024 12:11 PM

its been a while since I ran into this issue, and I believe it was due to me having a column in my CSV that wasn't present in my Import Set / Transform Map.  Once I removed the column from my CSV it worked as expected.

Hopefully that helps.

0 Helpfuls

Louise VA
Tera Contributor

‎02-16-2024 02:17 PM

I have come across this issue when the csv is encoded in UTF-16 with BOM format. You can see whether this is the case by opening it in Notepad++ - You want it to say UTF-8 in the bottom right corner. If it says something else then that's likely your issue. 

lvanalstyne22_0-1708121840337.png

 

 

More here: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0819755

 

Is this a file being generated by another application? 

0 Helpfuls