Automatically import data from Google Sheets to Excel

**samvince** · 05-12-2020, 10:02 AM

Hi is there a way to automatically import data from Google sheets to Excel?

Thanks

**alansidman** · 05-12-2020, 03:29 PM

I would use Power Query to achieve this. Here is a tutorial on the steps to get it into excel

https://www.youtube.com/watch?v=hhfaOZUbrqw

**samvince** · 05-12-2020, 03:47 PM

Hi thanks for this, I've had a look at the method but you have to make the google sheet public, does that mean anyone can see your sheet if they searched for it or only if they had the link.

I'm just a bit worried about the safety of the data if I have to publish the google sheet to web.

Have you had any issues with it?

Thanks

**alansidman** · 05-12-2020, 03:53 PM

I have little experience with Google Sheets. Suggest you post that question in a google forum. But guessing, I am thinking you will need to have the link to access the sheet.

He is suggesting Not Public, but shared link.

Automatically import data from Google Sheets to Excel

LinkBack

Thread Tools

Rate This Thread

Display

Automatically import data from Google Sheets to Excel

Re: Automatically import data from Google Sheets to Excel

Re: Automatically import data from Google Sheets to Excel

Re: Automatically import data from Google Sheets to Excel

Thread Information

Users Browsing this Thread

Similar Threads

Google Sheets File Import Macro

RANK/automatically put my data in highest number order (google sheets)

Batch Data Import to Google Sheets

Google Sheets Import Data

Import data from Google Spreadsheet to Excel

Import function in Google Sheets

Error formatting when import data from google into excel

Bookmarks

Bookmarks

Posting Permissions