Sync Google Sheets

[Ralph Messer]

What's the best way to sync Google sheets with Excel without using an addon?

I've watched several videos and I get an error  with getting data on Excel 2010.

Thanks,

Ralph

[Ian Crew]

My first thought is that Sheets has the ability to open .xlsx files, so maybe it’s easiest to just use Drive for Desktop, store the Excel files in Drive, and open them in Sheets when necessary? No scripting or plugins needed in that case. 

--

Ian Crew

Architect, Communication and Collaboration Services
Productivity & Collaboration Services
Berkeley IT

University of California, Berkeley

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/79ec3a0a-47c1-426a-a838-6838705baf7bn%40googlegroups.com.

[Brent Guttmann]

Here is a script that will sync an excel file stored on google drive to sheets. You will need to grab the script from the script editor.

https://docs.google.com/spreadsheets/d/1XEIsLARXeM9ltEKHr-gLeC67oG7R8x-IBh25r17vjPM

Technically though, this would be much easier to do by syncing the google sheet to an excel file stored locally. Could install google drive desktop, then use power pivot to import the data and refresh it on an interval, or workbook open, etc. There is also probably some kind of connector that can be used either by excel or sheets to connect to one another -- haven't had a need to do it so I am not sure but the script in the google sheet linked above seemed to accomplish what you were asking for so at a minimum would be a start.