Automatically import data into excel from Google sheets

I use the importrange feature to import data from one Google sheet workbook to another. Does anybody know if it's possible to import and populate a cell from a Google sheet workbook cell into an excel cell using import external data feature or something like the Google sheets importrange feature?

2 Answers

If your Excel files are in your computer, seems the Rajesh S answer is the best. But if your files are on the cloud, you can use add-ons for Google Sheets to create this "live stream" from the Google Sheets to Excel files, even if the files are closed.

You can use the following VBA code to import Google Sheet into Excel.

Sub importGSheet() With ActiveSheet.QueryTables.Add("URL;", Destination:=Range("$A$1")) .WebTables = "2" .Refresh False End With
End Sub

Hope this help you.