Parse XLSX file in Google Drive

Questions & Answers
1

Greetings,

Is there a way to parse an xlsx file in google drive directly?
outside of making the file public and using an HTTP request?

OR

a way to convert the xlsx file to a google sheet or csv file within Make?

thanks in advance.

2

Hi :wave:t5:

The “Google Drive - Upload a File” can do that for you directly.
Simply select the “convert file” in the “advanced settings” with “google-apps.spreadsheet” file type.

image
image858Ă—624 48.5 KB


The .xlsx file will then automatically be saved as a Google Sheets spreadsheet.

In case you would prefer converting the file to .csv you might try some online file converters supported by Make e.g. CloudConvert.
It can convert the .xlsx file to .csv (or other formats) you can then upload to your Drive.


Cheerio

4 Likes