How does importer column mapping work?

Our importer does not require you to pre-format your data into a specific format. You can import from any kind of spreadsheet — the most important thing to remember is that your very first row should be the header. However, if you're starting from scratch, we also have a sample document available.

To help us understand your data, we need to know what each column in your document is:

  • full address — this tells us that this column contains your full address (eg: 123 Peachtree St, Atlanta, GA 30303, USA)
  • address 1 + city + state + country — select these fields if your addresses are split up. We'll join them together to geocode your location.
  • address 2 — optional second line of the address that might help us geocode (eg: Greenville Area).
  • postal code — a zip code (eg: 94105)
  • location name — the name of your location (eg: Trader Joe's)
  • markers — each location is associated with one marker. If the marker already exists, we'll link to it; otherwise, it'll be created first (eg: Marker 1)
  • hourshours of operation (eg: Mon 10:00 AM-9:00 PM,Tue 9:30 AM-7:30 PM).
  • filters — comma-separated list of filters (eg: Filter 1, Filter 2, Filter 3)
  • retailers — comma-separate list of retailers. If the retailers don't exist yet, they'll be automatically created (eg: Retailer 1, Retailer 2, Retailer 3)
  • display address — some addresses are better understood by computers rather than people. Our geocoder prefers numeric street addresses (eg: 865 Market St, San Francisco, CA 94103); however, you might want to display a more user-friendly address instead (eg: Westfield Mall, San Francisco, CA 94103). This column should have the full display address that will be visible to your locator users.
  • contact person — the names of people to contact (eg: William Steig, Mr Rogers)
  • phone — phone number in any format (eg: 555-415-1234)
  • fax — fax number in any format (eg: 555-415-1234)
  • phone data — ZenLocator supports up to 3 phone numbers. If you'd like to upload all 3, use the following JSON array format: [{"prefix":"Phone 1","number":"555-415-1234"},{"prefix":"Phone 2","number":"555-415-1235"},{"prefix":"Phone 3","number":"555-415-1236"}]
  • email — email address (eg: john@example.com)
  • website — a complete website URL (eg: https://www.example.com/locations)
  • custom text — a brief text description of the location up to 2,000 characters. Note that HTML is not supported (eg: This location has kiwis!)
  • reference id — a unique ID for your location. If you don't provide any, ZenLocator will automatically assign one.
  • photos — a comma-separated list of URLs to your photos. WARNING: if you map this field, be sure to always provide image URLs for each location because we will delete all previous images before re-uploading! We support JPG and PNG images (eg: https://www.example.com/image1.jpg, https://www.example.com/image2.png).
  • appointment url — if your location accepts appointments, this is a place for that URL (eg: https://example.com/schedule-an-appointment)
  • custom data — each location can have up to 3 custom fields that can be used in custom marker HTML. The format should be a JSON object with a maximum of 3 keys: {"key1":"Value 1","key2":"Value 2","key3":"Value 3"}
  • latitude & longitude — if you already have your own coordinates, we can use those instead (eg: 37.778107 for latitude; -122.455856 for longitude). Do not combine them into one column; each column should have either a latitude or a longitude.
Was this article helpful? /
How can we improve this page?
This feedback is used only to improve this support page. Please email us directly at support@zenlocator.com if you'd like assistance.