Switch from Excel to Sheets
On this page
- Automate tasks with macros
- Convert Excel macros to Google Sheets
- Do more with add-ons
Automate tasks with macros
Excel: | Sheets: |
---|---|
Excel 2013 and 2010 | Automate repetitive tasks with macros in Sheets. Or, if you need custom functions, menus, or windows, you can create them with Google Apps Script. Review macro best practices
Record a macro:
To perform a macro, click Extensions Macros the macro you want.
For more information, seeOverview of Google Apps Script, or read more about custom functions and macros. |
Convert Excel macros to Google Sheets
Excel: | Sheets: |
---|---|
Excel 2010 and 2013 | You can convert macros in Microsoft Excel spreadsheets to Google Sheets by re-creating them using Google Apps Script. Apps Script powers macros in Sheets, just like Microsoft Visual Basic for Applications does for Excel. Re-create and edit a macro in Sheets using Apps Script:
Activate a macro in Sheets
Tip: For more about how the Apps Script library can mimic common Visual Basic for Applications (VBA) functions, go to Simplifying Migration from VBA to Google Apps Script. |
Do more with add-ons
Excel: | Sheets: |
---|---|
Excel 2013 Excel 2010 | Use ready-made add-ons to do more with Sheets. Here’s a few things you
Download add-ons:
|
Back to top
Want advanced Google Workspace features for your business?
Try Google Workspace today!
Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companieswith which they are associated.
Need more help?
Try these next steps:
Visit the Learning Center
Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.