How to separate an excel Geocode import

[AndyNoble]

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?

[ShannonChavez]

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