{"id":5498,"date":"2020-10-27T12:31:33","date_gmt":"2020-10-27T19:31:33","guid":{"rendered":"https:\/\/officedevblogs.wpengine.com\/?p=5498"},"modified":"2022-05-31T09:10:57","modified_gmt":"2022-05-31T16:10:57","slug":"looking-to-automate-in-excel-check-out-whats-cooking-with-office-scripts","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/looking-to-automate-in-excel-check-out-whats-cooking-with-office-scripts\/","title":{"rendered":"Looking to automate\u00a0in\u00a0Excel? Check out what\u2019s cooking with Office Scripts\u00a0"},"content":{"rendered":"<p><span data-contrast=\"none\">Hi<\/span><span data-contrast=\"none\">\u00a0there<\/span><span data-contrast=\"none\">!\u00a0<\/span><span data-contrast=\"none\">I\u2019m Nancy, and I\u2019m a Program Manager at Microsoft.\u00a0<\/span><span data-contrast=\"none\">Here on the Office Platform team, we\u2019re<\/span><span data-contrast=\"none\">\u00a0hard at work creating a scripting tool with the goal of making it easy for Office users to automate their tasks. Today I\u2019m excited to introduce you to the product of our efforts \u2013 Office Scripts \u2013 and how it can simplify your Excel workflow.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h3>What\u00a0is\u00a0Office Scripts?<\/h3>\n<p><span data-contrast=\"none\">Office Scripts is a new feature within Excel on the web, built with the goal of enabling Office users to automate their tasks anytime and anywhere.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">Y<\/span><span data-contrast=\"none\">ou can think of Office Scripts as the recipe<\/span><span data-contrast=\"none\">\u00a0for your computer to follow, and Excel\u00a0<\/span><span data-contrast=\"none\">a<\/span><span data-contrast=\"none\">s the kitchen where you use the recipe.<\/span><span data-contrast=\"none\">\u00a0With Office Scripts, nearly anything you do with your keyboard and mouse in Excel can be made into a script that can be used repeatedly.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h3>What makes Office Scripts useful?<\/h3>\n<p><span data-contrast=\"none\">As you might guess, we frequently use Excel on the Office Platform team.\u00a0<\/span><span data-contrast=\"none\">As we build out Office Scripts, we continue to look for ways to automate our tasks on Excel<\/span><span data-contrast=\"none\">. So far, this includes:\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul>\n<li><span data-contrast=\"none\">Scheduling get-togethers with people across the team.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"none\">Sending daily reports to track the progress of feature work.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"none\">Cleaning and filtering data to understand customer feedback.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"none\">Interested in any of these scenarios or got your own cool\u00a0<\/span><span data-contrast=\"none\">Office Scripts\u00a0<\/span><span data-contrast=\"none\">idea?\u00a0<\/span><span data-contrast=\"none\">Let\u2019s get\u00a0cooking!<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h3><span data-contrast=\"none\">How can I get Office Scripts?<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"none\">Getting to Office Scripts\u00a0<\/span><span data-contrast=\"none\">takes two steps<\/span><span data-contrast=\"none\">:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ol>\n<li><span data-contrast=\"none\">Open an Excel workbook on the web.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"none\">Click the Automate tab.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"alignleft wp-image-5502\" src=\"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Automate-tab-1024x661.jpg\" alt=\"Office Scripts can be found on the Automate tab in Excel on the web\" width=\"650\" height=\"419\" srcset=\"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Automate-tab-1024x661.jpg 1024w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Automate-tab-300x194.jpg 300w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Automate-tab-768x495.jpg 768w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Automate-tab.jpg 1310w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<p><span data-contrast=\"none\">If you don\u2019t see the Automate tab,\u00a0<\/span><span data-contrast=\"none\">it\u2019s likely that your admin has turned off our feature or our\u00a0<\/span><span data-contrast=\"none\">feature is<\/span><span data-contrast=\"none\">\u00a0not yet available in your area.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:1,&quot;335559739&quot;:160,&quot;335559740&quot;:480}\">\u00a0<\/span><\/p>\n<h3><span data-contrast=\"none\">Creating your first Office Script<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"none\">Just like you might use an assortment of kitchen tools to cook a dish<\/span><span data-contrast=\"none\">, there are multiple ways to create a script<\/span><span data-contrast=\"none\">: you can either record your actions using our\u00a0<\/span><b><span data-contrast=\"none\">Action Recorder<\/span><\/b><span data-contrast=\"none\">\u00a0or write a script using our\u00a0<\/span><b><span data-contrast=\"none\">Code Editor<\/span><\/b><span data-contrast=\"none\">.<\/span><span data-contrast=\"none\">\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ol>\n<li data-leveltext=\"%1.\" data-font=\"\uff2d\uff33 \u660e\u671d\" data-listid=\"25\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Recording a Script<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ol>\n<p><span data-contrast=\"none\">The action recorder will capture the actions you take on a workbook and save it for you into a script.<\/span><\/p>\n<p><img decoding=\"async\" class=\"alignleft wp-image-5501\" src=\"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Action-recorder-1024x582.jpg\" alt=\"The action recorder starts recording your actions right after you click the \u201cRecord Actions\u201d button in the Automate tab.\" width=\"650\" height=\"370\" srcset=\"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Action-recorder-1024x582.jpg 1024w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Action-recorder-300x171.jpg 300w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Action-recorder-768x437.jpg 768w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Action-recorder.jpg 1314w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<p><span data-contrast=\"none\">2. Editing a Script <\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">You can<\/span><span data-contrast=\"none\">\u00a0also<\/span><span data-contrast=\"none\">\u00a0write and edit scripts using TypeScript inside the code editor.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><img decoding=\"async\" class=\"alignleft wp-image-5504\" src=\"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Code-Editor-1-1024x576.jpg\" alt=\"The code editor comes with built-in IntelliSense features to make it easier for you to edit and write scripts.\" width=\"650\" height=\"365\" srcset=\"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Code-Editor-1-1024x576.jpg 1024w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Code-Editor-1-300x169.jpg 300w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Code-Editor-1-768x432.jpg 768w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/10\/Code-Editor-1.jpg 1327w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<p><b><span data-contrast=\"none\">BONUS:\u00a0<\/span><\/b><span data-contrast=\"none\">You can also include your scripts as part of a Flow in Power Automate<\/span><span data-contrast=\"none\">. To get there,\u00a0<\/span><span data-contrast=\"none\">navigat<\/span><span data-contrast=\"none\">e<\/span><span data-contrast=\"none\">\u00a0to\u00a0<\/span><span data-contrast=\"none\">Code Editor &gt;\u00a0<\/span><span data-contrast=\"none\">Script Details &gt; Create Flow.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">If Office Scripts are recipes, y<\/span><span data-contrast=\"none\">ou can think of<\/span><span data-contrast=\"none\">\u00a0<\/span><span data-contrast=\"none\">Power Automate as the\u00a0<\/span><span data-contrast=\"none\">restaurant<\/span><span data-contrast=\"none\">\u00a0\u2013 just like a\u00a0<\/span><span data-contrast=\"none\">restaurant serves all kinds of recipes<\/span><span data-contrast=\"none\">, Power Automate allows you to connect all types of first- and third-party applications to automate your workflow. Connecting Office Scripts with Power Automate allows you to take advantage of a full host of additional capabilities such as emailing your workbook after running a script, pasting important data to a Word document, or tweeting status updates through Twitter.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h3><span data-contrast=\"none\">Learning more about Office Scripts<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"none\">Want\u00a0to learn more about Office Scripts? Come check out these resources and follow us along in the Office Scripts journey:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<table data-tablestyle=\"MsoTableGridLight\" data-tablelook=\"1696\">\n<tbody>\n<tr>\n<td data-celllook=\"0\"><span data-contrast=\"none\">Office Scripts Documentation<\/span><span data-ccp-props=\"{&quot;201341983&quot;:1,&quot;335559740&quot;:240}\">\u00a0<\/span><\/td>\n<td data-celllook=\"0\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/dev\/scripts\/overview\/excel\">https:\/\/aka.ms\/try-scripts <\/a><\/td>\n<\/tr>\n<tr>\n<td data-celllook=\"0\"><span data-contrast=\"none\">Sample\u00a0<\/span><span data-contrast=\"none\">Office\u00a0<\/span><span data-contrast=\"none\">Scripts<\/span><span data-ccp-props=\"{&quot;201341983&quot;:1,&quot;335559740&quot;:240}\">\u00a0<\/span><\/td>\n<td data-celllook=\"0\"><a href=\"https:\/\/aka.ms\/officesamplescripts\"><span data-contrast=\"none\">https:\/\/aka.ms\/officesamplescripts<\/span><\/a><span data-ccp-props=\"{&quot;201341983&quot;:1,&quot;335559740&quot;:240}\">\u00a0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><span data-contrast=\"none\">Sharing\u00a0your feedback<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"none\">We are constantly looking to improve and grow our\u00a0feature! Currently, these are the best ways to reach out to our team:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ol>\n<li><span data-contrast=\"none\">If you have any feedback or suggestions for the new Office Scripts feature, please let us know via\u00a0<\/span><a href=\"https:\/\/excel.uservoice.com\/\"><span data-contrast=\"none\">User Voice<\/span><\/a><span data-contrast=\"none\">.\u00a0<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"none\">If you have any API usage related questions, ask your question on the\u00a0<\/span><a href=\"https:\/\/stackoverflow.com\/questions\/tagged\/office-scripts\"><span data-contrast=\"none\">StackOverflow<\/span><\/a><span data-contrast=\"none\">\u00a0website using [office-scripts] tag.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"none\">If there is a problem with the Action Recorder or API, send feedback through opening the overflow menu of the Code Editor and selecting the Send Feedback button in Excel for the web.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ol>\n<p><span data-contrast=\"auto\">We look forward to hearing from you. In the\u00a0<\/span><span data-contrast=\"auto\">meantime<\/span><span data-contrast=\"auto\">, happy scripting!<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Nancy<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn all about Office Scripts. Office Scripts is a new feature within Excel on the web, built with the goal of enabling Office users to automate their tasks anytime and anywhere.\u00a0\u00a0<\/p>\n","protected":false},"author":69076,"featured_media":25159,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[11],"tags":[18,177],"class_list":["post-5498","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-add-ins","tag-excel","tag-office-scripts"],"acf":[],"blog_post_summary":"<p>Learn all about Office Scripts. Office Scripts is a new feature within Excel on the web, built with the goal of enabling Office users to automate their tasks anytime and anywhere.\u00a0\u00a0<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/5498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/users\/69076"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/comments?post=5498"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/5498\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/media\/25159"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/media?parent=5498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/categories?post=5498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/tags?post=5498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}