LIFE HACK - Excel to GOOGLE SHEET!

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.

:grin:

2 Likes

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.

5 Likes