> For the complete documentation index, see [llms.txt](https://hub.equipme.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://hub.equipme.io/equipme/my-company/locations/import-update-locations-via-excel.md).

# Import/Update Locations via Excel

{% embed url="<https://my-workspace-iig.share.arcade.software/share/3SNhh6Q7dNSSFljWXWdP>" %}

When your organization manages only a few locations, adding them manually in **Locations → Add Location** is usually the quickest and most practical approach. An XLSX import becomes useful once the number of locations grows or when your data already exists in spreadsheets and needs to be brought into equipme in a structured way.

The import relies on a formatted XLSX file that includes all fields relevant for a location. A sample file is always provided in the import dialog, so you can download it and follow the structure directly. The file shows both required information and optional attributes that can enrich each location.

#### Country validation through ISO-2 codes

The sample file also includes a country field that expects an **ISO-2 country code** — meaning two letters, such as *DE*, *US*, *NL*, *FR*.\
equipme validates this automatically. If the value doesn’t match a valid ISO-2 code, the import will flag it so you can correct it before completing the process. This ensures consistent data quality across all your locations, even when preparing lists from external sources.

#### Optional and custom attributes

Depending on how you organize your data, you may include additional fields such as cost center, manager information, or other values specific to your workflow. These appear in the sample file as additional columns and are validated the same way as the standard fields.\
They give you flexibility without forcing complexity — you can use them if you need them, or leave them out entirely.

#### Updating Existing Locations

<figure><img src="/files/InvRYQLvFCZJyNKdsF1Q" alt=""><figcaption></figcaption></figure>

If you plan to update multiple locations at once, the most reliable workflow is to start with an **export** of your current locations. The exported XLSX file contains all existing records including their internal **Location IDs**. Those IDs are essential, because they tell equipme which entry should be updated during an import.

Working directly with the exported file avoids formatting mistakes and ensures that all IDs remain untouched. You can adjust any fields and then re-import the modified file. equipme matches each row to the correct location based on its ID and applies your updates automatically.

**If you want to add new locations in the same file, simply leave the ID field empty for those rows. equipme will generate IDs for them during the import while still updating the existing locations correctly.** This combined approach keeps everything consistent and prevents accidental duplicates.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://hub.equipme.io/equipme/my-company/locations/import-update-locations-via-excel.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
