--- title: Manage Locations using a Spreadsheet description: Manage Locations using a Spreadsheet --- [Skip to content](https://info.vueops.com/knowledge/manage-locations-using-a-spreadsheet#main-content) English Show submenu for translations [Request Help](https://info.vueops.com/knowledge/kb-tickets/new?hsLang=en) ![branding-blue-tagline.svg\]](https://info.vueops.com/hubfs/Imported%20images/branding-blue-tagline.svg) Open main navigation Close main navigation - English Show submenu for translations - [Request Help](https://info.vueops.com/knowledge/kb-tickets/new) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [VueOps Help Center](https://info.vueops.com/knowledge?hsLang=en) 2. [Locations](https://info.vueops.com/knowledge/locations?hsLang=en) # Manage Locations using a Spreadsheet You can use spreadsheets to [upload Locations for the first time](https://info.vueops.com/knowledge/manage-locations-using-a-spreadsheet#import-locations-first-time), or [make changes to your existing Locations structure.](https://info.vueops.com/knowledge/manage-locations-using-a-spreadsheet#update-locations-spreadsheet) ### Importing Locations for the first time If you are importing Locations for the first time, download the import template by selecting '**Add**', '**Spreadsheet**', and '**Download Import Template**'. ![](https://info.vueops.com/hs-fs/hubfs/image-png-Jun-03-2024-04-56-57-5153-PM.png?width=688&height=263&name=image-png-Jun-03-2024-04-56-57-5153-PM.png) ![](https://info.vueops.com/hs-fs/hubfs/image-png-Jun-03-2024-04-57-40-8014-PM.png?width=688&height=208&name=image-png-Jun-03-2024-04-57-40-8014-PM.png) Click here to jump to '[Understanding the Spreadsheet](https://info.vueops.com/knowledge/manage-locations-using-a-spreadsheet#understanding-the-spreadsheet)'. ### Updating existing Locations via Spreadsheet To make changes to your existing Locations structure (including deleting locations), or to edit Locations in bulk, first you'll need to**[Export Locations](https://info.vueops.com/knowledge/export-locations?hsLang=en)** so you can edit the spreadsheet and [re-upload it to SiteLine](https://info.vueops.com/knowledge/manage-locations-using-a-spreadsheet#uploading-the-spreadsheet).   *Note: To edit an individual Location, see [Edit a Location in SiteLine](https://info.vueops.com/knowledge/edit-location-in-vueops?hsLang=en).*   **Understanding the Location Spreadsheet** There are 2 rows at the top of the spreadsheet that contain column labels.  Do not make any changes to these rows.  Each row of the spreadsheet below the column labels represents a new location. Each location has a number of 'Common Attributes' - these are pre-defined and represent the standard information for each location. You can also add custom attributes for any location.  **4 of the common attributes are mandatory** (marked with a red asterisk in the column label): - **Type:** Define whether this Location is a building, floor or room. - **Parent Location:** Specify which floor or building a location belongs to. *Note: Parent Location is only a mandatory field for floors and rooms, you should leave this field blank if the row is a building.* - **Operating Location:** The name of the Location as it appears in architectural drawings. *Note: Operating Location acts as a Location ID in SiteLine, so these entries must be unique*. - **Name:** The name of the Location as you'd like it to appear in the Locations Module in SiteLine. For more information on how you can use the other common attributes to further organize your Locations, see**[Locations: Overview](https://info.vueops.com/knowledge/understanding-locations-module?hsLang=en).** Once you've populated the spreadsheet with your Location data, save it and head back to SiteLine to upload it.  ### Uploading the Spreadsheet To upload your completed Spreadsheet, select '**Add**', then '**Spreadsheet**' from the Locations Module.  ![](https://info.vueops.com/hs-fs/hubfs/image-png-Jun-03-2024-04-56-57-5153-PM.png?width=688&height=263&name=image-png-Jun-03-2024-04-56-57-5153-PM.png) Using the upload window that appears, select '**Choose file**' and select your Spreadsheet. ![](https://info.vueops.com/hs-fs/hubfs/image-png-Jun-03-2024-06-17-27-0883-PM.png?width=688&height=213&name=image-png-Jun-03-2024-06-17-27-0883-PM.png) Then select 'Upload & Preview' to check and verify any errors. If errors are present in your spreadsheet, SiteLine will display the relevant rows and advise how you should fix them. You should correct the errors in the spreadsheet and try uploading again. ![](https://info.vueops.com/hs-fs/hubfs/image-png-Jun-03-2024-06-21-44-9383-PM.png?width=688&height=281&name=image-png-Jun-03-2024-06-21-44-9383-PM.png)   When your import file is free of errors, click the 'Import' to complete the upload. A confirmation message will appear.  Depending on the number of locations in your upload file, SiteLine will take a few minutes to process the file.  The Locations page will refresh automatically once the upload is complete. ![](https://info.vueops.com/hs-fs/hubfs/image-png-Jun-03-2024-06-24-51-6644-PM.png?width=598&height=43&name=image-png-Jun-03-2024-06-24-51-6644-PM.png) - [Documents](https://info.vueops.com/knowledge/documents?hsLang=en#main-content) - [Managing Documents](https://info.vueops.com/knowledge/documents?hsLang=en#managing-documents) - [Collections](https://info.vueops.com/knowledge/documents?hsLang=en#collections) - [Tags](https://info.vueops.com/knowledge/documents?hsLang=en#tags) - [Warranty Tickets](https://info.vueops.com/knowledge/warranty-tickets?hsLang=en#main-content) - [Manage Tickets](https://info.vueops.com/knowledge/warranty-tickets?hsLang=en#manage-tickets) - [Set Up](https://info.vueops.com/knowledge/warranty-tickets?hsLang=en#set-up) - [contractor](https://info.vueops.com/knowledge/warranty-tickets?hsLang=en#contractor) - [Trade Partner](https://info.vueops.com/knowledge/warranty-tickets?hsLang=en#trade-partner) - [Drawings](https://info.vueops.com/knowledge/drawings?hsLang=en) - [Users](https://info.vueops.com/knowledge/users?hsLang=en#main-content) - [User Accounts](https://info.vueops.com/knowledge/users?hsLang=en#user-accounts) - [User Access](https://info.vueops.com/knowledge/users?hsLang=en#user-access) - [Manage Users](https://info.vueops.com/knowledge/users?hsLang=en#manage-users) - [Permission Levels and Scope](https://info.vueops.com/knowledge/users?hsLang=en#permission-levels-and-scope) - [Locations](https://info.vueops.com/knowledge/locations?hsLang=en#main-content) - [Location Configuration](https://info.vueops.com/knowledge/locations?hsLang=en#location-configuration) - [Location Management & Operations](https://info.vueops.com/knowledge/locations?hsLang=en#location-management-operations) - [Location Insights](https://info.vueops.com/knowledge/locations?hsLang=en#location-insights) - [Assets](https://info.vueops.com/knowledge/assets?hsLang=en#main-content) - [Asset Insights](https://info.vueops.com/knowledge/assets?hsLang=en#asset-insights) - [Asset Configuration](https://info.vueops.com/knowledge/assets?hsLang=en#asset-configuration) - [Asset Operations](https://info.vueops.com/knowledge/assets?hsLang=en#asset-operations) - [Models](https://info.vueops.com/knowledge/models?hsLang=en#main-content) - [Model Management](https://info.vueops.com/knowledge/models?hsLang=en#model-management) - [Model Views](https://info.vueops.com/knowledge/models?hsLang=en#model-views) - [Model Viewer](https://info.vueops.com/knowledge/models?hsLang=en#model-viewer) - [Viewer Enhancements](https://info.vueops.com/knowledge/models?hsLang=en#viewer-enhancements) - [Model Set](https://info.vueops.com/knowledge/models?hsLang=en#model-set) - [Connecting to External Applications](https://info.vueops.com/knowledge/connecting-to-external-applications?hsLang=en) - [FAQ](https://info.vueops.com/knowledge/faq?hsLang=en) - [SiteLine Administration](https://info.vueops.com/knowledge/siteline-administration?hsLang=en#main-content) - [Projects](https://info.vueops.com/knowledge/siteline-administration?hsLang=en#projects) - [SiteLine on Mobile Devices](https://info.vueops.com/knowledge/siteline-on-mobile-devices?hsLang=en) - [Procedures](https://info.vueops.com/knowledge/procedures?hsLang=en#main-content) - [What is a Procedure?](https://info.vueops.com/knowledge/procedures?hsLang=en#what-is-a-procedure) - [Procedure Operations](https://info.vueops.com/knowledge/procedures?hsLang=en#procedure-operations) - [Programs](https://info.vueops.com/knowledge/programs?hsLang=en#main-content) - [What is a Program?](https://info.vueops.com/knowledge/programs?hsLang=en#what-is-a-program) - [Program Management](https://info.vueops.com/knowledge/programs?hsLang=en#program-management) - [Service Requests](https://info.vueops.com/knowledge/service-requests?hsLang=en#main-content) - [What is a Service Request?](https://info.vueops.com/knowledge/service-requests?hsLang=en#what-is-a-service-request) - [Service Request Management](https://info.vueops.com/knowledge/service-requests?hsLang=en#service-request-management) - [Work Orders](https://info.vueops.com/knowledge/work-orders?hsLang=en#main-content) - [Work Order Fundamentals](https://info.vueops.com/knowledge/work-orders?hsLang=en#work-order-fundamentals) - [Work Order Operations](https://info.vueops.com/knowledge/work-orders?hsLang=en#work-order-operations) [![Chill listening crop-3](https://info.vueops.com/hubfs/branding-blue-tagline-2.svg "Chill listening crop-3")](https://vueops.com) VueOps SiteLine Help Center Copyright © 2026, VueOps