Sourcetable Integration

Export FortiManager policy to CSV

Jump to


    Welcome to our comprehensive guide on how to export FortiManager policy to a CSV file. Exporting your firewall policy data into a CSV format is a powerful step towards efficient management, providing an effective way to organize, analyze, and manipulate large sets of policy data, especially when integrated into spreadsheet applications. On this page, we will delve into the essentials of what FortiManager policy entails, the step-by-step process to export these policies to a CSV file, and the practical use cases for doing so. For those looking to go beyond the basics, we'll introduce Sourcetable as an alternative tool tailored for comparing and contrasting over a thousand policies with ease. Additionally, we will address common questions and answers related to exporting FortiManager policies to CSV, ensuring you have all the information at your fingertips.

    What is FortiManager Policy?

    FortiManager policy is a set of rules governing network traffic, integral to managing security policies on Fortinet devices. This encompasses the creation, editing, and installation of policies such as web filter policies, FDS policies, and FortiGuard policies, which are part of the Fortinet Security Fabric. The policy ensures that all changes related to security are made centrally and consistently across the network.

    Within FortiManager, the Policy & Objects feature is pivotal for centralized management and configuration of these devices. It includes basic network settings, antivirus definitions, intrusion protection signatures, access rules, and the ability to manage and update firmware. As such, FortiManager policies and objects play a crucial role in maintaining and enforcing security standards across the network infrastructure.

    Exporting FortiManager Policy to a CSV File

    Exporting from FortiManager 6.0.3

    To export a policy package from FortiManager version 6.0.3, ensure you are within the correct ADOM. Navigate to 'Policy & Objects > Policy Packages', select the desired policy package, and choose 'Export to CSV' from the Policy Package menu. The policy package will then be downloaded to your management computer.

    Exporting from Other FortiManager Versions

    In general, to export a policy package to a CSV file in FortiManager, you must be in the appropriate ADOM. Access 'Policy & Objects > Policy Packages', select the policy package or folder you wish to export, and click on 'Export to CSV' from the Policy Package menu. The policy package gets downloaded to your management computer.

    Post-Export Editing

    After exporting the policy package to a CSV file, you may need to edit the CSV file. This can be done using Microsoft Excel. Once you have made the necessary changes, save the document to finalize your CSV file.

    Sourcetable Integration

    Streamline Your Policy Management with Sourcetable

    Managing your FortiManager policies is now more efficient than ever with Sourcetable. By utilizing Sourcetable's powerful capabilities to import your policies directly, you eliminate the cumbersome process of exporting to CSV and then importing to another spreadsheet program. This seamless integration allows for real-time synchronization of your live data from FortiManager, ensuring that your policy management is always up-to-date and reflective of the latest changes.

    Sourcetable's intuitive spreadsheet interface, familiar to any spreadsheet user, provides a robust platform for querying and manipulating your data. This means less time spent on data entry and more time analyzing and optimizing your network security policies. The added benefits of automation and advanced business intelligence capabilities make Sourcetable an indispensable tool for organizations looking to improve their security posture with efficiency and accuracy.

    Common Use Cases

    • F
      Sourcetable Integration
      Centralized management of firewall policies
    • F
      Sourcetable Integration
      Compliance verification with best practices
    • F
      Sourcetable Integration
      Workflow automation through bulk policy editing
    • F
      Sourcetable Integration
      Optimization of policy data management with Excel tools
    • F
      Sourcetable Integration
      Enhancement of information readability and manipulation in CSV format

    Frequently Asked Questions

    How do I export a policy package to a CSV file using FortiManager?

    To export a policy package to a CSV file, ensure you are in the correct ADOM, navigate to Policy & Objects > Policy Packages, select the desired policy package or folder, and from the Policy Package menu, choose Export to CSV. The file will be downloaded to your management computer.

    Can I export FortiManager firewall policies to both Excel and CSV formats?

    Yes, FortiManager allows you to export firewall policies in both Microsoft Excel and CSV formats.

    What are the advantages of exporting firewall policies to a CSV file?

    Exporting to a CSV file makes it easier to manage the large amount of data, as it is typically easier to read and manage tasks such as searching, filtering, sorting, and counting compared to an Excel file.

    Is it possible to modify the exported Excel file from FortiManager for better data management?

    Yes, when exporting to Excel, the file should be modified to enable better searching, filtering, sorting, and counting. After modification, it can be saved as a final document.

    Do I need to be in a specific ADOM to export a policy package from FortiManager?

    Yes, to export a policy package, you must be in the correct ADOM.


    FortiManager 6.0 provides a seamless and efficient way to manage your network's firewall policies by allowing the export of policy packages to CSV files, enhancing the manageability, readability, searchability, sorting, and counting of your security policies. By following a few simple steps, such as ensuring you are in the correct ADOM, navigating to Policy & Objects > Policy Packages, selecting the desired package, and choosing to export to Excel or CSV from the Policy Package menu, you can have your policy package conveniently downloaded to your management computer. However, for an even more streamlined process, consider using Sourcetable to import data directly into a spreadsheet, bypassing the need for manual exports. Sign up for Sourcetable to get started and elevate your policy management to the next level.

    Start working with Live Data

    Analyze data, automate reports and create live dashboards
    for all your business applications, without code. Get unlimited access free for 14 days.