Error loading Excel Data Source: Unable to load headers from the XLSX data source Issue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } An error occurs when attempting to load an Excel file (XLSX format) as a Data Source in ServiceNow, resulting in the failure to load headers. Symptoms<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Error message: 'com.glide.db.impex.datasource.DataSourceException: Unable to load headers from the XLSX data source'Non-working file lacks 'xl/sharedStrings.xml' in its archive structureFile size discrepancy between working and non-working files (e.g., 31,960 KB vs. 30,944 KB)The non-working Excel file fails to load headers during import, despite being readable in Microsoft Excel.If copying data from the non-working file into a new Excel file, which then loads successfully. Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } All Cause<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } The non-working Excel file lacks the 'xl/sharedStrings.xml' component in its XLSX archive, leading to parsing failures in import process. This file is required for proper header loading, even though the file opens normally in Excel. Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } --> "Verify the XLSX file structure contains the required 'xl/sharedStrings.xml' component. Not Working: unzip <excel file>.xlsxArchive: <excel file>.xlsxinflating: xl/workbook.xmlextracting: _rels/.relsinflating: xl/styles.xmlinflating: xl/_rels/workbook.xml.relsinflating: docProps/core.xmlinflating: docProps/app.xmlinflating: xl/worksheets/sheet1.xmlinflating: [Content_Types].xmlWorking:unzip <excel file>.xlsxArchive: <excel file>.xlsxinflating: [Content_Types].xmlinflating: _rels/.relsinflating: xl/workbook.xmlinflating: xl/_rels/workbook.xml.relsinflating: xl/worksheets/sheet1.xmlinflating: xl/theme/theme1.xmlinflating: xl/styles.xmlinflating: xl/sharedStrings.xmlinflating: docProps/core.xmlinflating: docProps/app.xml --> Non-working files missing this component "xl/sharedStrings.xml" will fail import." 1. Workaround: - Temporarily recreate the file by copying data from the original file into a new empty Excel workbook. - Use the new file for import, as it should regenerate the required XLSX structure (including xl/sharedStrings.xml). 2. Recommendation: - Customer need to work with the file provider/owner to generate XLSX files that include xl/sharedStrings.xml - If there are any issues with XLSX file being generated with xl/sharedStrings.xml, then consider transitioning to CSV format for data ingestion, as CSV files would avoid XML-related parsing constraints observed in XLSX files."