r/excel • • 18h ago

Plugin Python embedded in Excel

10 Upvotes

Hi All,

This weekend for a bit of fun I built a free / source-available Excel add-in which hosts it's own Python runtime.

You can find a feature runtime and installation guide on the website:

https://sancarn.github.io/xll-python/index.html

fork it here: https://github.com/sancarn/xll-python

But here's an overview:

  • You can write user defined functions which execute like formula.
  • Returning a generator will make the result update every time it yield's a result.
  • You can write macros (e.g. reading / writing CSVs/databases from disk etc.)
  • There's an in-built IDE
  • You can debug formula in the IDE
  • There's a console/REPL where you can experiment with the available runtime
  • There's a package manager where you can install pip packages
  • There's a compiler so you can compile your own scripts into standalone .xll addins.

Hope you find this helpful! ~Sancarn

Edit: This project is AI:X. All code written by Astra & Sol 6.2; albeit with a lot of steering.


r/excel • • 8h ago

Discussion Learning Excel through Google Sheets – is that normal?

18 Upvotes

I recently bought an Excel course, but the instructors said we'll be doing all the lessons and exercises in Google Sheets because the two programs are supposedly 95% identical.

I'm curious if that's really the case. What do you guys think?


r/excel • • 18h ago

Game I made an excel style game for you. Play in browser, free, no signup

24 Upvotes

I made this fun little game where you have to hit a certain target each quarter. Or you'll get fired. It's a strategy/RNG game where you try to figure out different synergies to be able to hit the target. Don't play if you have anything productive to do!

https://gamesgamestudio.itch.io/excel-roguelite


r/excel • • 21h ago

Weekly Recap This Week's /r/Excel Recap for the week of November 14 - November 20, 2026

4 Upvotes

Saturday, November 14 - Friday, November 20, 2026

Top 5 Posts

scorecommentstitle & link
30573 comments[Discussion] I just learned about LET and it cleaned up this formula - what else do you use it for?
8429 comments[Discussion] After LET, I tried LAMBDA - here is a reusable formula I made
8120 comments[unsolved] what's this new green dots thing on excel?
7513 comments[Novelty] Film made entirely in Excel...
5668 comments[unsolved] How does copying in Excel actually work?

 

Unsolved Posts

scorecommentstitle & link
2428 comments[unsolved] How to prevent Powerquery from re-downloading an excel file used as a source over and over?
1823 comments[unsolved] Data entry in shared files horribly built
1215 comments[unsolved] Best Excel architecture for configuration control: 1 Master + 49 Sub-Packages tabs
1212 comments[unsolved] Weird New Options Around Column/Rows
109 comments[unsolved] Getting constant "Circular reference" warnings

 

Top 5 Comments

scorecomment
316/u/gerard4156 said Braille
148/u/PedroFPardo said Excel’s clipboard doesn’t work like the normal Windows clipboard. If you type something somewhere else in the document after pressing Ctrl+C, Excel will forget what you were copying, and to show this,...
108/u/Shahfluffers said I typically use LET when I have truly gnarly multi "if-else" formulas. Which tends to happen when calculating budgetary/payroll/benefit stuff. Example: - LET(rate01,C50,benefitName,A50,benefitAp...
90/u/CIP_In_Peace said You get more value out of Excel with AI if you know very well what Excel can do. So yes there is a need, but not as much as there maybe once was.
79/u/SolverMax said Wait until you find out about new lines (ALT+Enter) and indents (Space). =LET( _data, A2:A10, _threshold, C1, _rate1, C2, _rate2, C3, _total, SUM...

 


r/excel • • 11h ago

solved Option to modify cell styles not appearing when right clicking

2 Upvotes

Using excel for Mac standalone version, Microsoft 365 subscription, Version 16.115 (26110837) latest version as per the updater. I need to modify the cell style for hyperlinked cells like I used to do the past weeks, but recently the option for that disappeared probably few days ago, just noticed it last night. Right clicking on the cell styles does nothing. Anyone having this problem and how did you fix it? Tried signing in and out of the app, clear application data on the help tab, and restarting laptop. Thanks.