> ## Documentation Index
> Fetch the complete documentation index at: https://docs.nx1cloud.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Bulk create policies

> Create or update many Ranger policies at once by filling in a table or uploading an Excel file.

Create or update many Ranger policies in one request. You can fill in a table in the portal, or upload an Excel file.

Each row in the table is one policy. If a policy with the same name already exists, NexusOne adds the permissions, groups,
and users in that row to the policy and never replaces what the policy already has.

## Prerequisites

Before starting this task, ensure you have the following:

Required roles: `nx1_migration_admin` or `nx1_migration_ops`.

## Bulk create policies

> [tab] Web portal
>
> Perform these steps to bulk create policies.
>
> 1. Log in to NexusOne.
>
> 2. On the top navigation bar, hover your mouse over **Govern** and then select **Data Access**.
>
> 3. Click the **All policies** tab.
>
> 4. Click **Bulk Create**.
>
> 5. Add the policies with one of the following options:
>
>    * **Table editor**: Click **Add Row** for each policy, and fill in the columns.
>    * **Excel upload**: Click **Download template** and fill in the template. Then click **Excel upload**, choose your
>      `.xlsx` file, and review the rows that appear in the table editor.
>
> 6. Click **Submit**.
>
> 7. Review the results, which show how many policies were created, updated, and failed. For each failed policy, the
>    results show its name and the error.
>
> 8. Click **Done**, or click **Add more rows** to fix the failed rows and submit again.
>
> The table has the following columns:
>
> * **Name**: The policy name.
> * **Role**: The role the policy applies to.
> * **Database**: The database, which is the catalog or schema.
> * **Tables**: The tables the policy covers.
> * **Columns**: The columns the policy covers.
> * **URL**: A storage location, for a storage policy.
> * **Permissions**: The access types to grant.
> * **Groups**: The groups the policy applies to.
> * **Users**: The users the policy applies to.
> * **Item Type**: Select `allow`, `deny`, `allow_exception`, or `deny_exception`.
> * **Row Filter**: A SQL `WHERE` fragment that limits the rows the policy shows.
> * **Label**: A label to add to the policy.
>
> You can submit up to 500 rows at a time.

> [tab] REST API
>
> Use the following API endpoints to:
>
> * [Download an XLSX starter template](https://docs.nx1cloud.com/api-reference/endpoints/policy-management/download-an-xlsx-starter-template-for-the-bulk-create-endpoint.md).
> * [Create or update many Ranger policies](https://docs.nx1cloud.com/api-reference/endpoints/policy-management/create-or-update-many-ranger-policies-in-one-request.md).

## Additional resources

For an overview of the Govern feature, refer to [Govern Overview](https://docs.nx1cloud.com/documentation/govern/overview.md).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.