This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 71%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hello,
is there a way how to debug Excel scripts (Office scripts using TypeScript, not VBA), using Code Editor?
Hi PoPe,
Absolutely, you have the ability to troubleshoot Office scripts crafted in TypeScript by utilizing the Code Editor. Microsoft's Office Scripts leverage the capabilities of TypeScript, providing an avenue for a contemporary and well-organized scripting method within Excel. The process of debugging TypeScript code revolves around making use of the debugging resources accessible within the specific integrated development environment (IDE) you are using for your work.
Hope this helps. Give a thumbs up if you find this as an anwer.
I am using Code Editor in Excel, not a specific IDE. The Code Editor in Excel does not seem to have an option, how to debug the code. In IDE outside of the Excel, there is the question, how would I import ExcelScript package.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 18%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Hi,
You can output values and messages to the console by using console.log() statements in your code. It can assist you in understanding what is occurring in your script, despite not being as sophisticated as a full debugging environment.
Or, To detect and address potential script errors, use try-catch blocks. This won't give you access to a debugging environment, but it can show you where an error is happening.
Best Regards.
In other words, there are only workarounds, not a real debugging tool. Try-catch or console.log are useful, but do not fully replace debugging - for example, you cannot stop the code at a given line. It would be nice if the debugging tool was added to the code editor in MS Excel. Otherwise it is sometimes a headache to write Excel scripts in TypeScript.
For those who face the same problem, I also recommend using chat GPT or other AI to identify the errors.
that's correct PoPe.
If my answer helped you, i would appreciate it if you can mark it as "Accepted Answer".
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 51%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
It seems really crippling not to have the ability to debug in the code editor. It feels like programming in the 80s. I thought we were way beyond using print statements to debug. I guess you may also need to make a copy of your spreadsheet and debug with the copy in case you can't undo something after running a script with a bug destroys data.