--- title: How do I create an import template for location and room lists? description: You can find out here how you can create an interface to your existing room lists. --- [Skip to content](https://support.seventhings.com/migration/en/how-do-i-create-an-import-template-for-location-and-room-lists#main-content) - [English](https://support.seventhings.com/migration/en/how-do-i-create-an-import-template-for-location-and-room-lists) - [Deutsch](https://support.seventhings.com/migration/vorlage-für-import-standorte) English Show submenu for translations ![seventhings.png\]](https://support.seventhings.com/hs-fs/hubfs/seventhings.png?height=30&name=seventhings.png) - [Default HubSpot Blog](https://blog.seventhings.com/de) Open main navigation Close main navigation - [Default HubSpot Blog](https://blog.seventhings.com/de) - - [English](https://support.seventhings.com/migration/en/how-do-i-create-an-import-template-for-location-and-room-lists) - [Deutsch](https://support.seventhings.com/migration/vorlage-für-import-standorte) English Show submenu for translations - www.seventhings.com/en www.seventhings.com/en Need some help? - There are no suggestions because the search field is empty. 1. [Support & Knowledge Base](https://support.seventhings.com/migration/en?hsLang=en) 2. [Import & Export](https://support.seventhings.com/migration/en/import-export?hsLang=en) 3. [Imports Locations](https://support.seventhings.com/migration/en/import-export?hsLang=en#imports-locations) # How do I create an import template for location and room lists? ## You can find out here how you can create an interface to your existing room lists. ---   Before you can import data from your previous systems, you have to create an import template. In this you specify which data should be transferred and which fields are required. so you don't have to import all fields of your import file.   That's how it works: We'll show you the complete import process including a video tutorial [**here**](https://support.seventhings.com/en/how-do-i-import-my-existing-objects-list-into-seventhings?hsLang=en).   1\. Go to the **Import/Export menu** 2\. Click on the **Locations** tab and then on **File Format** 3\. Click the **Create** button ![](https://support.seventhings.com/hs-fs/hubfs/image-png-Apr-14-2021-11-21-40-67-AM.png?width=518&name=image-png-Apr-14-2021-11-21-40-67-AM.png)   4\. Choose Import   5\. Drag & drop your template file into the window (see below) or click in the window and select the template file, then click on **Continue** Note that the template file must be in **.csv format** so that there are no complications or misrepresentations in the upload. ![](https://support.seventhings.com/hs-fs/hubfs/image-png-Apr-14-2021-10-20-11-07-AM.png?width=550&name=image-png-Apr-14-2021-10-20-11-07-AM.png)   6\. **Select your options** in the preview and give the template a **name** You can set whether the template should use the first line as a heading, which separator should be used and whether empty fields in the template should overwrite existing fields.   7\. When mapping, **assign** all seventhings fields to the corresponding fields in the import file. To do this, **drag** the seventhings fields on the left to the corresponding position in the middle. ![](https://support.seventhings.com/hubfs/image-png-Feb-24-2021-07-22-55-84-AM.png)   Note that you cannot create any new fields here. So make sure **in advance** that you have already created all the fields to be imported in the inventory manager. You can remove fields from the import file using the cross if you do not want to import them. Note that you only drag the **identical field types** (text, number, date, ...) next to each other. If the field type of an import field is incorrect, you can set the **category manually.** To do this, simply double-click on the field. ![](https://support.seventhings.com/hs-fs/hubfs/image-png-Nov-06-2020-09-45-45-57-AM.png?width=561&name=image-png-Nov-06-2020-09-45-45-57-AM.png) Then select the appropriate field type here.   8\. Choose a **key field** **Note**: The key field is used to uniquely assign the import fields to the seventhings fields. If all the rooms in the different locations have different room numbers, it makes sense to select the room number as a key field, as this allows a one-to-one assignment.   Do you have several locations, e.g. In buildings in which there are rooms with the **same room number**, you have to select **both the location and the room number** as the **key field** in order to guarantee a unique assignment. Also note that the import **overwrites** all existing fields (including those that you have defined as "Not editable" in the field definitions). If you do not want to overwrite a field during import, make sure not to drag this field into the middle when mapping.   9\. Confirm your entries with **Finish** - [FAQ's](https://support.seventhings.com/migration/en/faqs?hsLang=en#main-content) - [App](https://support.seventhings.com/migration/en/faqs?hsLang=en#app) - [Labels](https://support.seventhings.com/migration/en/faqs?hsLang=en#labels) - [Web App](https://support.seventhings.com/migration/en/faqs?hsLang=en#web-app) - [Configuration of data fields](https://support.seventhings.com/migration/en/faqs?hsLang=en#configuration-of-data-fields) - [General](https://support.seventhings.com/migration/en/faqs?hsLang=en#general) - [Data Protection](https://support.seventhings.com/migration/en/faqs?hsLang=en#data-protection) - [Import and Export](https://support.seventhings.com/migration/en/faqs?hsLang=en#import-and-export) - [Training](https://support.seventhings.com/migration/en/training?hsLang=en) - [seventhings App](https://support.seventhings.com/migration/en/seventhings-app?hsLang=en#main-content) - [General](https://support.seventhings.com/migration/en/seventhings-app?hsLang=en#general) - [Download & Setup](https://support.seventhings.com/migration/en/seventhings-app?hsLang=en#download-setup) - [Pre-selection location](https://support.seventhings.com/migration/en/seventhings-app?hsLang=en#pre-selection-location) - [Scan](https://support.seventhings.com/migration/en/seventhings-app?hsLang=en#scan) - [Statistics display](https://support.seventhings.com/migration/en/seventhings-app?hsLang=en#statistics-display) - [Detail view](https://support.seventhings.com/migration/en/seventhings-app?hsLang=en#detail-view) - [Settings](https://support.seventhings.com/migration/en/seventhings-app?hsLang=en#settings) - [Dashboard](https://support.seventhings.com/migration/en/dashboard?hsLang=en#main-content) - [How does it work?](https://support.seventhings.com/migration/en/dashboard?hsLang=en#how-does-it-work) - [Objects](https://support.seventhings.com/migration/en/objects?hsLang=en#main-content) - [Layout & Structure](https://support.seventhings.com/migration/en/objects?hsLang=en#layout-structure) - [Create & Edit objects](https://support.seventhings.com/migration/en/objects?hsLang=en#create-edit-objects) - [Mass functions](https://support.seventhings.com/migration/en/objects?hsLang=en#mass-functions) - [Filters](https://support.seventhings.com/migration/en/objects?hsLang=en#filters) - [Columns & Download](https://support.seventhings.com/migration/en/objects?hsLang=en#columns-download) - [Locations and rooms](https://support.seventhings.com/migration/en/locations-and-rooms?hsLang=en#main-content) - [General](https://support.seventhings.com/migration/en/locations-and-rooms?hsLang=en#general) - [Locations](https://support.seventhings.com/migration/en/locations-and-rooms?hsLang=en#locations) - [Rooms](https://support.seventhings.com/migration/en/locations-and-rooms?hsLang=en#rooms) - [Import & Export](https://support.seventhings.com/migration/en/import-export?hsLang=en#main-content) - [Import Objects](https://support.seventhings.com/migration/en/import-export?hsLang=en#import-objects) - [Imports Locations](https://support.seventhings.com/migration/en/import-export?hsLang=en#imports-locations) - [Export Objects](https://support.seventhings.com/migration/en/import-export?hsLang=en#export-objects) - [Settings](https://support.seventhings.com/migration/en/settings?hsLang=en#main-content) - [Field definition objects](https://support.seventhings.com/migration/en/settings?hsLang=en#field-definition-objects) - [Field definition locations](https://support.seventhings.com/migration/en/settings?hsLang=en#field-definition-locations) - [User](https://support.seventhings.com/migration/en/settings?hsLang=en#user) - [Circularity Hub](https://support.seventhings.com/migration/en/circularity-hub?hsLang=en#main-content) - [General](https://support.seventhings.com/migration/en/circularity-hub?hsLang=en#general) - [For IT- and Office-Managers](https://support.seventhings.com/migration/en/circularity-hub?hsLang=en#for-it-and-office-managers) - [For Buyers](https://support.seventhings.com/migration/en/circularity-hub?hsLang=en#for-buyers) - [Scanner](https://support.seventhings.com/migration/en/scanner?hsLang=en#main-content) - [RFID - scanner](https://support.seventhings.com/migration/en/scanner?hsLang=en#rfid-scanner) - [ZEBRA CS6080](https://support.seventhings.com/migration/en/scanner?hsLang=en#zebra-cs6080) - [Profile & User](https://support.seventhings.com/migration/en/profile-user?hsLang=en#main-content) - [Profile](https://support.seventhings.com/migration/en/profile-user?hsLang=en#profile) - [Profile settings](https://support.seventhings.com/migration/en/profile-user?hsLang=en#profile-settings) - [Release Notes](https://support.seventhings.com/migration/en/release-notes?hsLang=en#main-content) - [2023](https://support.seventhings.com/migration/en/release-notes?hsLang=en#2023) - [2022](https://support.seventhings.com/migration/en/release-notes?hsLang=en#2022) - [2021](https://support.seventhings.com/migration/en/release-notes?hsLang=en#2021) - [Interfaces](https://support.seventhings.com/migration/en/interfaces?hsLang=en#main-content) - [Accounting systems](https://support.seventhings.com/migration/en/interfaces?hsLang=en#accounting-systems) - [API](https://support.seventhings.com/migration/en/interfaces?hsLang=en#api) - [Onboardings](https://support.seventhings.com/migration/en/onboardings?hsLang=en#main-content) - [step-by-step introduction](https://support.seventhings.com/migration/en/onboardings?hsLang=en#step-by-step-introduction) - [Default HubSpot Blog](https://blog.seventhings.com/de) [![seventhings – Einfach Übersicht.](https://support.seventhings.com/hs-fs/hubfs/Website/Images/seventhings-logo-longformat.png?width=200&height=44&name=seventhings-logo-longformat.png "seventhings – Einfach Übersicht.")](https://www.seventhings.com?hsLang=en) Copyright © 2020 ITEXIA GmbH Copyright © 2026, seventhings GmbH