Use macros and add-ons - Google Docs Editors Help (2024)

Switch from Excel to Sheets

Next: Collaborate in Sheets

Use macros and add-ons - Google Docs Editors Help (1)

On this page

  • Automate tasks with macros
  • Convert Excel macros to Google Sheets
  • Do more with add-ons

Automate tasks with macros

Use macros and add-ons - Google Docs Editors Help (2)

Excel:
Individual messages

Sheets:
Macros and Google Apps Script

Use macros and add-ons - Google Docs Editors Help (3)

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

  • Limit the number of actions in a macro for optimum performance.
  • Use macros for frequently repeated operations that don’t need much configuration.
  • Use unique macro shortcuts. You can have up to 10 shortcuts per sheet. Open additional macros from ToolsUse macros and add-ons - Google Docs Editors Help (4)Macros.
  • Reduce macro duplication by applying a macro created for a single cell to a range of cells by selecting the full range of cells and then activating the macro.
  • Macro scripts are specific to individual sheets and can only be used in Sheets—they won’t work in Google Docs, Forms, or Slides.

Record a macro:

  1. On your computer, open a spreadsheet at sheets.google.com.
  2. At the top, click ExtensionsUse macros and add-ons - Google Docs Editors Help (5) Macros Use macros and add-ons - Google Docs Editors Help (6) Record macro.
  3. At the bottom, choose which type of cell reference you want your macro to use:
  • Use absolute references: The macro will do tasks on the exact cell you record. For example, if you bold cell A1, the macro will only ever bold cell A1 regardless of which cell you clicked.
  • Use relative references: The macro will do tasks on the cell you select and its nearby cells. For example, if you record bolding cells A1 and B1, the macro can later be used to bold cells C1 and D1.
  1. Complete the task you want to record. When you’re done, click Save.
  2. Name the macro, create a custom shortcut, and click Save.
  • Note: When you create a macro in Google Sheets, an Apps Script is created. To edit this Apps Script, at the top, click Tools Use macros and add-ons - Google Docs Editors Help (7) Script editor.

To perform a macro, click Extensions Use macros and add-ons - Google Docs Editors Help (8) Macros Use macros and add-ons - Google Docs Editors Help (9) the macro you want.

Use macros and add-ons - Google Docs Editors Help (10)


Create a script:

  1. Click ToolsUse macros and add-ons - Google Docs Editors Help (11)Script editor.
  2. Create your script.

For more information, seeOverview of Google Apps Script, or read more about custom functions and macros.

Convert Excel macros to Google Sheets

Use macros and add-ons - Google Docs Editors Help (12)

Excel:
Edit macros

Sheets:
Recreate macros in Sheets

Use macros and add-ons - Google Docs Editors Help (13)

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:

  1. Make a note of the macros in your original Excel spreadsheet that you need to re-create in Sheets.
  2. In Sheets, open a spreadsheet and click ToolsUse macros and add-ons - Google Docs Editors Help (14)MacrosUse macros and add-ons - Google Docs Editors Help (15)Record macro.
  3. Select the type of cell reference to use and click Save.
  4. Complete the task that you want to record and click Save.
  5. Enter a name for the macro and, optionally, a shortcut number and click Save.
  6. Click ToolsUse macros and add-ons - Google Docs Editors Help (16)MacrosUse macros and add-ons - Google Docs Editors Help (17)Manage macros to edit your script.
  7. Next to the macro that you want to edit, click MoreUse macros and add-ons - Google Docs Editors Help (18)Use macros and add-ons - Google Docs Editors Help (19)Edit script.
  8. In the macros.gs section, make your changes to the code. If needed, use the Sheets Apps Script documentation or search online for the JavaScript concept that you need.
  9. Click Save macroUse macros and add-ons - Google Docs Editors Help (20)and close the tab to return to your spreadsheet.
  10. Repeat steps 2–7 for any additional macros that you want to re-create from your original spreadsheet.

Activate a macro in Sheets

  1. Click ToolsUse macros and add-ons - Google Docs Editors Help (21)MacrosUse macros and add-ons - Google Docs Editors Help (22)your saved macro. You can also run your macro by using its keyboard shortcut.
  2. If it’s the first time you run the macro, allow authorization.

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

Use macros and add-ons - Google Docs Editors Help (23)

Excel:
Add-Ins

Sheets:
Add-ons

Use macros and add-ons - Google Docs Editors Help (24)

Excel 2013

Use macros and add-ons - Google Docs Editors Help (25)

Excel 2010

Use ready-made add-ons to do more with Sheets. Here’s a few things you
can do:

  • Use the Data connector for Salesforce to connect with Salesforce.
  • Use Supermetrics to connect with MySQL and Oracle.
  • Use Copper CRM Custom Report Builder to integrate Copper CRM data.
  • Use Greenhouse Report Connector to integrate Greenhouse
    recruiting data.

Download add-ons:

  1. Click Add-onsUse macros and add-ons - Google Docs Editors Help (26)Get add-ons.
  2. (Optional) To see a description of the add-on, point to it or click it for a full description.
  3. Click the add-on you want to install and click Free.
  4. If needed, review the access message and click Allow.

Use macros and add-ons - Google Docs Editors Help (27)

Back to top


Use macros and add-ons - Google Docs Editors Help (29)

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.

Next: Collaborate in Sheets

Need more help?

Try these next steps:

Post to the help community Get answers from community members

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.

Use macros and add-ons - Google Docs Editors Help (2024)
Top Articles
Latest Posts
Recommended Articles
Article information

Author: Manual Maggio

Last Updated:

Views: 6059

Rating: 4.9 / 5 (69 voted)

Reviews: 92% of readers found this page helpful

Author information

Name: Manual Maggio

Birthday: 1998-01-20

Address: 359 Kelvin Stream, Lake Eldonview, MT 33517-1242

Phone: +577037762465

Job: Product Hospitality Supervisor

Hobby: Gardening, Web surfing, Video gaming, Amateur radio, Flag Football, Reading, Table tennis

Introduction: My name is Manual Maggio, I am a thankful, tender, adventurous, delightful, fantastic, proud, graceful person who loves writing and wants to share my knowledge and understanding with you.