Unlock Excel's Hidden Power with Python Editor - Data Manipulation Tool!

Microsoft recently introduced Python support in Excel.

Image Credit - Unplash

Excel Labs, a Microsoft Garage project, created Python Editor.

[{"selector":"#anim-78aefae2-bcb4-45f8-9b76-4d76c148365c [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-19.42515249628466%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-10f8cb6b-b4bc-4389-a204-c2719cafd461","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-428f5d84-a776-484c-adaa-261ddd91ca48","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-ef220714-2152-4e3c-a81a-9d5672f0e862","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] Image Credit - Unplash

Python Editor offers an IDE-like coding experience.

[{"selector":"#anim-3b942151-abc0-45f6-b359-e65296a7e41f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-31.225066375436132%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-87382cc2-1500-4b1a-ba20-feea13fcc11e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c147de1c-1547-4e23-9ea5-5250db573638","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-7c50e559-6187-4e2e-b38e-191ce695a145","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Image Credit - Unplash

Features include syntax highlighting, IntelliSense, and debugging.

[{"selector":"#anim-8f72fdbc-6f52-4fcd-8f1d-1e2811244485 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-6.559145691983291%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-21aa5cd8-8234-4331-a756-79882fb3ea7d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e83884e4-09ce-4896-9e61-8f182f42f9dc","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-6433f2e7-7afb-47e5-811a-e39f15239de6","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Image Credit - Unplash

Designed for longer scripts and traditional programming.

[{"selector":"#anim-6de57e47-eda5-4a0a-a67e-2d4f0150fe35 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-21.874999829338588%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-4fc0711c-7cbe-4db2-91f7-ced2fc62bd09","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-28f48d38-8ac6-4742-a7c9-306679582b82","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-09a8a99f-acd1-42c8-a9f1-ff6b17642d93","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Image Credit - Unplash

Changes in code won't affect data until committed.

[{"selector":"#anim-240cd2bf-f52c-4fae-8d41-e7b0d4edf576 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-48.19078949922563%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-7ceca812-3173-4c8b-86b9-41892edc4aa0","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-42b1aa0b-adcd-4569-819b-6f6a21fc3e16","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-ff58dfdb-e250-4eb4-86f1-0e91a90ed091","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Image Credit - Unplash

Available as an Excel Labs add-in via Add-ins Store.

[{"selector":"#anim-7e518bdd-94ea-4e21-87f4-845fda39ffd1 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-31.249999886225726%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-47b328b0-70be-41d8-a0ac-1ec62d8e186c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bd8d5b40-8f28-4184-8dfa-8af799a90356","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-9ded077a-ad3e-4fea-95d2-1fdc38b0ac0e","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Image Credit - Unplash

Potential integration into Excel if it gains popularity.

[{"selector":"#anim-f176aec5-a923-495b-b2c4-c6675177e486 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-62.49999932084742%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-567a9e47-fcc5-4cea-a56e-b418b74010ee","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0694fbca-1f84-4dfb-9716-5ead382092af","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-3b6a7878-919b-4908-a97d-e35db2adae9e","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Image Credit - Unplash