Technical Tip: How to export VIP, address, services, ippool objects into Excel or CSV format

[JianWu]

Description	This article describes how to export VIP, address, services, ippool objects into Excel or CSV format. At this time, there is no built-in way to export objects into CSV or Excel format. This article provides a way with an Excel formula to extract values of interest.  In the attached spreadsheet, an example is provided to extract VIP objects based on the config file, it is possible to use the same techniques for other objects such as an address, service, ippool, etc.
Scope	FortiGate.
Solution	In the attached spreadsheet, VIP is used as an example and it is desired to extract all VIP objects and make an Excel file. As can be seen from the Excel file attached, follow the steps below: Copy the config for the VIP section to Column A, this serves the original source worked from. Copy the same config again into Column B, for this column, and remove all the unwanted words such as 'edit', 'set', 'mappedip', 'extip', 'extintf', and quote " itself (replace them with NULL). In Cell from C2 to F2, write the row # that matches the value of interest. Use the Excel function 'indirect' to retrieve the value needed. In this example attached, cells A2 to A20 come from the config file as source data, and cells G1 to J4 are the final result needed. Note : After FortiOS v7.4.2 and above versions, VIPs can be exported directly from GUI to CSV or JSON. Under the VIP page, top right corner, the option to export is available. For address objects, IPpools, and services, the option is slightly different. Refer to the below article to export these objects directly from FortiGate GUI to CSV or JSON: Technical Tip: Export firewall address objects to CSV or JSON