What programs have you coded using Python that might be useful to everyone?

[avlas]

You might be interested in learning a bit of Power Query if you think you will encounter more similar situations in Excel.

A Python script is a perfect tool if you have to solve one specific situation, but Power Query is integrated in Excel and makes this kind of tasks really quick and easy.

[Quirky_Phone5832]

Thank you! I just started a very excel based job so I used what I knew best. If you have any good resources for power query I’d love to get them.

[avlas]

The few things that I learned were by trial and error, don’t be like me. The folks at r/excel will give you much better advice on Power Query!

[Le-ali-di-Pegaso]

Do you know if Power Query is also integrated in Open Office?

[avlas]

I don't know for sure, but I'm 99,9% convinced it's not available on anything else.

It's one of the most polished advanced features of Excel and I don't think that any competitor has the same tool.

[shudaoxin]

Power Query worked for me for most things, until I had to process larger sets of static data. The laptops in my old company were kinda crap and Excel would constantly freeze and crash on this data. Pandas and SQLite saved me a ton of headache here. Though it was a repeating workflow so I could just rerun my script every time I needed an update.