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):
- 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
- 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
- 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