So, I’ve been hearing lots of people asking for an Excel integration. Now I’ve been aware of this trick for many years now, and I thought I’d share.
Step one: Go to your google drive
Step two: Download your Excel sheet in whatever format you desire
Step three: Click the ‘new’ button
Step four: click upload file
Step five: Preview it and select ‘open in Google Sheets’
Step six: Connect to Glide!
Et Voila!

Note that things like text boxes will not appear in Google Sheets…

You forgot…

Step 7: BIN the Excel file

Apart from the fact that you don’t want that rubbish polluting your GDrive, it counts against your storage quota. Whereas native GSheets do not.



If you don’t want to hassle with having to do this all the time but you cannot help that you get excel files to use.well then use a script to do the work for you.

function importCSVFromGoogleDrive() {
var file = DriveApp.getFilesByName("APPOINTMENTS.csv").next();
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
var sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);

Just set it for a timer to get the file and convert it into your sheets. Keep in mind this is for any .csv file including excel .csv files.