---
title: "Importing Boundary Updates from Excel"
slug: "importing-boundary-updates-from-excel"
description: "Bulk update boundaries in the Boundaries module using Excel. Follow instructions to upload, match IDs, map fields, and ensure seamless updates."
updated: 2025-04-21T06:19:59Z
published: 2025-04-21T06:19:59Z
canonical: "support.xyicon.com/importing-boundary-updates-from-excel"
---
> ## Documentation Index
> Fetch the complete documentation index at: https://support.xyicon.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Importing Boundary Updates from Excel
Xyicon Users
Xyicon Administrators
Use this article to learn how to import updates in bulk to the [**BOUNDARIES** module](https://support.xyicon.com/preview/v1/en/c1646a7b-e56d-41f0-bb36-0fd801542bb7/17#boundary-module) window using a Microsoft Excel file. You can import updates for a single portfolio or the entire organization (multiple portfolios). Organization-wide import can only be performed by **Xyicon Administrator**.
## Before you begin
#### Xyicon Requirements for Import
- Make sure you have set up the following module settings for the **Boundary** module under Xyicon **Settings** ( ): Boundary Types, Boundary Fields, and Boundary Layouts.
- Verify that your **Xyicon User** has the necessary permissions to update boundaries.
Module settings and user permissions are managed by your organization's **Xyicon Administrator**.
#### Excel File Requirements for Import
All files used for import must:
- Be a `*.csv` or `*.xlsx` format.
- Contain changes related to the boundaries of the **active portfolio** or **organization** at the time of importing.
- Have a header row with column headings. Xyicon considers the first row the header row and will not import your changes if the first row contains values instead of column names.
- Contain a column with the boundary IDs.
- Only include the columns whose data you want to change **to avoid accidental data changes**.
- Be smaller than **5 MB** in size and contain less than **10,000 rows** per single import.
- Ideally, have only one sheet. If your file has more than one sheet, Xyicon will only import the data on the **first sheet**.
## Step 1 - Upload File
1. Go to **Main Menu** ( **** ) **> BOUNDARIES**.
2. Click the **Import** button ( ) on the **Action Bar**. The **Import Updates from Excel** panel will open.
3. Choose the scope of the import.
- **Current Portfolio** - Import is limited to the current portfolio and can be performed by any **Xyicon User** who has permission to update boundaries.
- **Organization** - Import boundary data updates across portfolios in the current organization. Organization-wide import can only be performed by a **Xyicon Administrator**.
4. Next, drag and drop your Excel file (`*.csv` or `*.xlsx`) into the **Upload File** box ( ) or click anywhere inside the box to browse your documents and select your file.
5. If the upload is successful, you will see the file at the bottom of the panel.
6. To replace the uploaded file with a new file, repeat step 3. The uploaded file at the bottom will be replaced automatically with the new file.
7. Once you have successfully uploaded your Excel file, click **Next**.
## Step 2 - Match IDs
In this step, you will select the Excel column that corresponds to the **Boundary** **ID** field in Xyicon, so the application can determine which boundaries to update. Make sure the Excel column you select corresponds to the **Boundary** **ID** field in Xyicon.
1. On the **Import Boundary Updates from Excel > Match IDs** step, select the Excel column name from the **Excel Column** dropdown that matches the **Boundary** **ID** field under **Xyicon** **Boundary Field**.**TIP:** If your Excel column header is named **Boundary** **ID** or **ID**, Xyicon will automatically select the column and display it in the dropdown.
2. Click **Next** to map the rest of the boundary fields to excel columns.
## Step 3 - Map Columns to Fields
Xyicon will attempt to automatically map fields to the Excel Column by matching the field and column names. Xyicon will set the mapping to *(ignore this column)* where the field and column names differ. Calculated fields and system-defined fields (Boundary Type, Last Modified By, Last Modified At) will be ignored by default since they are predefined fields.
**IMPORTANT:** All automatic mappings are recommendations only. Always verify the field mapping between the Excel columns and Xyicon fields are correct to prevent any erroneous updates.
1. On the **Import Boundary Updates from Excel >** **Map Columns to Fields** step, select the correct boundary field from the respective dropdowns under **Xyicon** **Boundary Fields** for each excel column.**TIP:** You must map at least one column to a field to import your changes.
2. Select the default value *(Ignore this column)* if you do not want to import an update to a particular field.
3. Once you have completed mapping fields between Excel and Xyicon, you are ready to [import your updates](/v1/docs/importing-boundary-updates-from-excel#step-4-import-your-updates).
## Step 4 - Import your Updates
Click **Start Update** to import your updates. The import process may take a few minutes based on the number of records and updates per record. During this time, you will see one or more of the following alerts indicating the progress of your Import.
### Alerts during the Import Process
#### Import Status Alerts
1. Import completed successfully without any errors.
.png)
2. Import was partially successful. Click the **Download Error Report** button to see a list of records with errors, including the cause of the errors.
3. Import completed without updating a single record. Click the **Download Error Report** button to see a list of records with errors, including the cause of the errors.
#### Import Progress
Import consists of a large number of records and is updated in batches. 
#### Refreshing Records
Another **Xyicon User** has imported boundary data updates to the portfolio you are currently working on. A manual refresh is required to get the latest update.
