0

I know of only one way to import information (live) to Excel from Google Sheets, but it requires "publish to the web" on that Google sheet, and adding a "connection" to Excel.

My concern with this is that there could be sensitive information that anyone who obtains a URL to the published Google sheet can have access to information that should remain private.

Is there another way to connect Google Sheets to Excel? (Or) does one need to scramble the information on the published sheet (a la enigma machine + key) and decrypt it on the Excel side when receiving it?

1

You could use the Google Sheets API, the Google Apps Script Execution API or a third party Excel plug-in.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.