Automatically import data into excel from Google sheets

Question

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?

Answer 1

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.

Answer 2

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

Sub importGSheet()
    With ActiveSheet.QueryTables.Add("URL;https://docs.google.com/spreadsheet/ccc?key=0Ah4Bis8FTYfCdDJILVdYOG1EZEYtc1N3NF96dHZSYkE&usp=sharing#gid=0", Destination:=Range("$A$1"))
        .WebTables = "2"
        .Refresh False
    End With

End Sub

Hope this help you.