From Excelano
Writing
The spark behind the tools.
I build tools because something should exist that doesn't yet. These are the notes from that work — the challenges I bump into, how I think about them, and the solutions I share. If any of this sounds familiar, you'll know within a paragraph whether I'm the right person to call.
Cleaning a CSV without corrupting the rest of the file
August 7, 2026
You open a CSV to strip a dollar sign and the tool quietly turns your leading-zero IDs into integers and your part numbers into scientific notation. Here is how I edit the values I mean to and leave everything else byte-for-byte intact.
Read →Power Automate flows you can put in a pull request
July 6, 2026
The Power Automate designer is a web form: no diffs, no review, no way to see a whole flow at once. Here is how I write flows as code instead, and compile them to the definition.json the platform expects.
Read →Getting data out of SharePoint without writing a throwaway script
June 23, 2026
You need to ask a SharePoint list a real question, and the usual answers — export to Excel, build a flow, write a Graph script — are all overkill. Here is how I run real SQL against it instead.
Read →