Import Excel to Database Plugin returns null for files created/edited in Google Sheets

Certified Associate Developer

I am using the Import Excel to Database plugin along with a Connected System to download Excel files from a client’s Google Drive.

Here is the behavior I am observing:

  • When the Excel file is created using Microsoft Excel, the file is downloaded successfully via the Connected System, and the plugin works as expected. All the data present in the Excel file is imported correctly.

  • However, when the Excel file is created in Google Sheets, or when an existing Excel file is opened/edited and saved using Google Sheets, the file is still downloaded successfully, and I can see the complete data in the file. But in this case, the Import Excel to Database plugin treats the file as null and does not return any data.

  • In both cases, the file extension is .xlsx.

Is this a known limitation of the Import Excel to Database plugin when handling .xlsx files generated or modified by Google Sheets? If so, is there any workaround or recommended approach to handle Excel files coming from Google Sheets?

Any guidance or suggestions would be greatly appreciated.

 

The imported file is updated in Google Sheet.

The imported file updated in MS Excel 

Process Model -- 

  Discussion posts and replies are publicly visible