Google Sheets - export to excel

jerryr0125

New Member
Joined
May 14, 2017
Messages
6
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
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Rijnsent

Well-known Member
Joined
Oct 17, 2005
Messages
1,300
Office Version
  1. 365
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,129,557
Messages
5,637,040
Members
416,955
Latest member
Gohar hussain

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top