Formatting issue with Excel import

Darren22 · ‎10-15-2019

Good evening,

I am pulling my hair out about this one. I have been asked to update a bulk load of mobile phones from an excel spreadsheet. I have completed imports many times before so its a simple task. We currently record the IMEI against the asset tag which is about 15 character long.

So when I do the import the asset tag is coming out as 1,000,000,000 for every single one. So I check the formatting on the excel spreadsheet and its currently formatting as a number due to it being over 11 characters. I try and change the formatting to general but the field then changes to 338+14e which is a common Excel error.

So can I ask what format does the cell have to be in for ServiceNow to accept it. Has anyone every come up with this before.

Its annoying

Here are some images

Nithish1 · ‎10-15-2019

Hi,

Can you make sure the field type of the import set field is the same as the target field? If not, make the field type the same as target and you can run the cleanup utility (System Import Sets\Import Set Tables\Cleanup) to delete all the data in the import set table, change the field type, and then re-import the data.

Regards,

Nithish

View solution in original post

Frank Eck · ‎10-15-2019

Why you not format it as text? Also try exporting as CSV or plain text from Excel first, this sometimes solves a similar issue I encountered.