Getting "Unable to load headers" when doing load data from xlsx

MongGu
Tera Guru

Hello,

 

I was following instructions for Application Development Fundamentals Lab 7.1, which was to import excel data to create table and do mapping. 

 

When loading excel data using "System Import Sets" -> "Load Data", I am keep getting the following error: "com.glide.db.impex.datasource.DataSourceException: Unable to load headers from the XLSX data source" 

 

Header Row is set to 1, I followed exactly the same thing as the provided demo video for the lab but unlike a demo, it is giving me that error. 

 

Does anyone knows why and how to fix this?

 

MongGu_1-1676402587695.png

 

 

MongGu_2-1676402605844.png

 

1 ACCEPTED SOLUTION

MongGu
Tera Guru

Hi All,

 

Found out that the error only happens on the PDIs.

View solution in original post

10 REPLIES 10

Mika Latvala
Tera Contributor

I found out that the problem in my case was the headers - as it says in the error message. I created an empty row below the header row, manualy wrote new headers, deleted the first row with original headers and saved the Excel file. Poof, it worked. We had some scandinavian letters in the headers and it seems ServiceNow doesn't like those at all.

 

So, as a summary:

  • Just use basic characters in your headers
  • Make sure the data is formatted correctly, especially when dates / times are entered