Importing Data

[David_C]

I just started using ServiceNow and am going through tutorials. In the tutorial that shows how to import data from the Create App option, I followed along and it worked perfectly. In fact, I did this a number of times taking the data from an Excel spreadsheet. Then, I decided to download data again into Excel but this time I had additional fields that I wanted added. However, this time I am getting an error "Cannot read properties of undefined (reading 'name') Unable to import data into new table." If I import only the Field Headers from line one of the Excel spreadsheets, it works, so it appears to be something with the data. Also, if I revert back to the original spreadsheet that worked for me several times, it now also gives the same error message. I tried researching this on Google but I'm too new to this to understand what the system is telling me. Any help would be appreciated.

[Mwatkins]

@David_C I see this is an old post so maybe you've already moved on, but in case anyone else comes across this, the likely cause here is a defect whereby any special character in the column heading names of the spreadsheet will cause the import to break the during the column mapping phase. It doesn't find the column name that was skipped, thus throwing the error, "Cannot read properties of undefined (reading 'name') Unable to import data into new table."

According to the documentation that I found, this is fixed in Xanadu Patch 3 with App engine Studio version 26.2.10.

Until you are on that version, you can fix this by removing the special characters (including underbars and non-western characters) from the column names.

I found that the following characters are some examples that cause this issue:

_

á

ç

ã

Please ✅ Correct if this solves your issue and/or 👍 if Helpful

"Simplicity does not precede complexity, but follows it" - Alan Perlis