Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
I've been treating Excel like a glorified calculator for most of my life. Sure, formulas made doing more complex calculations easier and automatically updated data, and there are free Excel templates ...