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 (opens in new tab).
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 (opens in new tab).
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.
Windows Central Newsletter
Get the best of Windows Central in in your inbox, every day!
Sean Endicott brings nearly a decade of experience covering Microsoft and Windows news to Windows Central. He joined our team in 2017 as an app reviewer and now heads up our day-to-day news coverage. If you have a news tip or an app to review, hit him up at email@example.com (opens in new tab).
”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.” You should start with this, not sure how many readers here are interested after seeing this.
Thank you for signing up to Windows Central. You will receive a verification email shortly.
There was a problem. Please refresh the page and try again.