I am using a Microsoft 365 work account and I want to develop Office Scripts for Excel to automate monthly Excel tasks that I can also share with other co-workers. Sharing a Script has been fine. But as I am developing the Scripts, I really want source control and to document the development process. I was hoping to use VS Code (either desktop or on the web version) to edit and version control (git) the script.

There is an Office Script Extension for VS Code that is only available for the Browser/On the Web version of the VS Code. However, I can’t find any documentation for the usage of the extension. It seems like I need to connect the Code Editor (found in the Automate tab of Excel on the Web) to VS Code somehow, but again, I haven’t found a way to do this. Is what I am wanting to do even possible? I am hoping the Office Scripts Extension will handle .osts conversion to something I can edit in VS Code (just like the Code Editor), or I would even be fine with version control if the Code Editor itself supported it (since it seems to be based off VS Code anyway), but I haven’t found a solution so far.