5 Methods To Get Data From Google Sheets with Excel VBA

In this video we review five different methods to import data from Google Sheets using Excel VBA. One way or another, there is always a HTTP request to the Google web resource that connects with the Google spreadsheet. The main difference between the various methods presented here lies on the Google web resource/API URL used to access the data. Another important difference is the format of the output data. Some methods allow to get only public data, while other may also let import private or restricted data.

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:

[EvJahvan]

Awesome, very useful. Thanks for sharing Sir.

[SuvajitDasSvjt]

Sir, unable to use the Google Script Api ( 5th Method). Please make a dedicate video on the 5th method.

[fabianovazdasilva]

\o/ I love this video. I will create a licence validation with one of these metods. Thanks a lot!

[Bnet-gvdm]

how to upload data from vba to google drive sir.

[SuvajitDasSvjt]

Getting Error "Script function not found: doGet" in 5th Method while sending request from excel vba.