Locations Import
The locations import allows you to import multiple locations into the system simultaneously. This is particularly useful during initial setup or when building a multi-location organization.
info
Data import is only available with a paid subscription.
Access
Navigate to General → Data → Imports and select "Locations" as the import type.
Excel Template
The locations import template contains the following fields:
Required Fields
- Street - Street name (required field)
- Street Number - House number including additions (required field)
- Postal Code - Postal code of the location (required field)
- City - Name of the city (required field)
- Country - Country code (e.g. DE for Germany) (required field)
- Main Location - Is this the main location? (Yes/No)
Important Notes
Only One Main Location
- There can only be one main location
- If you import a new main location, the previous one automatically becomes a secondary location
- Check your main location marking before import
Format Requirements
- Street: Maximum 100 characters
- Street Number: Maximum 20 characters (including letters like 1A, 22B)
- Postal Code: 5 digits for Germany (varies by country)
- City: Maximum 100 characters
- Country: 2-letter ISO country code (DE, AT, CH, etc.)
- Main Location: Only "Yes" or "No"
Import Process
-
Download Template
- Download the locations template
- The template contains sample data for guidance
-
Enter Data
- Fill in all address fields completely
- One location per row
- Mark exactly one main location with "Yes"
-
Upload File
- Upload the file
Sample Data
| Street | Street Number | Postal Code | City | Country | Main Location |
|---|---|---|---|---|---|
| Musterstraße | 1A | 12345 | Musterstadt | DE | Yes |
| Hauptstraße | 10 | 67890 | Hauptstadt | DE | No |
| Nebenstraße | 22B | 54321 | Nebenstadt | DE | No |
| Station Road | 5 | 10115 | Berlin | DE | No |
| Market Square | 1 | 80331 | Munich | DE | No |
Error Handling
Common Errors
| Error Message | Cause | Solution |
|---|---|---|
| "Location already exists" | Duplicate address | Check existing locations |
| "Invalid country code" | Wrong country format | Use 2-letter ISO codes |
| "Multiple main locations" | More than one "Yes" for main location | Mark only one main location |
| "Required field missing" | Address field not filled | Fill all required fields |
| "Invalid postal code" | Format doesn't match country | Check postal code format |
After Import
- Check imported locations under Settings → Company → Locations
- Assign locations to employees
- Configure location-specific holidays
- Optionally upload location images
Tips
Best Practice
- Import locations before employees
- Use consistent spelling for cities
- Document location abbreviations for internal use
- Verify country codes in advance
Important for Holiday Calculation
The correct specification of country and state is essential for automatic holiday calculation. These can be added in the location settings after import.
Back to Import Overview →