Import/Update Locations via Excel

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

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.