Excel Macros in Google Sheets: An Introduction to Google Apps Script

In this video wel see how to create Excel macros in Google Sheets, and more specifically, we compare the two leading spreadsheet applications, side by side, in regards to automation and the creation of macros. It is possible to replicate Excel macros in Google Sheets in many cases, yet there are some limits to achieve everything we do in Excel. On the other hand, macros in Google Sheets allow to easily integrate with other Google APIs and web resources, and can even be taken to another level to create entire web applications. However, the programming language we use to code the macros is quite different altogether. Microsoft Excel uses Visual Basic for Applications (VBA), while Google Sheets uses Google Apps Script. This post will help you leverage your Excel VBA knowledge to quickly get up to speed with creating macros in Google Sheets.

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

[timurdothamzin]

The last bit about creating independent web applications was very intriguing, I'd like to learn more about it.

[roseannarabia]

Can you create a video for making your own word search puzzles in Google sheets like you did for Excel? I would be very grateful if you could.

[grzegorz]

so to sum up, to write 'macros' in google sheets we need to know javascript ?

[ImanDehghanDehnaviasl]

please help me, I need to sync my excel file to Google sheet. actually I need scripts that update google sheet data, when excel file have change.

[aliutkutekin]

Hey, can AI comvert vba code to sheets style??

[sakeenasammi]

I got an error as getName is not a function in googlesheets

[arislemus]

what if my run goes to the title of the whole excel spreadsheet and not the sheet1.?