How to separate an excel Geocode import

127
1
08-29-2019 01:35 PM
Highlighted
New Contributor

How can you import multiple address from an excel sheet and add a separator? I have a list of businesses and a list of our Company Branches; I would like to put a different icon for the businesses and our Locations. I wonder if there is somewhere to do it by Type of Company/Address?

Ideas?

Tags (1)
Reply
0 Kudos
1 Reply
Highlighted
Occasional Contributor

Good Afternoon Andy, 

Thank you for your inquiry! From your post, I can identify 3 potential workflows. Can you help clarify for me the following (my questions are in bold):

  1. How can you import multiple addresses from an excel sheet and add a separator?
    • Do you have the addresses in excel currently? or do you need to import address into excel?
    • Here is the online documentation on adding a map using excel
    • What do you mean by separator? See examples below: 
      • One address per cell 
      • Two address with separator
  2. I would like to put a different icon for the businesses and our Locations?
    • Are you wanting to use your own image? In Maps for Office, see Style Layers > style by location (single symbol) > Advance options > Use a custom image > 
    • Or our styling options See Choose a layer theme
  3. I wonder if there is somewhere to do it by Type of Company/Address?
    • You may add data using an address but ensure it is in the recommended format, keeping in mind there is an associated cost to geocode {40 credits per 1,000 geocodes}.

I hope this was helpful! Please let me know if you have any other questions. 

Best, 

Shannon | Product Engineer

Reply
0 Kudos