Using Excel to work with configuration files
I've had to do some recent additions here for a few /27 networks to our firewall configuration. I found a way to leverage the excel developer options to work with a source config XML so I can quickly add a bunch of entries to nat rules etc. Once exported the files need some basic search/replace to clean them up but otherwise it saves a ton of time compared to manully entering every address into the UI screens one by one.
I'm wondering if a guide already exists, where I would find it, and how I would go about writing up and submitting one if not.
There is no such guide that I'm aware of. If you write one, it may live here on the forum, perhaps as a sticky. I'm not sure that's a practice we'd want to actively encourage through putting it on the wiki, since there is quite a lot of room for error when making any changes to the config, especially automated changes.