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.
.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
As part of metdata Microsoft uses Open XML contents for the file but Google Sheets share metadata pointing back to Google's ecosystem like drive, etc. My guess is at the core since these two files are not exactly same, hence the behaviour. For proper analysis, I suggest you to raise a Suport ticket for the plugin understanding.
I see this Appian discussion forum is a great space where users ask specific technical questions, share troubleshooting tips, and help each other improve real-time solutions. The collaborative problem-solving here reminds me of academic peer review — where getting expert insight can significantly improve your work. If you’re looking to elevate your research manuscript in a similar way before submission to a high-impact journal, using an ISI journal publication helper can provide targeted feedback, structured formatting help, and publishing strategy — much like a community of experts, but tailored to academic publishing success.