Google Sheets - export to excel

[jerryr0125]

Hi -
Does anyone know of a macro,etc... that would automatically export data from a google sheet into an excel sheet on a google drive ?
Both files would be on the google drive. I would like to have a macro that would on a timely period (say once a day) export the data in a google sheet into an excel sheet.
Thoughts ? Jerry

 

[Rijnsent]

Hi Jerry,
with google sheets you can set up triggers to run a code. Those triggers can be time-sensitive (like daily between 0h and 1h). Having said that, you'd need to dive into Javascript, as that's the language you'd need to program in Google sheets. This bit can get you started: How to convert a Google Docs-File to an Excel-File (XLSX) And if you want to dive into google script: Desktop Liberation has all you need.
Personally, I'm using google script e.g. to scrape data, calling an API and saving that data daily in a directory on my google drive. That works like a charm and it will keep on running versus excel where you'd have to open the file to get the code running.
Cheers,
Koen