📁Import/Export in Excel

The Guardian introduces a powerful feature designed to streamline the management of policy schemas by enabling users to import and export schemas directly from and to Excel file format. This functionality bridges the gap between the flexibility of spreadsheet management and the structured requirements of Guardian JSON schemas, making it significantly easier for users to handle large volumes of data and complex schema structures.

With the Import/Export feature, users can efficiently transform schemas written in Excel into valid Guardian JSON schemas and export existing Guardian schemas into Excel format for review, modification, or archival purposes. This integration is particularly useful for users who prefer the accessibility and familiarity of Excel for drafting and conceptualizing data models before implementing them within the Guardian framework. It also facilitates a smooth transition for policies and tools that require periodic updates or revisions by allowing users to manage these changes outside the Guardian environment before re-importing them for deployment.

This guide provides detailed instructions on how to utilize the Import/Export schemas feature, including handling errors, understanding the autogenerated blocks within the Guardian policy flow, and utilizing the provided template for schema creation. By following this guide, users can leverage Excel’s versatility alongside Guardian’s robust data management capabilities to enhance their policy management processes.