Office Scripts Integration Power AutomateSource: Microsoft

What you need to know

  • Microsoft announced a new Office Scripts feature for Excel on the web.
  • The feature lets you create automated scripts that make it easy to repeat steps within spreadsheets.
  • You can use Excel's Action Recorder to record your steps to create scripts.

If you regularly work with Excel spreadsheets, you probably have to repeat the same steps on a routine basis. For example, you may need to import data, delete some columns, and reformat parts of the spreadsheet every day. To speed this process up and to reduce repetitive tasks, Microsoft has a new feature called Office Scripts.

Office Scripts is an automation feature available for Excel on the web. Microsoft announced its general availability today and outlines the feature in a Tech Community post.

The idea behind Office Scripts is that it lets people automate their workflow regardless of their programming knowledge. The Microsoft 365 Developer account on YouTube shared a video of the feature earlier this year before it was generally available.

Excel on the web now has an Action Recorder that lets you record steps within Excel. These are then placed in a script that you can run at any time. You can change the scripts any time you'd like through Excel's Code Editor, which is a TypeScript-based editor. You can also use Code Editor with the Office Scripts API.

If you'd like to run a script on a schedule, you can use Power Automate.

To use Office Scripts, you need to have a commercial or EDU license that gives you access to the Microsoft 365 office desktop apps, such as Office 365 E3 or E5 licenses.

We may earn a commission for purchases using our links. Learn more.