Exporting rules to Excel

Practical configuration and operational reference for Exporting rules to Excel.

Procedure

1. In the Web GUI select Device > Setup > Operations and click on Export Named Configuration Snapshot
2. From the pop-up menu select running-config.xml, and click OK
3. Now edit the xml file and remove all tags until the first <security>, and also remove all tags after </security>
4. Add a header: <?xml version="1.0" encoding="UTF-8"?>
5. Now do remove the following tags doing search and replace for the keyword <member> and </member> with blank (nothing)
6. Save as policy.xml
7. Open a new Excel Spreadsheet and click on MenuBar DATA > From Other Sources > From XML Data import
8. To improve visualisation, replace “ “ (space) with blank (nothing)
9. To export Address-Groups, generate a new copy of running-config.xml and save it as address-group.xml.
10. Search for tag <address-group> and delete all the text before this tag and also delete all the text after the tag </address-group>

See also

• Palo Alto