Error loading XLSX file from Google Drive because "not a valid OOXML" - Google Drive Plugin

jjc_al Registered Posts: 5 ✭✭✭


I am using the Google Drive Plugin (version 1.1.4) with which I'd like to load an .xlsx file from a Google Drive using a service account. However, I get the following error:

"Failed to open Excel file, caused by: NotOfficeXmlFileException: No valid entries or contents found, this is not a valid OOXML (Office Open XML) file, caused by: ZipException: Unexpected record signature: 0XB863D080".

For information, I have checked the XLSX format box in Settings, and the preview displays the table as intended. I have attached screenshots of the error and the Format/Preview settings tab.

Thanks in advance for your help,


Operating system used: Linux

Operating system used: Linux


  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,708 Neuron

    Are you sure your file is an actual .xlsx format file and not a .xls file? If it is an actual .xlsx format file you should be able to change the extension to .zip and unzip it's contents.

  • jjc_al
    jjc_al Registered Posts: 5 ✭✭✭

    Hi Turribeach,

    Thanks for your quick reply. The extension of the file is .xlsx, and when I uncheck the "XLSX format" box, the following error is raised:

    "Tried format excel but configuration is not OK: Failed to open Excel file, caused by: OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF)".

Setup Info
      Help me…