How do/would you generate scripts for various network elements

Originally posted on /r/learnpython and was directed here, I have searched but couldnt really find an answer, any help much appreciated!

So in my role I am a faux developer with a bit of vba and a bit of python skill.

I support a team who has a function to generate scripts of different types for different platforms from routers to much more complex ne’s in the telco space. We have a variety of inputs that we take and post process into scripts that load into the gear and most of this data comes from excel spreadsheets.

Previous developers built a large number of excel tools with vba to perform data visualisation (checking data being imported with colours to show good or bad, asking user questions or filling in fields manually then generating the scripts.

This works well enough but I am hoping to move away from this to something hopefully with some python and some sort of ui.

Any suggestions on how you would tackle this or how we can do it better?

Thanks in advance!