Office Scripts is here to automate your repetitive Excel tasks

Office Scripts Integration Power Automate
Office Scripts Integration Power Automate (Image credit: 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.

Sean Endicott
News Writer and apps editor

Sean Endicott is a tech journalist at Windows Central, specializing in Windows, Microsoft software, AI, and PCs. He's covered major launches, from Windows 10 and 11 to the rise of AI tools like ChatGPT. Sean's journey began with the Lumia 740, leading to strong ties with app developers. Outside writing, he coaches American football, utilizing Microsoft services to manage his team. He studied broadcast journalism at Nottingham Trent University and is active on X @SeanEndicott_ and Threads @sean_endicott_. 

Read more
Excel spreadsheet with checkboxes
Microsoft 365 Copilot is about to make importing data into Excel almost effortless
Microsoft 365 app on Windows 11 with shortcuts to create documents in Word, PowerPoint, Excel, and other Microsoft 365 applictions.
This Microsoft 365 feature will nudge users to save files to OneDrive
Microsoft Word logo in Windows 11 Search.
Microsoft quietly tests free, ad-supported version of Office apps for Windows with limited functionality
Microsoft Teams logo with a keyboard behind it.
Microsoft Teams marches closer to letting you skip meetings, don't tell your boss
Microsoft CEO Satya Nadella in front of the Microsoft Copilot AI logo.
Revamped Copilot for Business: Microsoft's answer to gimmicky AI tool allegations?
In this photo illustration OpenAI icon is displayed on a mobile phone screen in Ankara, Turkiye on August 13, 2024.
OpenAI gets a step closer to being "the everything app" — ChatGPT mimics Siri with ability to schedule recurring tasks and set reminders
Latest in Office 365
Microsoft Word logo in Windows 11 Search.
Microsoft quietly tests free, ad-supported version of Office apps for Windows with limited functionality
Microsoft 365 Copilot
Microsoft's new 'Microsoft 365' rebranding has us all perplexed. Again.
American football using Microsoft technology
How Microsoft 365 excelled my American football team to back-to-back northern championships
Microsoft Office
Final Microsoft 365 Insider blog post marks end of an era... sort of
Microsoft Word open on an HP Spectre x360 16 (2024)
Do you need to buy all of Office or is Word enough?
Microsoft PowerPoint on an iPhone
Microsoft's new iOS widget brings recently accessed Office 365 files directly to your home screen
Latest in News
Cloud servers
Microsoft has killed "several" data center projects in the U.S. and Europe, according to reports — Microsoft responds (Updated)
Photo of Microsoft's new sign-in page for Xbox.com using the Microsoft Edge browser.
Over one billion users will get a new Microsoft user experience, and it has a dark mode
The Thing: Remastered key art
The Thing comes to Xbox Cloud Gaming's "Stream Your Own Game" library alongside other new arrivals
Promotional screenshot of heroes fighting a giant in Pillars of Eternity
Obsidian's classic Baldur's Gate successor 'Pillars of Eternity' is getting a surprise turn-based mode later this year, alongside other updates
Atomfall
Atomfall reviews and Metacritic scores are in: Here's a roundup of what everyone's saying about this new Game Pass survival game
Screenshot of one of the new flat world presets in Minecraft.
Minecraft testing new flat world presets and a better way to locate your friends in-game