---
title: How to Import Locations via Excel
description: "Locations in Precoro are used to: Separate your costs by the locations for which purchases will be made Configure approval workflows depending on locations Limit access to documents. You can add locat"
---

[Skip to content](https://help.precoro.com/how-to-import-locations#main-content)

[Contact us](https://help.precoro.com/kb-tickets/new?hsLang=en) [Customer portal](https://help.precoro.com/tickets-view?hsLang=en)

[![Property 1=Default](https://help.precoro.com/hubfs/Property%201=Default.svg)](https://app.precoro.com/login)

Open main navigation

Close main navigation

- [Contact us](https://help.precoro.com/kb-tickets/new)
- [Customer portal](https://help.precoro.com/tickets-view)
- [Contact Us](https://share.hsforms.com/1-5JilMA_Qv6AOSVjFtNhDg14slf)

[Contact Us](https://share.hsforms.com/1-5JilMA_Qv6AOSVjFtNhDg14slf)

 Hi there! How can we help you today?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://help.precoro.com/?hsLang=en)
2. [Precoro Setup](https://help.precoro.com/precoro-setup?hsLang=en)
3. [Location Management](https://help.precoro.com/precoro-setup?hsLang=en#location-management)

# How to Import Locations via Excel

## Learn how to import locations via Excel.

Locations in Precoro are used to:

- Separate your costs by the locations for which purchases will be made
- Configure approval workflows depending on locations
- Limit access to documents.

You can add locations in two ways: manually adding one by one or importing in bulk.

To add a location manually, you need to click on the **Add Location** button and enter all the necessary information.

To add a location manually, please follow [this](https://help.precoro.com/how-to-add-locations-edit-location-information?hsLang=en) link for more instructions.

**To import locations:**

1. Go to the configuration tab and click on the **Location Management** button. 
2. Press **Import Locations** and follow the instructions: 

- Download a template and fill out the required information. The **Name** of the Location is mandatory.
- Make sure there are no duplicates of the **Name** or **Unique Code** value.
- The file format should be **XLSX**.

- [Precoro Setup](https://help.precoro.com/precoro-setup?hsLang=en#main-content)
  
  
  
  
  
    - [Configurations](https://help.precoro.com/precoro-setup?hsLang=en#configurations)
    - [User Management](https://help.precoro.com/precoro-setup?hsLang=en#user-management)
    - [Custom Fields and Forms](https://help.precoro.com/precoro-setup?hsLang=en#custom-fields-and-forms)
    - [Supplier management](https://help.precoro.com/precoro-setup?hsLang=en#supplier-management)
    - [Working with Items](https://help.precoro.com/precoro-setup?hsLang=en#working-with-items)
    - [Approval Workflow](https://help.precoro.com/precoro-setup?hsLang=en#approval-workflow)
    - [Location Management](https://help.precoro.com/precoro-setup?hsLang=en#location-management)
    - [Precoro Payments](https://help.precoro.com/precoro-setup?hsLang=en#precoro-payments)
    - [Two-factor authentication](https://help.precoro.com/precoro-setup?hsLang=en#two-factor-authentication)
    - [Security](https://help.precoro.com/precoro-setup?hsLang=en#security)
    - [US Based Server](https://help.precoro.com/precoro-setup?hsLang=en#us-based-server)
- [How to use Precoro](https://help.precoro.com/how-to-use-precoro?hsLang=en#main-content)
  
  
  
  
  
    - [Warehouse Requests](https://help.precoro.com/how-to-use-precoro?hsLang=en#warehouse-requests)
    - [Requests for Proposals](https://help.precoro.com/how-to-use-precoro?hsLang=en#requests-for-proposals)
    - [Purchase Requisitions](https://help.precoro.com/how-to-use-precoro?hsLang=en#purchase-requisitions)
    - [Purchase Orders](https://help.precoro.com/how-to-use-precoro?hsLang=en#purchase-orders)
    - [Service Orders](https://help.precoro.com/how-to-use-precoro?hsLang=en#service-orders)
    - [Receipts](https://help.precoro.com/how-to-use-precoro?hsLang=en#receipts)
    - [Invoices](https://help.precoro.com/how-to-use-precoro?hsLang=en#invoices)
    - [Expenses](https://help.precoro.com/how-to-use-precoro?hsLang=en#expenses)
    - [Budgeting](https://help.precoro.com/how-to-use-precoro?hsLang=en#budgeting)
    - [Inventory](https://help.precoro.com/how-to-use-precoro?hsLang=en#inventory)
    - [Reports](https://help.precoro.com/how-to-use-precoro?hsLang=en#reports)
    - [AP Inbox and Intelligent AP Automation](https://help.precoro.com/how-to-use-precoro?hsLang=en#ap-inbox-and-intelligent-ap-automation)
    - [Working with documents](https://help.precoro.com/how-to-use-precoro?hsLang=en#working-with-documents)
    - [Suppliers Portal](https://help.precoro.com/how-to-use-precoro?hsLang=en#suppliers-portal)
    - [Supplier Registration](https://help.precoro.com/how-to-use-precoro?hsLang=en#supplier-registration)
    - [Attachments, Filters, and Search](https://help.precoro.com/how-to-use-precoro?hsLang=en#attachments-filters-and-search)
    - [Mobile App](https://help.precoro.com/how-to-use-precoro?hsLang=en#mobile-app)
    - [FAQs and Troubleshooting](https://help.precoro.com/how-to-use-precoro?hsLang=en#faqs-and-troubleshooting)
- [Precoro Integrations](https://help.precoro.com/precoro-integrations?hsLang=en#main-content)
  
  
  
  
  
    - [QuickBooks Online Integration](https://help.precoro.com/precoro-integrations?hsLang=en#quickbooks-online-integration)
    - [NetSuite Integration](https://help.precoro.com/precoro-integrations?hsLang=en#netsuite-integration)
    - [Xero Integration](https://help.precoro.com/precoro-integrations?hsLang=en#xero-integration)
    - [API Requests and Webhooks](https://help.precoro.com/precoro-integrations?hsLang=en#api-requests-and-webhooks)
    - [SSO Setting](https://help.precoro.com/precoro-integrations?hsLang=en#sso-setting)
    - [Google Integration](https://help.precoro.com/precoro-integrations?hsLang=en#google-integration)
    - [Power BI](https://help.precoro.com/precoro-integrations?hsLang=en#power-bi)
    - [Integration with Slack](https://help.precoro.com/precoro-integrations?hsLang=en#integration-with-slack)
    - [PunchOut Catalogs](https://help.precoro.com/precoro-integrations?hsLang=en#punchout-catalogs)
    - [Integrations via Connectors](https://help.precoro.com/precoro-integrations?hsLang=en#integrations-via-connectors)
    - [Bill.com Integration](https://help.precoro.com/precoro-integrations?hsLang=en#bill-com-integration)
- [Precoro Updates](https://help.precoro.com/precoro-updates?hsLang=en#main-content)
  
  
  
  
  
    - [Releases, 2026](https://help.precoro.com/precoro-updates?hsLang=en#releases-2026)
    - [Releases, 2025](https://help.precoro.com/precoro-updates?hsLang=en#releases-2025)
    - [Releases, 2024](https://help.precoro.com/precoro-updates?hsLang=en#releases-2024)
    - [Releases, 2023](https://help.precoro.com/precoro-updates?hsLang=en#releases-2023)
    - [API Updates](https://help.precoro.com/precoro-updates?hsLang=en#api-updates)
    - [General changes](https://help.precoro.com/precoro-updates?hsLang=en#general-changes)

[![Precoro](https://help.precoro.com/hubfs/Precoro.svg "Precoro")](https://precoro.com/)

<https://www.facebook.com/precoro> <https://x.com/PrecoroHQ> <https://www.youtube.com/@precoro> <https://www.linkedin.com/company/precoro>

Copyright © 2026, Precoro

```json
{
  "@context" : "https://schema.org",
  "@type" : "VideoObject",
  "contentUrl" : "https://1903299.fs1.hubspotusercontent-na1.net/hubfs/1903299/Monosnap%20screencast%202023-07-27%2010-39-16.mp4",
  "dateModified" : "2023-09-05T09:39:18.658Z",
  "duration" : "PT23S",
  "height" : 1240,
  "name" : "Monosnap screencast 2023-07-27 10-39-16",
  "thumbnailUrl" : "https://1903299.fs1.hubspotusercontent-na1.net/hubfs/1903299/Monosnap%20screencast%202023-07-27%2010-39-16.mp4/medium.jpg",
  "uploadDate" : "2023-07-27T07:41:26.131Z",
  "width" : 2220
}
```