Clients & Locations

How to Import Location Data

Overview 

You can add many stores at once by importing a data file instead of creating each store by hand. You choose your file, set the delimiter that separates the values in it, and import. FieldPie reads the file and adds the stores to your account. Setting the delimiter correctly is the key step, because it tells FieldPie how to split each row into the right fields. 

Before You Start

You need access to the Store page and permission to import data. Prepare your file first and know which delimiter separates the values in it, so each field is read correctly. 

How to Import Location Data

  1. Click Store in the left navigation menu to open the Store page. 
  1. Click the import icon in the top-right corner. 
  1. Click Choose File and select the data file you want to import. 
  1. Click Next to continue. 
  1. Click the pencil icon to open the delimiter options for your file. 
  1. Enter the delimiter character, repeating for each delimiter setting as needed. 
  1. Click Next to move to the final step. 
  1. Click Import Data to import your store data. 

Tips and Things to Know

  • The delimiter is the character that separates values—set it so each field lands correctly. 
  • Importing is designed for adding stores in bulk, so put them all in one file. 
  • Double-check the file’s columns match the store fields you expect. 
  • Keep coordinates in the file so imported stores appear on the map. 

Frequently Asked Questions

It’s the character that separates values in your file; setting it lets FieldPie split each row into the right fields.

Yes. Prepare all your stores in a single file, set the delimiter, and import them together.

Yes, if the file includes their latitude and longitude.