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.

6 Likes

Hello @Drearystate . I am working on a project where I try to use the script. It’s going super good.
But it does not help me to get the information correctly on the google sheet.
can something similar be done to import tab delimited text?
Thank you very much
Dario

I found an alternative solution, since I don’t have so many lines to update per month.

Good to hear, srry I didn’t respond to original post…honestly did not see it.

No problem. anyway thank you very much.
I ask you a question in case you have ever done it, the reverse process? update an excel file from google sheets?
regards